MS Fabric Data Architect

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Intellias

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!

• 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, One Lake, Data Factory, work spaces).
• 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).
• Dev Ops/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).

• Guide the team through assessment of the current SQL DW/Synapse environment, dependencies, and risks.
• Define the target Fabric architecture (Warehouse vs Lakehouse, One Lake 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.

• Mid-Senior level

• Full-time

• Consulting

• IT Services and IT Consulting

We’re committed to diversity and equal opportunity. Applications are welcome from all qualified individuals.