Data Engineer – Microsoft Fabric

Systematix; Vaughan; On-site; CAD 103,000 - 117,000; Full time

Job summary

Systematix is seeking a Data Engineer to design, build, and operate a Microsoft Fabric data platform. You will own data pipelines, lakehouses, and semantic layers, enabling analytics, AI initiatives, and BI reporting for enterprise clients.

You will collaborate with Data Engineering, Solutions Architecture, and business stakeholders to deliver scalable data solutions, ensure data quality, and drive performance improvements across the Fabric environment.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field or equivalent.
• 3–7+ years of data engineering experience.
• Strong SQL / T-SQL skills with performance tuning.
• Hands-on Microsoft Fabric experience or Azure Synapse/Databricks with Power BI.
• Knowledge of star schemas, keys, incremental loading, and CDC.
• Experience with Delta Lake and OneLake.
• Git-based version control and deployment pipelines.
• Excellent communication skills.

Responsibilities

• Design, build, and maintain the Microsoft Fabric data platform and data products to support analytics, reporting, web applications, and AI initiatives.
• Work with Data Engineering, Solutions Architecture, analysts, and business stakeholders to deliver scalable, reliable enterprise data solutions.
• Design, build, and maintain lakehouses, warehouses, and MLVs across multiple Fabric workspaces.
• Ingest data from on-premises and cloud sources using gateway connections, mirrored databases, copy jobs, shortcuts, and Data Factory pipelines.
• Implement medallion architecture (bronze/silver/gold) for enterprise data.
• Build and maintain semantic models and curated views supporting Power BI reporting, Cortex/AI search, Fabric IQ/ontology, Snowflake integrations, and downstream AI assistants.

Skills

SQL / T-SQL

Microsoft Fabric

Data modeling

Delta Lake

Git-based version control

Power BI

Education

Bachelor's degree in Computer Science or related

Tools

Azure Synapse/Databricks

Git

Power BI

Job description

We are Systematix and we are currently looking for a Data Engineer – Microsoft Fabric for our client.

ABOUT THE PROJECT:

Our client is building out an enterprise analytics platform on Microsoft Fabric, supporting customer-facing web applications, AI assistants, and business reporting directly from its data lake.

This is a hands-on build-and-operate role within the IT Solutions Architecture / Data & Analytics team. The Data Engineer will work closely with the senior Data Engineer and Solutions Architecture team, taking ownership of the pipelines, lakehouses, warehouses, and semantic layers that move data from ERP, CRM, e-commerce, and other operational systems into Microsoft Fabric.

The successful candidate will work directly within the platform, creating pipelines, modeling data, troubleshooting failed runs, tuning performance, and partnering with analysts, architects, and business stakeholders to transform raw operational data into trusted, secure, and query-ready assets.

ABOUT THE RESPONSIBILITIES:

In this role, you will design, build, maintain, and optimize the Microsoft Fabric data platform and the data products that support analytics, reporting, web applications, and AI initiatives. You will work closely with Data Engineering, Solutions Architecture, analysts, and business stakeholders to deliver scalable and reliable enterprise data solutions.

Key responsibilities include:

• Design, build, and maintain lakehouses, warehouses, and Materialized Lake Views (MLVs) across multiple Microsoft Fabric workspaces.
• Ingest data from on-premises and cloud sources using gateway connections, mirrored databases, copy jobs, shortcuts, and Data Factory pipelines.
• Ensure source tables have appropriate primary keys and are replication-ready.
• Develop and orchestrate data pipelines and Dataflows Gen2 for batch and near-real-time ingestion and transformation.
• Implement and maintain a medallion architecture (bronze/silver/gold) for enterprise data.
• Work with Delta tables and change-data feed / CDC-style replication to maintain current lake data while effectively managing data volume, history windows, and incremental loads.
• Build and maintain semantic models and curated views supporting Power BI reporting, Cortex/AI search, Fabric IQ / ontology, Snowflake integrations, and downstream AI assistants.
• Monitor, troubleshoot, and optimize pipeline failures, long-running Power BI refreshes, and capacity or performance issues across Microsoft Fabric.
• Apply and maintain data governance and security standards, including workspace access, version control, deployment pipelines, row-level security, column-level security, and masking.
• Collaborate with analysts and business stakeholders to translate data requirements into well-modeled, documented, and reusable data products.

REQUIREMENTS:

Must-have:

• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• 3–7+ years of experience in data engineering or a closely related data role.
• Strong hands-on SQL / T-SQL skills, including query authoring, views, troubleshooting, and performance tuning.
• Hands-on experience with Microsoft Fabric, including lakehouse and warehouse implementations, pipelines, and notebooks, or strong equivalent experience with Azure Synapse/Databricks and Power BI.
• Strong data modeling fundamentals, including star schemas, keys, incremental loading, and CDC patterns.
• Experience with data integration and orchestration across heterogeneous on-premises and cloud data sources.
• Working knowledge of Delta Lake and OneLake concepts.
• Experience with Git-based version control and deployment pipelines.
• Strong troubleshooting and analytical skills, including the ability to diagnose pipeline, refresh, and platform-performance issues.
• Excellent written and verbal communication skills with both technical and business audiences.

Nice-to-have:

• Microsoft Certified: Fabric Data Engineer Associate (DP-700).
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
• Power BI report and dashboard development experience.
• Experience with DAX and semantic-model design for self-service analytics.
• Strong data visualization and storytelling capabilities.
• Experience gathering and clarifying reporting requirements with business stakeholders.
• Exposure to Python and analytical tooling beyond SQL.
• PySpark / Spark notebook experience for large-scale transformations.
• Exposure to Snowflake and/or Databricks.
• Familiarity with Copilot Studio, Fabric APIs, Fabric IQ / ontology, Cortex Search, and AI/agent integrations.
• Understanding of Microsoft Purview, data governance frameworks, and security models such as RLS, CLS, and masking.
• Experience with Microsoft Azure cloud services.
• Familiarity with AI-assisted development tools such as GitHub Copilot, OpenAI Codex, or Claude Code for pipeline development, SQL authoring, and troubleshooting.

ABOUT THE ROLE:

Reports to: Manager, IT Solutions Architecture

Works closely with: Data Engineering and Solutions Architecture teams

Work hours: [e.g., 37.5 hrs/week]

PAY DISCLOSURE:

The hourly pay rate for this senior-level position is $75–$85/hr.

Compensation is commensurate with these standards; exceptions may apply based on experience, skills, and market conditions.

AI DISCLOSURE:

We may use artificial intelligence (AI) or other automated tools to support parts of our recruitment process. No automated tools make hiring decisions.

ABOUT SYSTEMATIX:

Systematix is one of Canada’s largest privately-owned National Consulting and Resourcing firms. With offices across North America, we provide the highest-caliber consulting solutions to a diverse client base that includes all levels of government and private industry sectors.

Systematix is committed to creating a diverse, inclusive environment and is proud to be an equal opportunity employer.

Systematix. Results Focused. People Driven.