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 City of London employer: Perenco
Contact Detail:
Perenco Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst Intern 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 Intern role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL queries, Power BI dashboards, and any Python projects you've worked on. This gives us a tangible way to see what you can bring to the table.
✨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.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team at Perenco.
We think you need these skills to ace Data Analyst Intern in City of 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!
Show Off Your Projects: If you've worked on any relevant projects, whether in school or on your own, make sure to mention them. Include links to your GitHub or any dashboards you've created in Power BI. We’re keen to see what you can do!
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, as these are crucial for the role. 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 to demonstrate your experience. Talk about how you've used libraries like Pandas or Numpy in past projects, and be ready to explain your approach to data cleaning and transformation.
✨Power BI Proficiency is Key
Familiarise yourself with Power BI and its functionalities, especially DAX and data modelling. If you’ve created dashboards before, bring along examples or be prepared to discuss your design choices and how they contributed to data-driven decision-making.
✨Demonstrate Your Analytical Mindset
During the interview, highlight your problem-solving abilities and attention to detail. Share specific instances where you identified anomalies in data or optimised workflows. This will show that you not only understand the technical aspects but also have the analytical mindset needed for the role.