Data Engineer

Public Sector Resourcing • London Britain Township, PA

10d • £44,380 - £52,212 • Hybrid

About The Position

The Data Engineer works within HS2 Ltd’s Information Management Function, which provides information management services, information governance, IT security support, data engineering and analytical capabilities. HS2 is implementing a Digital, Data and Technology Operating Model to deliver quality IT platforms, products and services and enable business capabilities through an insight-led approach.

The role involves designing and developing scalable data solutions, building and maintaining data pipelines, and creating reusable data models. Work includes extracting data from various sources, transforming and cleansing it, and loading it into cloud-based data warehouses, while ensuring reliability, scalability and performance. The position also involves developing and testing data products and providing resilient data integration services that meet user needs.

The role is based in London or Birmingham with hybrid working. HS2 offers a base salary of £44,380–£52,212 per annum, plus a flexible benefits fund of 15% of base salary, paid on top and fully pensionable, along with a range of other benefits. Applicants must already have the right to work in the UK; HS2 cannot provide visa sponsorship. Offers are subject to pre-employment checks.

Requirements

• Strong knowledge of cloud-based data tools and technologies, including data integration and end-to-end process flows.
• Experience working with cloud platforms such as AWS, Azure or Google Cloud Platform.
• Experience with modern data warehouse technologies, particularly Snowflake.
• Proven experience applying data engineering techniques to design and develop scalable solutions.
• Experience in data modelling and transformation.
• Experience creating reusable and scalable data models.
• Strong SQL skills, including building structured SQL tables and creating reporting views.
• Experience cleaning, standardising and maintaining high-quality datasets.
• Ability to design, develop and test complex or large-scale data products and explain how teams can complete data integration services.
• Ability to identify and implement appropriate technologies for resilient, scalable and future-proof data integration solutions.
• Experience developing fit-for-purpose, resilient, scalable and future-proof data services to meet user needs.
• Applicants must already have the right to work in the UK; sponsorship is not available.

Nice To Haves

• Exposure to Azure Data Factory, Synapse Analytics, Databricks, Spark, SQL and Python.
• Experience with Airflow would be advantageous.
• Familiarity with modern data modelling tools such as dbt.
• Experience with enterprise data warehouses such as Snowflake, BigQuery or Synapse.

Responsibilities

• Design and develop scalable data solutions using data engineering techniques.
• Build and maintain robust data pipelines to extract data from various sources, transform and cleanse it, and load it into cloud-based data warehouses.
• Ensure data solutions are reliable, scalable and perform effectively.
• Create reusable and scalable data models.
• Build structured SQL tables and reporting views.
• Clean, standardise and maintain high-quality datasets.
• Design, develop and test complex or large-scale data products.
• Select and implement appropriate technologies to deliver resilient, scalable and future-proof data solutions.
• Identify and respond to problems in databases, data processes, data products and services.
• Design, code, test, correct and document programs and scripts in accordance with agreed specifications and subsequent iterations.

Benefits

• Flexible benefits fund of 15% of base salary, paid on top of base salary and fully pensionable.
• Range of competitive benefits.
• Flexible working.
• Personal and professional development opportunities.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed