Software Developer - ETL
- Toronto, ON, Canada
$60 to $68 CAD / hour · Full-time
Applications open in a new tab.
Job details
- Pay
- $60 to $68 CAD / hour
- Job type
- Full-time
- Apply by
- Experience
- Minimum 6+ years of experience with Azure technologies, including:
- Posting language
- English
- Posted
Original job description
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
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.
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.
- 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.
- 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.
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.
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- Azure Databricks
- Azure Data Lake Gen2
- Power BI
- Semantic Models
- Azure DevOps
- CI/CD
- PySpark
- Microsoft Fabric
- Data Factory
- Direct Lake
- OneLake
- Star Schema
- Snowflake Modeling
- Azure Data Factory v2
- Lakehouses
- Warehouses
- SQL
- Medallion Architecture
- Bronze Layer
- Silver Layer
- Gold Layer
- Row-Level Security
- Column-Level Security
- Data Lineage
- OLAP
- Paginated Reports
- Data Pipelines
- Data Modeling
- Data Migration
- Bill 5