Lead Data Engineer (Azure Synapse | Synapse Notebooks | Azure DevOps) at Franklin Bates, United Kingdom, to c£500 per day Outside IR35

Lead Data Engineer (Azure Synapse | Synapse Notebooks | Azure DevOps)

Contract

6-month initial term, with strong likelihood of extension

Up to c£500 per day Outside IR35

Remote or hybrid (West London office if preferred)

We are looking for an experienced Lead Data Engineer to play a key role in the development of a modern Azure data platform, with a strong focus on Azure Synapse, Synapse notebooks and engineering best practice.

This is a hands-on technical leadership role for someone who enjoys owning solutions from requirements through to deployment, working closely with business stakeholders and delivering robust, production-grade data platforms.

You will be responsible for:

• Designing and developing scalable ETL/ELT pipelines and reusable data products
• Building and maintaining Azure Synapse solutions, with particular emphasis on Synapse notebooks, Serverless SQL and Synapse pipelines
• Designing and implementing CI/CD pipelines and release processes using Azure DevOps
• Developing scalable data warehouse and lakehouse solutions aligned to modern engineering best practice
• Translating business requirements into robust, well-designed technical solutions
• Working independently whilst collaborating closely with technical teams and business stakeholders
• Providing technical leadership, mentoring and guidance across the wider data engineering team
• Supporting data governance, deployment controls and engineering standards

We are particularly keen to speak with engineers who have hands-on experience with:

Essential

• Azure Synapse Analytics
• Synapse notebooks
• Serverless SQL
• Synapse Pipelines
• Azure Data Factory
• Azure DevOps, including Repos, YAML Pipelines, CI/CD and Release Management
• SQL Data Warehousing and dimensional modelling
• Building and deploying enterprise-scale data engineering solutions
• Working directly with business stakeholders to gather requirements and own technical delivery

Highly desirable

• Azure Databricks
• Power BI semantic models
• Microsoft Fabric
• Azure Data Lake
• Modern data engineering and data product development

We are looking for someone who is technically strong, highly hands-on and comfortable taking ownership of solutions. You will be able to clearly articulate how you have designed, built and deployed Azure data platforms, and you will have the confidence to work independently while engaging effectively with both technical teams and business stakeholders.