At a Glance
- Tasks: Lead the design and optimisation of a Data Warehouse for upstream oil and gas operations.
- Company: Join a dynamic organisation at the forefront of the oil and gas sector.
- Benefits: Enjoy hybrid working options and opportunities for professional growth.
- Why this job: Be part of a critical team delivering impactful analytics and insights in a fast-paced environment.
- Qualifications: Experience as a Data Engineer with strong SQL skills and knowledge of upstream systems required.
- Other info: Ideal for proactive individuals who thrive in a detail-oriented, asset-focused setting.
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 operate will give you a significant edge during interviews, as you'll be able to discuss your relevant experience and insights confidently.
✨Tip Number 2
Network with professionals in the oil and gas sector, particularly those who work with data engineering. Attend industry events or join online forums to connect with potential colleagues and learn about the latest trends and challenges in data management within this field.
✨Tip Number 3
Showcase your technical skills by working on personal projects that involve data integration and pipeline management. This could include building a small-scale data warehouse or creating dashboards using Power BI, which will demonstrate your hands-on experience and problem-solving abilities.
✨Tip Number 4
Prepare for the interview by brushing up on data quality assurance techniques and governance standards. Be ready to discuss how you've implemented these practices in past roles, as this will highlight your attention to detail and commitment to maintaining data integrity.
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, especially within the upstream oil and gas sector. Emphasise your advanced SQL skills, hands-on experience with SAP, Energy Components, and PI Process Book.
Craft a Compelling Cover Letter: Write a cover letter that showcases your understanding of data warehouse management and data quality governance. Mention specific projects where you've implemented data quality controls or optimised data pipelines.
Highlight Technical Skills: Clearly list your technical skills related to data manipulation and automation, such as proficiency in Python or R. Also, include your experience with reporting tools like Power BI, as these are crucial for the role.
Showcase Problem-Solving Abilities: In your application, provide examples of how you've troubleshot data flow issues or improved data processes in previous roles. This will demonstrate your proactive approach and adaptability in a fast-paced environment.
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 demonstrate your capability in handling the technical demands of the role.
✨Understand the Industry Context
Familiarise yourself with the upstream oil and gas sector, including key challenges and trends. This knowledge will help you articulate how your skills can contribute to the organisation's goals and show that you're genuinely interested in the industry.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities, especially regarding data flow issues or data quality challenges. Think of examples from your past experiences where you identified problems and implemented effective solutions, as this will showcase your analytical skills.
✨Demonstrate Your Collaborative Spirit
Since the role involves working closely with various teams, be ready to discuss how you've collaborated with engineers, analysts, and other stakeholders in previous roles. Emphasising your communication skills and teamwork will highlight your fit for a role that requires cross-functional collaboration.