MS Fabric Data Architect

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! 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). 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.