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.
- Experience implementing Medallion architecture (Bronze/Silver/Gold layers).
- Knowledge of data security, including row-level and column-level security.
- Experience with data lineage tracking.
Education
Relevant Educational Qualifications.
Work Arrangement
The position is onsite in Toronto, Ontario. The resource is expected to work 7.25 hours per calendar day, Monday to Friday, within standard working hours of 8:00 AM to 5:00 PM, excluding lunch breaks.
