Data Engineer

Great British Energy Group; Greater London; On-site; GBP 44,000 - 52,000; Full time

Benefits offered by this job

Flexible benefits fund (15%)

Competitive benefits package

Job summary

HS2 Ltd is hiring a Data Engineer to support the Information Management Function. You will design and run scalable data pipelines, leverage Snowflake and cloud-native tools, and partner with analytics teams to deliver high-quality data products.

Hybrid working in London or Birmingham, with a strong emphasis on data integration and governance. The role requires experience with data modeling, SQL, Python, and modern data tools, enabling reliable, scalable data solutions across enterprise data

Qualifications

• Experience designing and building scalable data services across cloud platforms.
• Experience with end-to-end data pipelines: extract, transform, load to cloud warehouses.
• Strong knowledge of data modeling and reusable data models.

Responsibilities

• Design, develop and maintain scalable data pipelines across cloud platforms.
• Build robust data models and data warehousing solutions (Snowflake, Synapse, BigQuery).
• Ensure data quality, governance and performance of data pipelines.
• Collaborate with analytics teams to deliver data products and insights.

Skills

Cloud Platforms

Snowflake

SQL

Python

Airflow

dbt

Databricks

Data Modeling

ETL

Data Integration

Tools

AWS

Azure

GCP

Snowflake

Azure Data Factory

Synapse Analytics

Databricks

Spark

SQL

BigQuery

Job description

Role: Data EngineerRole report to: Senior Data and Analytics ManagerLocation: London or Birmingham (Hybrid)Grade: G16Base Salary: £44, 380 - £52,212 per annumIn 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, BigQuery, 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 appliedType of Experience:* Experience of developing fit for purpose, resilient, scalable and future-proof data services to meet user needs.* Experience of applying data engineering techniques.* Experience of producing re-usable data models.As HS2 Ltd do not hold a sponsorship license from the Home Office, we are not able to provide sponsorship to any applicant. Applicants must already have the Right to Work in the UK at the time of application and our process involves a Right to Work validation prior to the interview stage. Note, there are certain types of time-bound visas that we cannot accept.Any offers made to applicants will be subject to satisfactory completion of pre-employment checks which include Nationality & Immigration Status, employment references, DBS, Financial and Education checks.We ask for a variety of detail in your online application, however we perform the first assessment of suitability for a role based solely on the information in your CV. In a further development of our efforts to create a more diverse workforce, your CV will be anonymised and personal information will be removed during the first stage of the application review. This removes bias from the process and makes it even more important that you attach an updated word version of your CV for each new application ensuring you include evidence directly related to the criteria in the job advert.Any applications received after the closing date will not be considered.About Us:High Speed 2 (HS2 Ltd) will be the UK’s new high speed rail network. As well as improving capacity, the new scheme will shorten journey times between a number of Britain’s major population centres, boost the economy and create thousands of jobs.HS2 Ltd will create a skills legacy and develop a diverse range of talent. We aim to be a leader in EDI practice by creating a safe & inclusive working environment for all our staff - living our values of Safety, Respect, Integrity and Leadership.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.HS2 Ltd is also a safety-critical organisation. Employees are required to ensure reasonable care of their own and others’ health and safety by taking personal responsibility for working to our ‘Safe at Heart’ programme principles and following safe working procedures at all times.HS2 Ltd endeavours to ensure everyone working for us and with us feels included, thrives and achieves their full potential.