Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support data analysis and develop solutions for petroleum operations using SQL and Python.
- 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: Dynamic work environment with opportunities for growth and learning.
- Why this job: Make an impact in data-driven decision-making while learning from industry experts.
- Qualifications: Pursuing a degree in STEM with strong SQL and analytical skills.
The predicted salary is between 25000 - 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 Sales in City of London employer: Perenco
Contact Detail:
Perenco Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data analyst Sales in City of London
✨Tip Number 1
Network like a pro! Reach out to professionals in the petroleum industry on LinkedIn or at 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 you've worked on. This gives potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis questions and industry-specific 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, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data analyst Sales in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst role at Perenco. 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. Don’t forget to mention your interest in the petroleum industry – it shows you’re keen to learn!
Showcase Your Projects: If you've worked on any relevant projects, whether in school or on your own, make sure to include them. We love seeing practical applications of your skills, especially if they involve SQL, Power BI, or Python. It gives us a glimpse of what you can bring to the table!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s straightforward and ensures your application goes directly to us. Plus, it shows you’re proactive and serious about joining our team!
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 any projects where you've used libraries like Pandas or Numpy, and how they helped you solve real-world problems.
✨Power BI Proficiency is Key
Familiarise yourself with Power BI and be ready to discuss your experience with DAX, data modelling, and visualisation. If you have any dashboards you've created, bring them along or be prepared to describe them in detail. This will show your practical knowledge and creativity.
✨Understand the Industry Context
While prior knowledge of the petroleum industry isn't required, showing an interest can set you apart. Do some research on Perenco and the oil and gas sector. Being able to discuss how data analytics can impact operations in this field will demonstrate your enthusiasm and initiative.