Data Engineer (MS Fabric) | Dreams
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
Work format: Remote, with on-site onboarding in the UK (1-2 weeks, expenses covered)
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
Work directly with D365 F&O tables, data entities, and the underlying data model
Understand how transactions flow through the system (sales orders, inventory, finance, procurement, etc.)
Interpret business logic embedded in F&O rather than relying solely on exported data
Troubleshoot issues where the root cause sits inside F&O rather than in Fabric
Collaborate with our F&O functional and technical teams using the correct terminology and system understanding
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 and D365 Finance & Operations.
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
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
GT interview with Recruiter
Technical interview
Final interview