ETL Specialist

Toronto, ON
On-site
Posted Nov 10, 2026
1 position

Opens LinkedIn

Employment type: Contract
Experience level: 10+ years
Posting language: English
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Build complex, scalable data pipelines using Data Factory in Microsoft Fabric, and develop Power BI semantic models and reports using Silver and Gold layer data. Create operational and analytical dashboards and paginated reports, including Direct Lake models designed for high-speed reporting from OneLake.

Job details

10+ years experience as Azure technologies including Azure Databricks Azure DataLake Gen 2. Power BI development and semantic modeling Azure DevOps CI/CD PySpark Microsoft Fabric Star Schema or Snowflake data modeling experience Orchestration & Ingestion: Proficiency using Data Factory within Fabric to build complex, scalable data pipelines. Business Intelligence: Designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake. Use of semantic models to design and develop Power BI reports and dashboards. Develop operational and analytical PowerBI reports/paginated reports.

What you’ll do

Requirements

Requires 10+ years of experience with Azure technologies, including Azure Databricks and Azure Data Lake Storage Gen2, as well as Power BI development and semantic modeling. Experience with Azure DevOps CI/CD, PySpark, Microsoft Fabric, star schema or Snowflake data modeling, and data orchestration and ingestion is also required.