Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support data analysis and develop solutions for global petroleum operations.
- Company: Join Perenco, a leading independent hydrocarbon producer with a global presence.
- Benefits: Gain hands-on experience, mentorship, and exposure to the petroleum industry.
- Other info: Collaborative environment with opportunities for growth and learning.
- Why this job: Make an impact by contributing to data-driven decisions in a dynamic field.
- Qualifications: Pursuing a degree in STEM with strong SQL and analytical skills.
The predicted salary is between 20000 - 30000 £ per year.
The Company
Founded over thirty years ago, Perenco is an independent hydrocarbon producer involved in the entire lifecycle of projects, from exploration to decommissioning. Gross production is approximately 500,000 BOEPD. The group’s strength lies in the technical ingenuity and versatility of its more than 8,500 strong team, who deliver safe and environmentally aware solutions to oil and gas fields around the world. By enhancing and developing local resources, Perenco is proud to support economic growth and social development wherever it works. Perenco operates in 12 partner countries and is based in the United Kingdom.
The Role
We are seeking a motivated Data Analyst Intern to support our global operations. This is a hands-on opportunity to work with databases, develop analytical solutions, and contribute to data-driven decision-making within petroleum operations.
You will collaborate closely with the Production Data Analyst to help maintain database integrity, contribute to application development, build Power BI dashboards, and optimize data workflows. This role offers valuable exposure to data lifecycle management, large-scale data administration, and business intelligence within an industry setting.
Tasks & responsibilities:
- Support SQL database queries for data loading and data extraction.
- Assist with data preprocessing in Python, including data cleaning, transformation, and quality control.
- Contribute to the development and maintenance of Power BI dashboards and reports.
- Support data quality checks and anomaly checks across databases.
- Collaborate with technical teams to translate geoscience requirements into effective data solutions.
- Document data processes and support ongoing database optimization initiatives.
Qualification / Experience / Specification
- Currently pursuing or recently completed a degree in Engineering, Geoscience, Data Science, or related STEM field.
- Strong SQL skills in writing complex queries (Joins, Sub-queries, CTE, etc…).
- Proficiency in Excel and Power BI (DAX, data modelling, visualization).
- Familiarity using Python for its big data capabilities (Pandas, Numpy, Scipy, etc…).
- Comfortable using Github for version control.
- Strong attention to detail and a methodical approach to work.
- Analytical mindset with solid problem-solving abilities.
- General knowledge of Snowflake and dbt is a plus.
- Interest in learning about the petroleum industry (prior O&G knowledge is advantageous but not required).
Data Analyst (English) in City of London employer: Perenco
Contact Detail:
Perenco Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst (English) in City of London
✨Tip Number 1
Network like a pro! Reach out to professionals in the industry on LinkedIn or attend local meetups. We can’t stress enough how valuable personal connections can be in landing that Data Analyst role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries, Power BI dashboards, and any Python projects. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis questions and scenarios. We recommend practising with friends or using mock interview platforms to build your confidence and refine your answers.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Analyst (English) in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst role. Highlight your SQL skills, Python experience, and any relevant projects or coursework. We want to see how your background fits with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and how you can contribute to our team at Perenco. Keep it concise but engaging – we love a good story!
Show Off Your Projects: If you've worked on any relevant projects, whether in school or on your own, make sure to mention them. We’re interested in seeing your analytical skills in action, so don’t hold back on showcasing your work!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Perenco
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries, joins, and sub-queries, as these are crucial for the Data Analyst role. Practising some sample queries can help you feel more confident when discussing your technical abilities.
✨Show Off Your Python Skills
Since you'll be working with data preprocessing in Python, it’s a good idea to have a few examples ready to share. Talk about any projects where you've used libraries like Pandas or Numpy. This will demonstrate your hands-on experience and analytical mindset.
✨Get Familiar with Power BI
Power BI is a key part of the role, so make sure you know how to create dashboards and reports. If you have any previous work or projects that showcase your Power BI skills, bring them along. Being able to discuss your visualisation techniques will impress the interviewers.
✨Research Perenco and the Industry
Take some time to learn about Perenco and its operations in the petroleum industry. Understanding their projects and values will help you tailor your answers and show your genuine interest in the company. Plus, it’ll give you a great context for discussing how your skills can contribute to their goals.