About this role
Senior Software Developer ETL
Location: Toronto, Ontario
Position Type: Contract
Work Arrangement: Onsite 5 days per week
Hourly Rate: $60-$67 inc
Contract Duration: 123 days + 60 days
Job Description
The resource may be partially assigned to projects or initiatives related to Bill 5, Protect Ontario by Unleashing Our Economy Act, 2025, on an as-needed basis.
The successful candidate will be responsible for analyzing data, designing semantic models, transforming raw data into Silver/Gold data for reporting consumption, and developing Power BI reports and dashboards.
Key Responsibilities
- Analyze data and design semantic models.
- Transform raw data into Silver/Gold data for reporting consumption.
- Design, develop, release, and deploy Power BI reports and dashboards that meet KPIs, including accuracy, reliability, and performance.
- Review business requirements and related materials as input for report design and development.
- Design technical system specifications and translate them into working, tested applications.
- Develop detailed programming specifications, write and/or generate code, compile data-driven programs, maintain applications, and conduct unit testing.
- Resolve and troubleshoot technical problems arising during the use and operation of software packages, including providing technical assistance with implementation, conversion, and migrations.
- Provide specialized skills for developing data access queries.
- Work with data analysts to develop dashboards and other end-user reporting products.
- Support business information requirements by implementing and supporting OLAP analytical software solutions.
- Develop and support customized query applications to analyze key business data.
Mandatory Skills and Qualifications
- Minimum 6+ years of experience with Azure technologies, including:
- Azure Databricks.
- Azure Data Lake Gen2.
- Power BI development and semantic modeling.
- Azure DevOps CI/CD.
- PySpark.
- Microsoft Fabric.
- Star Schema or Snowflake data modeling.
- Proficiency in using Data Factory within Microsoft Fabric to build complex, scalable data pipelines.
- Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to enable high-speed reporting directly from OneLake.
- Experience using semantic models to design and develop Power BI reports and dashboards.
- Experience developing operational and analytical Power BI reports and paginated reports.
Desirable Skills and Experience
- Experience with Azure Data Factory (ADF) v2.
- Experience building Lakehouses and Warehouses.
- Experience writing optimized PySpark or SQL pipelines.
- Exper