Role Overview
We are seeking an experienced Data Engineer to develop and maintain data products and a Strategic Data Platform. You will work as part of multi-functional Agile delivery teams, ensuring operational stability, ongoing support, and enhancement of data solutions. The role focuses on designing, delivering, and optimising scalable data architectures, with a strong emphasis on Azure-based tools, SQL, and modern engineering practices.
Key Responsibilities
Design, build, and maintain data solutions using Azure Data Factory and Azure Synapse.
Manage the data development life cycle within Agile delivery teams.
Integrate and automate workflows into Azure DevOps pipelines.
Create and maintain dimension data models and semantic models for integration with Power BI.
Develop complex dashboards, visualisations, and reporting solutions using Power BI.
Implement data governance, quality checks, and profiling to ensure accuracy and compliance.
Migrate Legacy data capabilities to modern Azure-based platforms.
Apply dbt (with SQL databases) for data transformation, modelling, and workflow optimisation.
Collaborate with business stakeholders to translate requirements into robust technical solutions.
Coach and mentor team members to enhance capability in data engineering best practices.
Active SC Clearance (must be in place at the time of application).
Proven expertise with:
Azure Data Factory & Azure Synapse
Azure DevOps & Microsoft Azure
Power BI (including semantic models)
Python (incl. PySpark) and SQL (advanced proficiency)
dbt with SQL DBs (data transformation & modelling)
Dimension data modelling
Terraform for infrastructure-as-code deployments
Experience delivering solutions with structured and unstructured data.
Strong experience in Agile environments.
Business analysis skills to capture and translate service needs into technical solutions.
Proven track record in Legacy migration projects within complex organisations.
Azure certifications (Data Engineering, Data Scientist, or related).
Knowledge of GDPR compliance, data security, and governance best practices.