Data Analytics Engineer (Microsoft Fabric)

As we embark on a significant growth spurt as the leading omni-channel baby & nursery brand, with significant investment into IT and Data, as part of the catalyst for this growth plan, we are looking to recruit ay DATA ANALYTICS ENGINEER on (Microsoft Fabric) to be based at our Huddersfield (HD5 0RH) head office.

As Data Analytics Engineer you will design, build and maintain a new Microsoft Fabric data platform from the ground up. This role combines strong data architecture skills with hands-on data engineering capability, supporting the end-to-end creation of data pipelines, modelling layers and semantic models. You will work closely with an external partner to ensure our data foundations are modern, scalable, and aligned to best practice.

Key Responsibilities
Data Engineering and Platform Build
• Implementing a new Microsoft Fabric platform from the ground up working with an external partner
• Support the design and development of end-to-end data pipelines within Microsoft Fabric, including ingestion, transformation, orchestration and monitoring.
• Develop and maintain Lakehouse / Warehouse structures (tables, views, schemas, partitions).
• Build and optimise Dataflows Gen2 and other Fabric ingestion methods.
• Collaborate with an external partner on platform architecture, performance considerations and modelling best practice.
• Implement and maintain core engineering standards: naming conventions, folder structures, workspace organisation.
• Integrating operational systems (ERP, POS, eComm, CRM, HR, Finance) into OneLake.
• Support data quality frameworks, validation rules and automated checks.

Collaboration
• Documenting data definitions, business rules and quality controls.
• Support the ingestion of source data (bespoke internal systems + 3rd party applications covering, Retail and Wholesale Sales, Stock, Customer, Supply Chain and Finance) into the data lake environment.
• Apply good practice in star-schema modelling, incremental refresh, and DAX/M query optimisation.
• Work with software developers, analysts and self-serve users to shape reporting requirements and ensure data models support their needs.

Data Governance & Quality
• Play a key role in fostering a culture of strong data governance
• Ensure reporting follows consistent definitions and KPIs across the organisation.
• Implement data validation checks and work with system owners to resolve quality issues.
• Help maintain data catalogues, security rules, and sensitivity classifications within Fabric / Azure.

Skills and Experience Requirement
Essential
• Solid understanding of Microsoft Fabric, particularly:
o Lakehouses / Warehouses
o Dataflows Gen2
o Pipelines & notebooks
o OneLake data architecture
• Good knowledge of data modelling (star-schema, fact/dimension design, calculations, DAX, M).
• Strong SQL skills and ability to work with structured/unstructured data.
• Comfortable working in an environment where the data platform is being built from scratch.

Desirable
• Experience with Azure Synapse, Databricks, or other cloud data technologies.
• Exposure to Python or notebooks for data wrangling.
• Understanding of Continuous Integration / Continuous Deployment, DevOps, or version control for BI/workspaces.

This is a unique opportunity to create your own footprints into the Mamas & Papas history books, building a platform that the business can grow and thrive from, supporting an incredible community of new and expectant parents.

Take those amazing first steps and APPLY TODAY