Senior Data Engineer

Ithaca Energy UK Limited; Scotland; On-site; GBP 50,000 - 90,000; Full time

Job summary

An ambitious and innovative company is seeking a Senior Data Engineer to enhance its data analytics capabilities. This role involves supporting the data platform, ensuring data quality, and driving improvements in data governance. You will collaborate with cross-functional teams, lead data projects, and provide technical guidance to the growing data engineering team. If you are passionate about data and eager to make a significant impact in a dynamic environment, this position offers an exciting opportunity to shape the future of data analytics in a forward-thinking organization.

Qualifications

• Experience with data warehousing and ETL/ELT tools.
• Proven skills in data analytics and transformation.
• Knowledge of Synapse and Azure Data Lake Storage.

Responsibilities

• Support data platform programs and enhance data quality.
• Lead data projects and ensure data governance.
• Collaborate with teams to deliver business insights.

Skills

Data Warehousing

ETL/ELT

Data Analytics

Synapse

PySpark

Azure Data Lake Storage

Master Data Management

Problem Solving

Education

Professional Qualification or Equivalent Experience

Tools

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 your expertise in Synapse and data engineering techniques.
• Stay up to date with innovation: Understand best practice of data engineering and its application, and stay up-to-date with emerging technologies in the data space.
• Analyse, Model and Organise Data: Work with a range of stakeholders and business users to understand the use and utility of datasets and systems to then analyse, model and organise data from their respective source data systems into the medallion data lake for further use in reporting.
• Ensure data quality and data reliability: Drive improvements in data quality assessments, and ensure that data is processed effectively, efficiently, robustly and timely. Implementing data validation and cleansing processes to improve data management.
• Maintaining Data Governance: Ensuring that data governance policies and procedures are followed, and that data lineage and cataloguing is maintained for data discoverability.
• Bringing New Data Projects to Life: Take the lead in initiating, designing, and executing data projects, ensuring their entire lifecycle is managed effectively.
• Deliver Business Insights: Support and deliver business insight, intelligence and predictive analytics reporting which creates real business value.
• Team Growth: Participate in the growth of our data engineering team by actively contributing to recruitment and mentoring, as this position is focused on expansion rather than backfill.
• Performance Monitoring: Optimise and tune pipelines and data processing to increase and improve performance and efficiency.
• Performance Management: Looking at wider trends across the data processing infrastructure to identify improvements. Establishing and implementing monitoring and logging solutions across the data platform to improve visibility and management of the data platform.
• Project Scoping and Management: Defining project scopes and timelines for delivery of a variety of projects, in collaboration with the Digital Technology Partners and the Data and Analytics Lead.
• Data Governance: Working with the Data and Analytics Lead to improve Data Governance policies and procedures and its enforcement across the data estate.
• Code Management: Acting as a trusted advisor and authority in the development of code artifacts, code deployment and code management.
• Documentation Management: Acting as a trusted authority in the maintenance of comprehensive documentation across the data platform.
• Leadership and Collaboration: Providing technical guidance and mentorship to the team and leading by example across the activities within the Data Programme.

Qualifications & Experience

• Appropriate professional qualification or equivalent experience.
• Proven competency working with data warehousing, ETL/ELT, integration tools and business intelligence solutions that will help to deliver the data and analytics strategy.
• Skills with Synapse (notebooks and data flows) is essential for Senior Data Engineer.
• Working knowledge of PySpark is essential for Senior Data Engineer.
• Capability working with Azure Data Lake Storage is essential for Senior Data Engineer.
• Working knowledge of medallion data lakehouse architecture is essential for Senior Data Engineer.
• Exceptional problem-solving skills to tackle complex data engineering challenges.
• Strong background in data analytics, with a focus on data transformation and modelling.
• Competency of Master Data Management principles and implementations is essential for Senior Data Engineer.
• Oil & Gas industry exposure is not required; however, a passion for working with data is a must.
• Familiarity with Power BI is desirable but not essential.
• Ability to establish, document and communicate data engineering applications and pipelines with both peers and stakeholders.

We are committed to building a diverse organisation with a variety of backgrounds, skills and views. The more inclusive we are, the better we are. We recognise you may not fulfil every criteria but if you meet most of them, please apply.