Data Engineer

Our client is seeking a highly capable Data Engineer with strong experience across the Microsoft data ecosystem-SQL Server, Microsoft Fabric, Power BI, Cosmos DB, Data Lakes, and 3rd-party integrations.

This role is central to the design, development, and optimisation of their enterprise data platform. You will translate complex business requirements into robust data pipelines, modelling structures, and BI/MI outputs that empower stakeholders to make informed decisions.

You'll work closely with engineering, product, and business teams to understand system logic, data flows and future roadmap, ensuring high-quality, reliable, and accessible data across the organisation., * Design, build and maintain scalable data pipelines and ingestion processes across SQL Server, Fabric Data Factory, Dataflows Gen2, and other Fabric components.

• Work closely with stakeholders to understand operational requirements and translate these into technical specifications and data models.
• Build and maintain Fabric Lakehouse/Warehouse layers, dimensional models and curated datasets for enterprise reporting.
• Develop and optimise ETL/ELT processes, ensuring data integrity, accuracy and performance across multiple source systems.
• Create reusable MI datasets that support dashboards, KPIs and transactional insights using Power BI and the wider Fabric stack.
• Integrate data from internal systems, client systems, APIs, and third-party providers, ensuring consistency and alignment with business rules.
• Leverage Cosmos DB for high-volume, semi-structured data ingestion and operational analytics.
• Work on data initiatives involving AI-driven analysis of industry and healthcare trends, predictive insights, and strategic reporting.
• Document data models, pipelines and transformations for transparency, governance, and internal knowledge sharing.
• Drive continuous improvement of data accessibility, lineage, quality and engineering best practices.

• Strong experience as a Data Engineer working with Microsoft data stack.
• SQL expertise: querying, performance tuning, stored procedures, schema design.
• Hands-on experience with Microsoft Fabric (Data Factory, Dataflows, Lakehouse, Warehouse, Pipelines).
• Experience building and maintaining ETL/ELT workflows across varied data sources.
• Strong understanding of data modelling, dimensional modelling, star schema and MI/BI dataset design.
• Experience developing Power BI datasets and enabling downstream analytics.
• Knowledge of APIs, data integrations and working with real-time or semi-structured datasets.
• Familiarity with Cosmos DB or other NoSQL technologies.
• Strong stakeholder communication-able to explain data concepts to non-technical teams.

Our client is a £100M healthcare organisation and one of the UK's leading providers of occupational health and wellbeing solutions. Following record levels of investment, they are undergoing a major data modernisation programme-building a scalable, cloud-driven data platform to support advanced analytics, AI initiatives, real-time reporting and enterprise MI. They work across a wide range of industries, supporting the physical and mental health of hundreds of thousands of employees across the UK. With data now sitting at the centre of strategic decision-making, they are expanding their Data Engineering capability to drive innovation, improve data quality, and unlock richer insights for clinical, operational and commercial teams.