Software Developer - ETL

Job summary

Analyze data, design semantic models, and transform raw data into Silver and Gold layers for reporting. Develop, deploy, and support Power BI reports, dashboards, query applications, and analytical solutions while troubleshooting technical issues and ensuring accuracy, reliability, and performance.

Job details

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.

What you’ll do

Analyze data, design semantic models, and transform raw data into Silver and Gold layers for reporting. Develop, deploy, and support Power BI reports, dashboards, query applications, and analytical solutions while troubleshooting technical issues and ensuring accuracy, reliability, and performance.

Requirements

Requires at least six years of experience with Azure technologies, including Databricks, Data Lake Gen2, Power BI, Azure DevOps CI/CD, PySpark, and Microsoft Fabric. Candidates should have experience with scalable Fabric Data Factory pipelines, Direct Lake semantic models, Power BI reporting, and star schema or snowflake modeling; experience with ADF v2, lakehouses, warehouses, optimized pipelines, Medallion architecture, security, and data lineage is desirable.

Listed skills

• Power BI · Preferred
• SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Azure Databricks
• Azure Data Lake Gen2
• Power BI
• Semantic Modeling
• Azure DevOps CI/CD
• PySpark
• Microsoft Fabric
• Star Schema
• Snowflake Data Modeling
• Data Factory
• Direct Lake
• SQL
• Medallion Architecture
• Data Security
• Data Lineage
• OLAP

Job areas

• Technology
• Software
• Data & Analytics

More jobs from Hirematic Talent Solutions