Data Analytics Engineer (Microsoft Fabric)

Peoplebank; Huddersfield; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading omni-channel nursery brand is seeking a Data Analytics Engineer to design and build a new Microsoft Fabric data platform. You will work closely with external partners to create and maintain data pipelines and ensure data quality. Essential skills include Microsoft Fabric, SQL, and data modelling techniques. The role offers hybrid working flexibility, competitive benefits, and opportunities for professional growth in a supportive environment.

Benefits

33 days holiday, increasing to 40

Company Bonus Schemes

Employer pension contribution

Significant staff discounts

Subsidised health cover

Flexible working arrangements

Qualifications

• Solid understanding of Microsoft Fabric and Lakehouses/Warehouses.
• Good knowledge of data modelling techniques.
• Strong SQL skills for structured and unstructured data.
• Experience in building data platforms from scratch.

Responsibilities

• Implement and maintain a new Microsoft Fabric platform.
• Support design and development of data pipelines.
• Collaborate with partners on platform architecture.
• Ensure data quality and governance within the organization.

Skills

Microsoft Fabric

SQL

Data modelling

Dataflows Gen2

Star-schema

Tools

Azure Synapse

Python

Databricks

Job description

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.

Key Responsibilities

Data Engineering and Platform Build

• Implement 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
• Integrate operational systems (ERP, POS, eComm, CRM, HR, Finance) into OneLake
• Support data quality frameworks, validation rules and automated checks

Collaboration

• Document 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 Lakehouses / Warehouses, Dataflows Gen2, Pipelines & notebooks, 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 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.

Benefits

• 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

Work Location

• 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
• 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)