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 strong commitment to sustainability.
- Benefits: Gain hands-on experience, mentorship, and exposure to the petroleum industry.
- Other info: Collaborate with experts and enhance your career in a supportive team.
- Why this job: Make an impact by contributing to data-driven decisions in a dynamic environment.
- 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 Intern in London employer: Perenco
Contact Detail:
Perenco Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst Intern in 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 important it is to make connections that could lead to job opportunities.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your SQL and Python skills. We recommend doing mock interviews with friends or using online platforms to boost your confidence.
✨Tip Number 3
Don’t just apply anywhere; focus on companies that align with your values and interests, like Perenco. We suggest using our website to find roles that excite you and fit your skill set.
✨Tip Number 4
Follow up after interviews! A simple thank-you email can go a long way. It shows your enthusiasm and keeps you fresh in their minds. We believe this small gesture can make a big difference.
We think you need these skills to ace Data Analyst Intern in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst Intern role. Highlight your SQL skills, Python experience, and any relevant projects or coursework that showcase your analytical abilities. We want to see how you fit into our team!
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 your background aligns with our needs at Perenco. Keep it concise but engaging – we love a good story!
Showcase Your Projects: If you've worked on any relevant projects, whether in school or on your own, make sure to mention them. Include details about your use of Power BI, SQL, or Python. We’re keen to see what you can bring to the table!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re serious about joining our team at Perenco!
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. Practising some sample problems can help you articulate your thought process during the interview.
✨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. Talk about how you've used libraries like Pandas or Numpy in past projects. This will demonstrate your hands-on experience and analytical mindset.
✨Power BI Proficiency is Key
Familiarise yourself with Power BI, especially DAX and data modelling. If you’ve created dashboards before, be ready to discuss your approach and any challenges you faced. Showing your ability to visualise data effectively can set you apart.
✨Understand the Industry Context
While prior knowledge of the petroleum industry isn't required, showing an interest can go a long way. Do a bit of research on Perenco and the role of data in oil and gas operations. This will help you connect your skills to their needs during the interview.