Data Engineer (MS Fabric) | Dreams

GT is seeking a Microsoft Fabric Data Engineer on behalf of Dreams to support a large-scale ERP transformation. The role involves building and maintaining Microsoft Fabric data pipelines to extract and transform Dynamics 365 F&O data into clean, business-ready datasets for Excel-based reporting. This project offers hands-on experience with Microsoft Fabric, building scalable data pipelines, and strong interaction with business users to deliver impactful data solutions.

Must Have

• Extract data from Microsoft Dynamics 365 Finance & Operations into Microsoft Fabric
• Build and maintain data pipelines using Medallion architecture (Bronze / Silver / Gold)
• Transform transactional ERP data into business-ready datasets
• Expose structured datasets natively for Excel consumption
• Support creation of simple, column-based Excel reports
• Work closely with business analysts and end users to understand reporting needs
• Collaborate with Dreams’ internal team within their Azure environment
• Ensure secure and reliable access to data
• 5+ years of experience in data engineering with Microsoft Azure-based data platforms
• Hands-on experience with Microsoft Fabric
• Strong data engineering background (SQL, transformations, data modeling)
• Experience working with transactional systems (ERP, finance, operations data)
• Solid understanding of Medallion / layered data architecture
• Experience exposing datasets for Excel-based consumption
• Comfortable working in a business-facing environment
• Strong English communication skills

Good to Have

• Experience with Microsoft Dynamics 365 Finance & Operations
• Broader Azure data platform experience (Synapse, ADF, etc.)
• Power BI experience
• Previous involvement in ERP implementations
• Ability to travel to the UK for initial onboarding or workshops

GT was founded in 2019 by a former Apple, Nest, and Google executive. GT’s mission is to connect the world’s best talent with product careers offered by high-growth companies in the UK, USA, Canada, Germany, and the Netherlands.

On behalf of Dreams, GT is looking for a Microsoft Fabric Data Engineer interested in supporting a large-scale ERP transformation and accelerating data delivery for business users.

• Contract length: 3 months, with possible extension

About Dreams

Dreams is the UK’s most loved and most recommended bed retailer, helping people sleep better for almost 40 years. Founded in 1987 and headquartered in High Wycombe, the company operates at national scale with over 220 stores, 12 delivery centres, and its own manufacturing facility, supported by more than 2,500 colleagues across the UK.

Behind the brand is a highly data-driven, end-to-end operation spanning procurement, manufacturing, logistics, retail, and direct-to-customer delivery, moving over 14,000 products every week. As part of the Composite family, a global $8bn group, Dreams is investing heavily in modern platforms and data capabilities—offering data engineers the opportunity to work with large, complex datasets and deliver solutions that have clear, real-world business impact.

About the Role

Dreams is implementing Microsoft Dynamics 365 Finance & Operations and building a modern data and reporting layer using Microsoft Fabric and Medallion architecture. The project focuses on accelerating the extraction and transformation of ERP data into clean, business-ready datasets that support operational and financial reporting, with Excel as the primary consumption tool. The team works in a pragmatic, delivery-focused environment, closely collaborating with business analysts and end users to ensure data is reliable, accessible, and valuable from day one.

What makes this project interesting:

• Hands-on work with Microsoft Fabric in a live ERP transformation
• Building scalable data pipelines and standardized data models from transactional systems
• Strong interaction with business users and clear visibility of impact

Role goal: To support the ERP implementation by building and maintaining Microsoft Fabric data pipelines that transform Dynamics 365 F&O data into clean, consumable datasets for Excel-based reporting, helping business teams access data quickly and reliably.

Responsibilities:

• Extract data from Microsoft Dynamics 365 Finance & Operations into Microsoft Fabric
• Build and maintain data pipelines using Medallion architecture (Bronze / Silver / Gold)
• Transform transactional ERP data into business-ready datasets
• Expose structured datasets natively for Excel consumption
• Support creation of simple, column-based Excel reports
• Work closely with business analysts and end users to understand reporting needs
• Collaborate with Dreams’ internal team within their Azure environment
• Ensure secure and reliable access to data

Essential knowledge, skills & experience:

• 5+ years of experience in data engineering, with a strong focus on Microsoft Azure–based data platforms
• Hands-on experience with Microsoft Fabric
• Strong data engineering background (SQL, transformations, data modeling)
• Experience working with transactional systems (ERP, finance, operations data)
• Solid understanding of Medallion / layered data architecture
• Experience exposing datasets for Excel-based consumption
• Comfortable working in a business-facing environment
• Strong English communication skills

Nice-to-have

• Experience with Microsoft Dynamics 365 Finance & Operations
• Broader Azure data platform experience (Synapse, ADF, etc.)
• Power BI experience
• Previous involvement in ERP implementations
• Ability to travel to the UK for initial onboarding or workshops

Interview Steps

1. GT interview with Recruiter

2. Technical interview

3. Final interview