Data Engineer

This is a high-impact role for an experienced data engineer who wants technical leadership, architectural influence, and the chance to shape a modern cloud-based data platform built on Azure Data Factory, Synapse, Data Lake, and Microsoft Fabric., As Senior Data Engineer, you will:

• Lead the design, build, and optimisation of Azure Data Factory (ADF) ETL pipelines.
• Develop scalable Synapse Analytics data models and performance-optimised SQL workloads.
• Own and enhance Power BI datasets, semantic models, and reporting standards (major focus).
• Shape cloud data architecture across Azure Data Lake and Synapse environments.
• Play a key role in the organisation's transition to Microsoft Fabric.
• Implement robust data quality, validation, and monitoring frameworks.
• Work closely with business and technology stakeholders to deliver high-value data solutions.
• Mentor junior data engineers and support engineering standards.
• Contribute to Agile delivery through Azure DevOps and CI/CD practices.

Essential:

• Advanced Power BI expertise: datasets, DAX, modelling, governance, performance tuning.
• Expert-level Azure Data Factory (ETL/ELT pipelines, automation, optimisation).
• Strong Azure Synapse experience: warehousing, SQL pools, query tuning, stored procedures.
• Deep proficiency in SQL development and optimisation.
• Solid understanding of Azure Data Lake and cloud storage layers.
• Proven track record delivering Azure-based data engineering solutions.
• Strong communication and stakeholder engagement.
• Demonstrated mentoring or technical leadership experience.

Desirable:

• Exposure to Microsoft Fabric.
• Experience with AI/automation tools (Copilot, ChatGPT) or Azure Machine Learning.
• Experience working in financial services or another regulated industry.

• Pension: 7% employer / 5% employee
• Private Medical Insurance (optical & dental)
• Flexible hybrid working requiring 1-2 days per month in office
• Group Income Protection (75% salary)
• Death in Service (4x salary)
• Critical Illness Cover (£10k)
• 25 days holiday rising to 28
• Company bonus 8%

Join a leading and growing UK financial services company as a Senior Data Engineer, taking ownership of enterprise-grade Azure data solutions and advanced Power BI reporting.