Senior Data Engineer, Microsoft Fabric

Central 1; Vancouver, Toronto; On-site; CAD 117,000 - 138,000; Full time

Job summary

Central 1 is seeking a Senior Data Engineer and Microsoft Fabric SME to lead design, implementation, and optimization of enterprise-scale data platforms within the Microsoft Fabric ecosystem.

Lead adoption of Microsoft Fabric with OneLake, Lakehouse, Data Warehouse, Data Factory and Power BI; design scalable pipelines and dimensional models; implement CI/CD with Azure DevOps and Git; ensure governance and performance optimization.

Qualifications

• 2+ years hands-on Microsoft Fabric experience delivering enterprise-scale solutions.
• 8+ years of Data Engineering experience.
• Deep expertise with OneLake, Fabric Lakehouse, Fabric Data Warehouse, Azure Data Factory, Spark, PySpark and SQL.
• Strong enterprise ELT/ETL design experience.
• Experience with Fabric governance, RBAC, lineage, monitoring and performance optimization.
• Azure data ecosystem experience.
• Strong Azure DevOps and Git experience.
• Experience with transformation frameworks such as dbt.

Responsibilities

• Design and build scalable pipelines using OneLake, Fabric Lakehouse, Fabric Data Warehouse, ADF and Azure components.
• Provide technical leadership and mentorship on Microsoft Fabric engineering.
• Develop and optimize ELT/ETL pipelines using SQL, dbt, PySpark, Spark Notebooks and Fabric Data Pipelines.
• Collaborate with Data Architects, Product Owners, Business Stakeholders, and Analytics teams to translate requirements into scalable solutions.
• Implement Medallion Architecture (Bronze, Silver, Gold).
• Establish governance, security, lineage, monitoring and compliance standards.
• Optimize Fabric capacity utilization and performance.
• Design and support enterprise semantic models and Power BI integrations.
• Implement CI/CD using Azure DevOps and Git.
• Design and implement dimensional data models using Kimball modelling principles.

Skills

Microsoft Fabric

Data engineering

ETL/ELT design

dbt

PySpark

Spark

SQL

Azure DevOps

Git

Education

8+ years of Data Engineering experience

Tools

OneLake

Fabric Lakehouse

Fabric Data Warehouse

Azure Data Factory

Spark

PySpark

SQL

Azure DevOps

Git

dbt

Power BI

Job description

Job Summary:

Central 1 is seeking a highly experienced Senior Data Engineer and Microsoft Fabric Subject Matter Expert (SME) to lead the design, implementation, and optimization of enterprise-scale data platforms within the Microsoft Fabric ecosystem.

This role will drive Microsoft Fabric adoption leveraging OneLake, Lakehouse, Data Warehouse, Data Factory and Power BI technologies.

What you'll be doing:

• Design and build scalable Pipelines using OneLake, Fabric Lakehouse, Fabric Data Warehouse, ADF and Azure Components.
• Provide technical leadership and mentorship on Microsoft Fabric engineering, working closely with the Architecture team to ensure alignment with architectural standards and platform best practices.
• Develop and optimize ELT/ETL pipelines using SQL, dbt, PySpark, Spark Notebooks and Fabric Data Pipelines.
• Collaborate closely with Data Architects, Product Owners, Business Stakeholders, and Analytics teams to translate business requirements into scalable technical solutions.
• Implement Medallion Architecture (Bronze, Silver, Gold).
• Establish governance, security, lineage, monitoring and compliance standards.
• Optimize Fabric capacity utilization and performance.
• Design and support enterprise semantic models and Power BI integrations.
• Implement CI/CD using Azure DevOps and Git.
• Design and implement dimensional data models using Kimball modelling principles.

What you'll have:

• 2+ years of hands-on Microsoft Fabric experience delivering enterprise-scale solutions.
• 8+ years of Data Engineering experience.
• Deep expertise with OneLake, Fabric Lakehouse, Fabric Data Warehouse, Azure Data Factory, Spark, PySpark and SQL.
• Strong enterprise ELT/ETL design experience.
• Experience with Fabric governance, RBAC, lineage, monitoring and performance optimization.
• Azure data ecosystem experience.
• Strong Azure DevOps and Git experience.
• Experience with transformation frameworks such as dbt.

Preferred Qualifications:

• DP-700 (Microsoft Certified: Fabric Data Engineer Associate) Fabric certification.
• Power BI semantic models expertise.
• Financial Services experience.

Pay rate: $85.00-$100.00 based on a 40 hour work week

The pay rate represents the job rate determined for the successful candidate who is fully competent in the role. The actual salary will vary depending on market conditions and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training.