CLDRSRC10416 - Azure Data Engineer/ETL Developer - Toronto

Must haves: • 6+ 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. Responsibilities: • Analyze data and design semantic models • Transform raw data into silver/gold data for reporting consumption. • Design, develop, and release deploy Power BI reports and dashboards meeting KPIs including accuracy, reliability and performance. • Review business requirements (and related materials) to use as input for design/development of reports • Design technical systems specifications to translate into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. • Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations. • Provide specialized skills for developing data access queries • Works in conjunction with data analysts for developing dashboards and other end user reporting products • Supports Client's wide-ranging business information requirements, implementing and supporting OLAP analytical software solutions • Develops and supports customized query applications which analyze key business data Experience and Skill Set Requirements Mandatory Skills and Experience: • 6+ 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. Desirable Skills and Experience: • Experience in Azure Data Factory (ADF) v2 • Data Architecture & Engineering: Competency in building Lakehouses and Warehouses , writing optimized PySpark or SQL pipelines, and implementing Medallion architecture (Bronze/Silver/Gold layers). • Data Governance: Data security (row-level/column-level), and data lineage tracking.