Data & Integrations Lead Engineer

This is a fantastic opportunity for someone to take ownership of building and developing a modern data integration environment, working extensively with Microsoft Fabric, OneLake and Azure data technologies.

The successful candidate will play a key role in connecting internal and external data sources, building reliable data pipelines and creating the foundations for business intelligence, analytics and future AI initiatives., * Design, build and maintain data pipelines, connectors, APIs and ETL/ELT processes.

• Develop and manage data ingestion and transformation processes using Microsoft Fabric and OneLake.
• Integrate data from operational systems, Microsoft applications and external data providers.
• Work with SQL to transform, validate and reconcile datasets.
• Implement data quality checks, monitoring, alerting and error-handling processes.
• Maintain data lineage, metadata and documentation.
• Support Power BI reporting, analytics and future AI initiatives.
• Take ownership of production data pipelines, troubleshooting and resolving integration issues.

• Strong hands-on experience building and operating data pipelines.
• Practical experience with Microsoft Fabric, OneLake and Data Factory.
• Strong SQL skills and experience with ETL/ELT processes.
• Experience working with APIs, connectors and data integrations.
• Understanding of data warehousing, lakehouse architecture and data quality.
• Experience monitoring and supporting production data environments.

Desirable Experience:

• Microsoft Fabric or Azure Data Engineer certifications.
• Experience with Dynamics 365, Dataverse, SharePoint or Microsoft Graph.
• Power BI experience.
• Experience working with financial, operational or large-scale commercial datasets.
• Knowledge of CI/CD and automated deployment processes.

• Up to £95,000
• Discretionary annual bonus
• Generous pension scheme
• Private medical insurance
• Life insurance
• 25 days annual leave plus bank holidays