Fabric Migration Lead Consultant

Dive deep into Digital! For 20 years Intellias has been developing top-tier digital solutions for the world’s leading companies, keeping them in line with the latest technology trends. Join in and provide innovations for the future!

What project we have for you

Our client is a leading multi-brand technology solutions provider to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index and employs approximately 15K coworkers.

What you will do

Key Responsibilities

Guide the team through assessment of the current SQL DW/Synapse environment, dependencies, and risks.

Define the target Fabric architecture (Warehouse vs Lakehouse, OneLake layout, environments).

Create a migration playbook: standards, templates, and reusable patterns for schema, data, and pipelines.

Provide hands-on support on complex areas: T-SQL refactoring, schema migration, initial & incremental loads.

Help re-platform or design Data Factory / pipeline solutions in Fabric.

Establish data validation and performance patterns (row counts, checksums, query parity).

Set and socialize security & governance patterns (RBAC, RLS/CLS, sensitivity labels, dev/test/prod).

Coach, mentor, and perform code/pipeline reviews, raising the team’s Fabric skills.

Communicate status, risks, and technical decisions to engineering and business stakeholders.

What you need for this

Required Experience & Skills

5+ years with Azure SQL Data Warehouse / Synapse dedicated SQL pools or similar MPP DW.

Strong T-SQL skills (complex queries, DDL/DML, performance tuning).

Solid data warehousing background (facts/dimensions, SCDs, star/snowflake).

Hands-on ETL/ELT experience with Azure Data Factory / Synapse pipelines or similar.

Working knowledge of Microsoft Fabric (Warehouse, Lakehouse, OneLake, Data Factory, workspaces).

Proven track record in data platform migrations (on-prem or cloud → modern DW/lakehouse).

Experience mentoring or leading engineers, defining standards an