Data Architect and Developer
Data Architect and Developer

Data Architect and Developer

London Full-Time 48000 - 72000 £ / year (est.) Home office (partial)
T

At a Glance

  • Tasks: Design and manage 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 critical team delivering impactful data solutions and insights.
  • Qualifications: Experience in data engineering, SQL, and upstream oil and gas systems required.
  • Other info: Ideal for proactive individuals who thrive in fast-paced environments.

The predicted salary is between 48000 - 72000 £ 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 and Developer employer: Telosta

Join a leading organisation in the upstream oil and gas sector, where you will play a pivotal role in shaping the future of data management. With a strong emphasis on employee growth, we offer comprehensive training and development opportunities, alongside a collaborative work culture that values innovation and excellence. Located in vibrant London or Aberdeen, our hybrid working model ensures a balanced approach to work and life, making us an exceptional employer for those seeking meaningful and rewarding careers.
T

Contact Detail:

Telosta Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Architect and Developer

✨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 reporting. Use tools like Power BI to create dashboards that demonstrate your ability to turn complex data into actionable insights, which is crucial for the role.

✨Tip Number 4

Prepare for the interview by brushing up on data governance standards and compliance frameworks relevant to the oil and gas industry. Being able to discuss how you would implement these standards in your work will highlight your suitability for the role.

We think you need these skills to ace Data Architect and Developer

Data Warehouse Management
SQL Expertise
ETL/ELT Development
Data Integration
Data Quality Assurance
Data Cleansing Techniques
Power BI Proficiency
SAP Knowledge
Energy Components Familiarity
PI ProcessBook Experience
Data Governance Standards
Troubleshooting Skills
Python or R Scripting
Attention to Detail
Adaptability in Fast-Paced Environments

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 PI Process Book, and any projects that showcase your data integration capabilities.

Craft a Compelling Cover Letter: Write a cover letter that specifically addresses the job description. Mention your familiarity with data quality assurance, governance standards, and your ability to troubleshoot data flow issues. Use examples from your past work to demonstrate how you can contribute to the organisation's data management goals.

Highlight Technical Skills: In your application, clearly list your technical skills, including proficiency in Power BI, Python, R, and any other relevant tools. Make sure to mention your experience with data pipelines and your understanding of data governance frameworks, as these are crucial for the role.

Showcase Problem-Solving Abilities: Provide examples of how you've identified opportunities for automation and process improvement in previous roles. Highlight your proactive approach and adaptability in fast-paced environments, as these traits are essential for success in 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 PI Process Book, as this will demonstrate your hands-on expertise.

✨Understand the Industry Context

Familiarise yourself with the upstream oil and gas sector, including key challenges and trends. This knowledge will help you relate your skills to the company's needs and show that you're genuinely interested in the role.

✨Prepare for Scenario-Based Questions

Expect questions that assess your problem-solving abilities, especially regarding data flow issues or quality control. Think of examples where you've identified and resolved data discrepancies or optimised data pipelines.

✨Demonstrate Your Collaborative Spirit

Since the role involves working with various teams, be ready to discuss how you've collaborated with engineers and analysts in the past. Share examples of how your contributions have led to actionable insights or improved reporting structures.

Data Architect and Developer
Telosta
T
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>