Senior Data Engineer

Ithaca Energy Inc.; Aberdeen City; On-site; GBP 50,000 - 90,000; Full time

Job summary

An established industry player is seeking a Senior Data Engineer to join their dynamic team in Aberdeen. This pivotal role will shape the future of the company's data analytics capabilities, focusing on enhancing their modern data platform and ensuring data quality. You will lead innovative data projects, collaborate with cross-functional teams, and contribute to the growth of the data engineering team. If you are passionate about data and eager to make an impact in a forward-thinking environment, this is the opportunity for you.

Qualifications

• Proven experience with data warehousing and ETL/ELT tools.
• Expertise in Synapse and working knowledge of PySpark.

Responsibilities

• Collaborate with teams to enhance the data platform and ensure data quality.
• Lead data projects and deliver analytics that create business value.

Skills

Data Warehousing

ETL/ELT

Data Governance

Problem-Solving

Data Analytics

Data Modeling

Documentation

Education

Relevant Professional Qualification

Tools

Synapse

PySpark

Azure Data Lake Storage

Power BI

Job description

Ithaca Energy is a leading full cycle exploration and production company headquartered in Aberdeen, Scotland. The business has built a diverse and high value portfolio of operated and non-operated assets across the Northern & Central North Sea and West of Shetland.

We are a dynamic and ambitious business on a rapid growth journey, recognising that the energy industry is entering a new era. As we move towards energy transition, our commitment to the North Sea is unwavering.

As a leading North Sea Operator, we are an agile and driven business, taking a pragmatic approach to oil & gas production through innovative thinking and advanced technologies. Our goal is to maximise value through the safe, efficient and responsible production of our assets.

Success is dependent on our talent and, with bold and inspired people, we will create a workplace that is diverse and equitable, building a culture of collaboration and inclusion.

Position Overview

Ithaca Energy is accepting applications for the position of Senior Data Engineer located in our Aberdeen Office.

Reporting to the Analytics and Integration Lead, the Senior Data Engineer will play a pivotal role in shaping the future of the company's data analytics capabilities.

Responsibilities

Provision of pipeline engineering support across all development projects within the company's portfolio.

• Supporting Data Platform Program: Collaborate with cross-functional teams to maintain and enhance our modern data platform, leveraging expertise in Synapse and data engineering techniques.
• Stay up to date with innovation: Understand best practices in data engineering, application of emerging technologies, and stay current with developments in the data space.
• Analyse, Model and Organise Data: Work with stakeholders and business users to understand data utility, and analyze, model, and organize data into the medallion data lake for reporting.
• Ensure data quality and data reliability: Drive improvements in data quality assessments, ensure effective, efficient, robust, and timely data processing, and implement validation and cleansing processes.
• Maintaining Data Governance: Follow data governance policies, maintain data lineage and cataloging for discoverability.
• Bringing New Data Projects to Life: Lead in initiating, designing, and executing data projects, managing their lifecycle effectively.
• Deliver Business Insights: Support and deliver analytics and predictive reporting that create business value.
• Team Growth: Contribute to the growth of the data engineering team through recruitment and mentoring, focusing on expansion.
• Performance Monitoring: Optimize pipelines and data processing for performance and efficiency.
• Performance Management: Identify infrastructure improvements, establish monitoring/logging solutions for better visibility and management.
• Project Scoping and Management: Define project scopes and timelines in collaboration with partners and leads.
• Data Governance: Collaborate on improving and enforcing Data Governance policies.
• Code Management: Develop, deploy, and manage code artifacts responsibly.
• Documentation Management: Maintain comprehensive documentation across the data platform.
• Leadership and Collaboration: Provide technical guidance, mentorship, and lead activities within the Data Programme.

Qualifications & Experience

• Relevant professional qualification or equivalent experience.
• Proven experience with data warehousing, ETL/ELT, integration tools, and BI solutions.
• Expertise with Synapse (notebooks and data flows) is essential.
• Working knowledge of PySpark is essential.
• Experience with Azure Data Lake Storage is essential.
• Understanding of medallion data lakehouse architecture is essential.
• Strong problem-solving skills for complex data challenges.
• Background in data analytics, transformation, and modeling.
• Knowledge of Master Data Management principles is essential.
• Passion for working with data; industry exposure is not required.
• Familiarity with Power BI is desirable but not essential.
• Ability to document and communicate data pipelines effectively with peers and stakeholders.

We are committed to building a diverse organization with various backgrounds, skills, and views. If you meet most of the criteria, please apply.