Data Engineer

Role:
Data Engineer Role report to:
Senior Data and Analytics Manager

Location:

London or Birmingham (Hybrid)
Grade: G16

Base Salary: £44, 380 - £52,212 per annum

In addition, we offer flexible benefits fund of 15% which is paid on top base salary and is fully pensionable, as well as a range of competitive benefits - check them out in the Benefits section on HS2’s website.

Job Description:

HS2 Ltd endeavours to ensure everyone working for us and with us feels included, thrives and achieves their full potential. In practice, this means we are positive and inclusive about making adjustments, providing flexible working, encouraging our staff networks to flourish and providing personal and professional development opportunities.

About the role:

At HS2 we are iteratively implementing a Digital, Data and Technology (DDaT) Operating Model, delivering quality IT platforms, products and services. Based on industry best practice our insight-led approach will provide HS2 with the latest Digital, Data and Technology services, delivering ‘‘value for money’ to enable business capabilities.

The Information Management Function are responsible for ensuring HS2 and its Integrated Project Teams are getting the right information, in the right place at the right time, providing information management services, information governance, IT security support, data engineering and analytical capabilities.

Key accountabilities:

Cloud Technologies & Data Platforms:
* Strong knowledge of cloud-based data tools and technologies, with an understanding of data integration and end-to-end process flows.
* Experience working with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP).
* Experience with modern data warehouse technologies, particularly Snowflake.
* Exposure to technologies such as Azure Data Factory, Synapse Analytics, Databricks, Spark, SQL, and Python.

Experience with Airflow would be advantageous.

Data Engineering
* Proven experience applying data engineering techniques to design and develop scalable solutions.
* Ability to build and maintain robust data pipelines, including:
* Extracting data from various sources
* Transforming and cleansing data into usable formats
* Loading data into cloud-based data warehouses
* Ensuring reliability, scalability, and performance of data solutions
* Experience in data modelling and transformation.

Data Modelling & Warehousing
* 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.
* Familiarity with modern data modelling tools such as dbt.
* Experience working with enterprise data warehouses, including Snowflake, Big Query, or Synapse.

About You:

Skills:

* Data development process. Ability to design, develop and test data products that are complex or on a large-scale. Ability to articulate how teams can complete data integration services.
* Data integration design. Ability to select and implement appropriate technologies to deliver resilient, scalable and future-proofed data solutions.
* Problem resolution (data). Ability to identify and respond to problems in databases, data processes, data products and services.
* Programming and build (data engineering). Ability to use standards and tools to design, code, test, correct and document programs and scripts from agreed specifications and subsequent iterations.

Knowledge:
* Knowledge of a range of cloud-based tools and technologies and importance of the role of data integration and process flow.
* Knowledge of innovative data tools and how these can be applied

Type of

Experience:

* Experience of developing fit for purpose, resilient, scalable and future-proof data services to…