Software Developer - ETL - Intermediate

Procom-b5a780c3; Toronto; In loco; CAD 90.000 - 120.000; Tempo pieno

Descrizione del lavoro

Procom is seeking an intermediate Software Developer - ETL for a 4-month onsite role in Toronto, ON. You will design, develop, and maintain Power BI dashboards and data models to support government reporting and analytics within the Ontario Data Platform initiative.

The role requires strong skills in DAX, Power Query, SQL, and data warehousing, with collaboration across data engineering and stakeholders to ensure data quality and governance.

Competenze

• Experience creating dashboards and visualizations with Power BI.
• Proficiency in DAX, Power Query (M), and data modeling concepts.
• Strong SQL knowledge and relational database experience.
• Understanding of data warehousing and dimensional modeling best practices.
• Excellent analytical, problem-solving, and communication skills.
• Ability to collaborate with technical and non-technical stakeholders.
• Knowledge of data governance, metadata management, and data lineage.

Mansioni

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Create data models, measures, and calculations using DAX.
• Implement data visualization best practices for intuitive, accessible reports.
• Gather and translate business requirements into reporting solutions.
• Connect and integrate data from databases, APIs, cloud platforms, and data warehouses.
• Collaborate with data engineering to ensure data quality, governance, and consistency.
• Monitor and optimize report performance, data refresh schedules, and workspace administration.

Conoscenze

Power BI

DAX

Power Query (M)

Data modeling

SQL

Relational databases

Data warehousing

Dimensional modeling

Analytical thinking

Communication skills

Stakeholder collaboration

Data governance

Data lineage

Strumenti

Databricks

Azure Data Lake Storage

Azure Synapse Analytics

Azure Data Factory

Microsoft Fabric

Python

R

Descrizione del lavoro

Software Developer - ETL - Intermediate:On behalf of our government client, Procom is searching for a Software Developer - ETL - Intermediate for a 4-month role. This position is onsite at our client’s Toronto, Ontario office.Software Developer - ETL - Intermediate - Job Description:The Government of Ontario is undertaking a large-scale Data & AI transformation initiative with the Ontario Data Platform (ODP) to enhance data-driven decision-making. The project involves the development, maintenance, and enhancement of enterprise reporting and analytics solutions.Software Developer - ETL - Intermediate - Responsibilities:• Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs.• Create data models, measures, and calculations using DAX to deliver meaningful business insights.• Implement data visualization best practices to ensure reports are intuitive, accessible, and actionable.• Gather and analyze business requirements and translate them into reporting solutions.• Connect and integrate data from various enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.• Collaborate with data engineering teams to ensure data quality, governance, and consistency across reporting solutions.• Monitor and optimize report performance, data refresh schedules, and workspace administration.Software Developer - ETL - Intermediate - Mandatory Skills:• Experience developing dashboards, reports, and visualizations using Microsoft Power BI.• Strong knowledge of DAX, Power Query (M), and Power BI data modeling concepts.• Experience working with SQL and relational databases.• Understanding of data warehousing, dimensional modeling, and business intelligence best practices.• Strong analytical, problem-solving, and communication skills.• Ability to work collaboratively with technical and non-technical stakeholders.• Knowledge of data governance, metadata management, and data lineage principles.Software Developer - ETL - Intermediate – Nice-to-Have Skills:• Experience working with Databricks, including connecting Power BI to Databricks SQL Warehouses and Lakehouse data sources.• Familiarity with Azure Data Platform services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, or Microsoft Fabric.• Experience with enterprise data governance and data quality initiatives.• Knowledge of Python, R, or other analytics tools.• Experience supporting data and analytics platforms within a large public-sector or enterprise environment.Software Developer - ETL - Intermediate – Assignment Length:This is a 4-month contract position with a possible extension.Software Developer - ETL - Intermediate - Start Date:ASAP.Software Developer - ETL - Intermediate - Assignment Location:Toronto, Ontario, onsite 5 days a week.This posting is for an existing vacancy.This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.