Data Analytics Engineer (Microsoft Fabric)

Mamas & Papas; Bog Green; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading nursery brand in the UK is seeking a skilled Data Analytics Engineer to design and build a new Microsoft Fabric data platform. This role involves implementing data pipelines, ensuring robust governance, and collaborating with partners. The ideal candidate will have strong SQL skills and a solid understanding of Microsoft Fabric, particularly Lakehouses and Dataflows Gen2. This position presents a unique opportunity to shape the future of data at the company while supporting a community of new parents.

Qualifications

• Solid understanding of Microsoft Fabric, particularly Lakehouses and Dataflows Gen2.
• Good knowledge of data modelling such as star-schema design.
• Strong SQL skills to work with structured and unstructured data.

Responsibilities

• Implement a new Microsoft Fabric platform from the ground up.
• Support design and development of end-to-end data pipelines.
• Collaborate with external partners on platform architecture.

Skills

Microsoft Fabric

SQL

Data modeling

Dataflows Gen2

Data governance

Tools

Azure Synapse

Databricks

Job description

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 aDATA 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

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