Lead Azure Data Engineer at 3Pillar Global

📋 Description

• Lead data platforms using Data Lakehouse on Azure (Fabric, Azure SQL, Power BI) as SME.
• Design and implement scalable data models, ETL/ELT pipelines, and analytics layers.
• Architect Fabric reporting with medallion layering and CDC/mirroring from Azure SQL.
• Enforce data-layer segregation to exclude PII and ensure multi-tenant isolation.
• Lead migrations from legacy systems (AirTable, Smartsheet) to Fabric; manage per-client exports.
• Lead end-to-end analytics projects from requirements to deployment; mentor juniors.

🎯 Requirements

• 7-10 years of data engineering and BI experience.
• Azure Data Stack expertise: Azure SQL, Microsoft Fabric, Power BI; 2+ years hands-on.
• Advanced SQL and Data Lakehouse concepts, medallion architecture, star/snowflake, dimensional modeling.
• Proficiency in Python for data engineering, ETL/ELT workflows, and automation.
• Experience designing and maintaining enterprise-grade data pipelines in Azure.
• Proven track record leading analytics projects and delivering scalable data solutions.

🎁 Benefits

• Medical & dental insurance - employee contributions
• LTD, Life & AD&D insurance - employee paid
• Paid time off
• 10 Paid Holidays
• RRSP with Employer Matching
• Flexible work policy