Fabric Migration Lead Consultant

Meet your recruiter Kateryna Zemetska

kateryna.zemetska@intell...

Vacancy details

Data Engineering

Data Architect

Architect

Bulgaria,

Colombia,

Croatia,

Egypt,

Malta,

Poland,

Portugal,

Spain,

Ukraine,

United Kingdom,

United States

Remote

Apply now

Refer a friend now

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 and reviewing designs.
Strong communication skills; able to explain options and trade-offs to non-technical stakeholders.

Nice to Have

Production experience with Fabric (shortcuts, notebooks, Delta-based Lakehouse workloads).
Strong Power BI skills (models on Fabric Warehouse/Lakehouse, Direct Lake).
DevOps/CI-CD for data platforms (Git integration, automated deployments).
Familiarity with Microsoft Purview or other catalog/lineage tools.
Microsoft certifications (Azure Data Engineer, Solutions Architect, Power BI, Fabric when available).

What it’s like to work at Intellias

At Intellias, where technology takes center stage, people always come before processes. By creating a comfortable atmosphere in our team, we empower individuals to unlock their true potential and achieve extraordinary results. That’s why we offer a range of benefits that support your well-being and charge your professional growth.
We are committed to fostering equity, diversity, and inclusion as an equal opportunity employer. All applicants will be considered for employment without discrimination based on race, color, religion, age, gender, nationality, disability, sexual orientation, gender identity or expression, veteran status, or any other characteristic protected by applicable law.
We welcome and celebrate the uniqueness of every individual. Join Intellias for a career where your perspectives and contributions are vital to our shared success.