Data Engineer - Microsoft Fabric

iO Associates; England; Remote; GBP 80,000 - 100,000; Part time

Job summary

A leading data consultancy in the UK is seeking an experienced Data Engineer for a contract position focused on modernising Business Intelligence and Data Warehousing environments using Microsoft Fabric. The role involves leading migrations, redesigning data architectures, and building ETL/ELT pipelines. Ideal candidates will have a deep understanding of SQL Server and modern data principles. This position offers competitive rates for impactful work.

Qualifications

• Demonstrable experience in Data Warehousing.
• Strong SQL Server skills including T-SQL.
• Proven ETL/ELT experience.
• Experience with Microsoft Fabric or Databricks is desirable.
• Understanding of lakehouse data architecture.
• Ability to produce technical specifications.

Responsibilities

• Lead migration to Microsoft Fabric.
• Redesign data models and warehouses.
• Build and optimise ETL/ELT pipelines.
• Ensure data quality and governance.
• Produce technical design specifications.
• Collaborate with architects and stakeholders.

Skills

Data Warehousing experience

Strong SQL Server skills

Proven ETL/ELT experience

Microsoft Fabric or Databricks

Understanding of modern data architectures

Ability to write technical specifications

Curious mindset

Problem-solving skills

Tools

SQL

Python

Azure Data Factory

Fabric Data Factory

Job description

Location: Remote (UK)

Rate: £500 - £600 per day (Outside IR35)

Contract: 3 months initially, with strong potential to extend

iO Associates are partnered with a rapidly scaling data consultancy on a major programme to modernise enterprise Business Intelligence and Data Warehousing environments using Microsoft Fabric. This role sits at the heart of a transformation initiative moving legacy on-premises and cloud-based DW solutions into a unified, next-generation Fabric platform.

We're looking for a hands-on Data Engineer with deep experience across BI, SQL Server, and ETL development, who can also contribute to high-quality design specifications and modern data architecture decisions. If you enjoy solving complex data challenges while shaping the direction of a next-generation analytics ecosystem, this is an ideal contract.

The Role

• Lead the migration and redevelopment of existing BI/DW assets into Microsoft Fabric.
• Redesign data models, warehouses, and lakehouse structures to support analytics, reporting, and scalable downstream consumption.
• Build and optimise ETL/ELT pipelines using SQL, Python, and Fabric Data Factory.
• Develop tables, views, stored procedures, and functions within modernised Fabric-based environments.
• Ensure data quality, lineage, governance, and performance best practices across both lakehouse and warehouse workloads.
• Produce high-quality technical design specifications for data solutions.
• Work collaboratively with solution architects, BI developers, and business stakeholders to deliver a smooth migration and tangible value.

Required Skills & Experience

• Demonstrable experience within Data Warehousing in Business Intelligence environments (both on-premises and cloud).
• Strong SQL Server skills including T-SQL, stored procedures, views, tables, and functions.
• Proven ETL/ELT experience, ideally with Azure Data Factory.
• Microsoft Fabric or Databricks experience is highly desirable.
• Understanding of modern data architectures, including lakehouse principles.
• Ability to write clear, maintainable technical and design specifications.
• Investigative, curious mindset with a drive for continuous improvement and learning new tools, frameworks, and languages.
• Someone who approaches challenges with humility and has the courage to drive positive change.

If you're a Data Engineer ready to take on impactful contract work and deepen your expertise in Microsoft Fabric, please send over your most up-to-date CV!