Scrumconnect Limited logo

Data Engineer (SC Cleared)

Scrumconnect Limited
Contract
On-site
London, Greater London, United Kingdom

About Scrumconnect Consulting
Scrumconnect Consulting is a multi-award-winning digital consultancy, recognised for delivering impactful technology solutions across UK government departments. Our work has positively influenced the lives of over 40 million UK citizens. We are committed to user-centred design and agile delivery, bringing innovation to digital services that matter.

Clearance Requirement
Active SC clearance is mandatory (must be valid at the time of application).

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.

  • Essential Skills & Experience
    • 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.

    • Excellent communication and collaboration skills across technical and non-technical teams.

      Desirable

      • Azure certifications (Data Engineering, Data Scientist, or related).

      • Knowledge of GDPR compliance, data security, and governance best practices.