At a Glance
- Tasks: Design and optimise a Data Warehouse for the oil and gas sector.
- Company: Join a leading organisation in the upstream oil and gas industry.
- Benefits: Enjoy hybrid working options and opportunities for professional growth.
- Why this job: Be part of a dynamic team driving critical analytics and insights.
- Qualifications: Experience as a Data Engineer with strong SQL and data management skills required.
- Other info: Ideal for those passionate about data integrity and automation in a fast-paced environment.
The predicted salary is between 48000 - 84000 £ per year.
A Data Engineer is sought to support the design, management, and optimisation of a Data Warehouse environment for an organisation operating in the upstream oil and gas sector. The successful candidate will lead data integration from key industry systems such as SAP, Energy Components, and PI Process Book, ensuring the accuracy and availability of data for operational and commercial decision-making. Success in this role means delivering a high-performing, validated data environment tailored to the complexities of upstream operations. The role supports business-critical analytics and reporting across technical, commercial, and operational teams.
Data Warehouse Management
- Own and maintain the organisation’s Data Warehouse as a single source of truth.
- Monitor and optimise warehouse performance, scalability, and resilience.
- Develop and implement robust data quality controls, including cleansing and validation processes.
Data Quality & Governance
- Define and enforce governance standards for data consistency, security, and regulatory compliance.
- Maintain detailed audit trails and documentation for all data transformations.
- Identify opportunities for automation and process improvement across the data lifecycle.
Data Integration & Pipeline Management
- Manage data pipelines from upstream oil and gas systems, including SAP, Energy Components, and PI Process Book.
- Ensure seamless ingestion, transformation, and storage of data in support of field operations, production reporting, and commercial analysis.
- Troubleshoot data flow issues and work with IT and business teams to onboard new data sources as needed.
Reporting & Business Intelligence
- Collaborate with engineers, commercial analysts, and other stakeholders to deliver actionable reporting and insights.
- Support dashboard development and reporting structures using tools like Power BI, ensuring alignment with upstream KPIs and operational workflows.
- Act as a key technical resource for business intelligence tools and reporting optimisation.
Qualifications
- Proven experience as a Data Engineer or ETL Developer, ideally within the upstream oil and gas industry.
- Advanced SQL skills and expertise in relational database and data warehouse management.
- Hands-on experience with SAP, Energy Components, PI ProcessBook, or similar upstream systems.
- Strong knowledge of data quality assurance, cleansing, and validation techniques.
- Proficiency with Power BI or comparable reporting/visualisation platforms.
- Background in oil and gas data domains, including production, metering, hydrocarbon accounting, or commercial reporting.
- Experience with Python, R, or similar scripting languages for data manipulation and automation.
- Familiarity with data governance standards and compliance frameworks.
- Strong troubleshooting skills with experience resolving upstream data flow issues.
- Expertise in ETL/ELT development and data integration specific to oil and gas environments.
- High attention to detail, especially around data integrity and auditability.
- Proactive, adaptable, and capable of operating in a fast-paced, asset-focused environment.
Data Architect / Data Engineer employer: Telosta
Contact Detail:
Telosta Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect / Data Engineer
✨Tip Number 1
Familiarise yourself with the specific data systems mentioned in the job description, such as SAP and Energy Components. Understanding how these systems integrate and function within the upstream oil and gas sector will give you a significant edge during interviews.
✨Tip Number 2
Showcase your experience with data quality assurance and governance standards. Be prepared to discuss specific examples of how you've implemented data cleansing and validation processes in previous roles, as this is crucial for the position.
✨Tip Number 3
Highlight your proficiency with Power BI or similar reporting tools. Consider preparing a portfolio of dashboards or reports you've created, as this can demonstrate your ability to deliver actionable insights and support business intelligence needs.
✨Tip Number 4
Network with professionals in the oil and gas industry, particularly those who work with data engineering. Engaging in relevant forums or LinkedIn groups can provide valuable insights and potentially lead to referrals for the position.
We think you need these skills to ace Data Architect / Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience as a Data Engineer or ETL Developer, particularly in the upstream oil and gas sector. Emphasise your advanced SQL skills, experience with SAP, Energy Components, and any data quality assurance techniques you've employed.
Craft a Compelling Cover Letter: In your cover letter, explain why you're passionate about data engineering in the oil and gas industry. Mention specific projects or experiences that demonstrate your ability to manage data pipelines and ensure data quality, as well as your familiarity with tools like Power BI.
Showcase Technical Skills: Clearly list your technical skills related to data integration, ETL/ELT development, and any programming languages you are proficient in, such as Python or R. This will help the hiring team see your fit for the role at a glance.
Highlight Problem-Solving Abilities: Provide examples of how you've successfully troubleshot data flow issues or improved data processes in previous roles. This will demonstrate your proactive approach and adaptability in fast-paced environments, which is crucial for this position.
How to prepare for a job interview at Telosta
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, data warehousing, and ETL processes. Highlight specific projects where you've successfully managed data integration from systems like SAP or Energy Components, as this will resonate well with the interviewers.
✨Demonstrate Problem-Solving Abilities
Expect questions about troubleshooting data flow issues. Prepare examples of challenges you've faced in previous roles and how you resolved them, particularly in the context of upstream oil and gas operations.
✨Emphasise Data Quality and Governance
Discuss your understanding of data quality assurance and governance standards. Be ready to explain how you've implemented data cleansing and validation processes in past projects, as this is crucial for maintaining a reliable data environment.
✨Familiarity with Reporting Tools
Since the role involves collaboration on reporting and business intelligence, be sure to mention your experience with tools like Power BI. Share examples of dashboards or reports you've developed that align with operational KPIs, showcasing your ability to deliver actionable insights.