Data Analytics Engineer; Microsoft Fabric

IT Huddersfield (Head Office) Overview

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 a DATA ANALYTICS ENGINEER on (Microsoft Fabric).

As Data Analytics Engineer you will design, build and maintain a new Microsoft Fabric data platform from the ground up. This unique 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.

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 One Lake.
• 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.

Essential

• Solid understanding of Microsoft Fabric, particularly:
  • Lake houses / Warehouses
  • Dataflows Gen2
  • Pipelines & notebooks
  • One Lake 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, Dev Ops, or version control for BI/work spaces.

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

Take those amazing first steps and APPLY TODAY.

We're a business that cares. Here's just some of our benefits on offer;

• 33 days holiday, increasing up to 40 with service.
• Buy & Sell holiday schemes.
• Company Bonus Schemes.
• Employer pension contribution from day 1 enrolment.
• Significant staff discounts for family & friends from our shops & online.
• Ongoing offers & discounts across a variety of external organisations, from holidays, travel, restaurants, gifts & services to many more worthy discounts through our Benefits Hub.
• Subsidised health & critical illness cover and insurances.
• Supportive family related leave policies (including company enhanced pay for maternity, IVF & Fertility, surrogacy, paternity, adoption, shared parental leave).
• Supportive Foster Care & Carers Leave offering.
• Support for Loss and Bereavement.
• A Menopause Friendly Employer.
• Employee Recognition and Appreciation Schemes.

At Mamas & Papas, we’re a business for the future. Every day, we help to welcome a new generation of children into the world, and we want them to grow up in a world that’s sustainable – one that’s full of opportunity and hope.

...Oh, and a great bunch of people to work with too.

• Hybrid flexi working of 3 days in the office.
• Flexi‑time schemes based around core working hours whether in the office, or working from home.
• Plus, free car parking, Prayer & Contemplation room, subsidised canteen, free tea & coffee, Games & TV rooms & much more.

(NB*: All benefits subject to individual schemes criteria & terms)