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 Dev

Ops 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 productive Direct Lake semantic models in Power BI using Silver/Gold layer models to enable high-speed reporting directly from One

Lake.

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.

📌 Software Developer - ETL (Toronto)
🏢 Hirematic Talent Solutions
📍 Toronto