RQ11487 – Software Developer – ETL – Senior

Job summary

Design and build scalable data pipelines, transform raw data into Silver and Gold layers, and develop semantic models and Power BI reports and dashboards. Translate business requirements into tested applications, troubleshoot data and software issues, and support analytical reporting and OLAP solutions.

Job details

Client: Ministry of Public and Business Service Delivery and Procurement – RQ11487 We are seeking a highly experienced Senior Software Developer – ETL with strong expertise in Azure data technologies, data engineering, ETL development, Microsoft Fabric, Azure Databricks, PySpark, and Power BI. The ideal candidate will have hands-on experience designing and developing scalable data pipelines, transforming raw data into structured Silver and Gold layers, building semantic models, and developing high-performance Power BI reports and dashboards. The successful candidate will support enterprise data architecture, business intelligence, data integration, and analytical reporting initiatives while ensuring data accuracy, reliability, security, and performance. Role Snapshot Job Title: RQ11487 – Software Developer – ETL – Senior Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 40 St. Clair Avenue West, Toronto, Ontario, Canada Work Arrangement: Onsite – 5 Days per Week Estimated Start Date: October 5, 2026 Estimated End Date: March 31, 2027 Business Days: 123.00 Extension: 60.00 Hours: 7.25 hours per day Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding lunch breaks Security Level: No Clearance Required Must Have 6+ years of experience with Azure technologies, including: Azure Databricks Azure Data Lake Gen 2 Power BI development and semantic modelling Azure DevOps CI/CD PySpark Microsoft Fabric Star Schema or Snowflake data modelling experience Orchestration & Ingestion Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines. Business Intelligence Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake. Experience using semantic models to design and develop Power BI reports and dashboards. Ability to develop operational and analytical Power BI reports and paginated reports. Description To respond to the priorities of the Government of Ontario through the passage of Bill 5, Protect Ontario by Unleashing Our Economy Act, 2025, the resource may be partially assigned to Bill 5-related projects or initiatives on an as-needed basis. Responsibilities The successful candidate will be responsible for the following: Analyse 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 to use as input for the design and development of reports. Design technical system specifications and translate them into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining applications, and conducting unit tests. Resolve and troubleshoot technical problems that arise 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 in conjunction with data analysts to develop dashboards and other end-user reporting products. Support the client's wide-ranging business information requirements by implementing and supporting OLAP analytical software solutions. Develop and support customized query applications that analyse key business data. Desirable Skills And Experience Experience with Azure Data Factory (ADF) v2. Data Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines, and implementing Medallion Architecture (Bronze/Silver/Gold layers). Data Governance: Experience with data security, including row-level and column-level security, and data lineage tracking. Experience And Skill Set Requirements The candidate will be evaluated based on the following experience and skill categories: Mandatory Skills and Experience — 70% 6+ years of experience with Azure technologies, including Azure Databricks, Azure Data Lake Gen 2, Power BI development and semantic modelling, Azure DevOps CI/CD, PySpark, and Microsoft Fabric. Experience with Star Schema or Snowflake data modelling. Proficiency in using Data Factory within Microsoft Fabric to build complex and scalable data pipelines. Experience designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models for 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 — 25% Experience with Azure Data Factory (ADF) v2. Competency in building Lakehouses and Warehouses. Experience writing optimized PySpark or SQL pipelines. Experience implementing Medallion Architecture, including Bronze, Silver, and Gold layers. Knowledge of data security, including row-level and column-level security. Experience with data lineage tracking. Education — 3% Education-related qualifications and experience as applicable to the role requirements. Public Sector Experience — 2% Public sector experience relevant to the assignment and the Government of Ontario's business and information requirements. How to Apply If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Tuesday, November 10, 2026, at 9:00 AM EST. Mandatory Documents Updated Resume in Word format (Mandatory) References (Mandatory) Expected Hourly Rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory) Without the mandatory documents, we cannot submit a candidate. WhatsApp Group For daily job updates, you can also join our WhatsApp group using the link below: Join our WhatsApp Group Additional Information Work Arrangement and Working Hours This position is listed as Onsite, unless otherwise instructed by the Client. The resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00 AM and 5:00 PM, excluding lunch breaks, every Monday to Friday inclusive, at the identified Ontario Public Service (OPS) office location. Onsite Requirement: 5 days per week. Email is the best way to reach us. You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.

What you’ll do

Design and build scalable data pipelines, transform raw data into Silver and Gold layers, and develop semantic models and Power BI reports and dashboards. Translate business requirements into tested applications, troubleshoot data and software issues, and support analytical reporting and OLAP solutions.

Requirements

Requires at least six years of experience with Azure data technologies, including Databricks, Data Lake Gen2, Microsoft Fabric, PySpark, Azure DevOps CI/CD, and Power BI semantic modeling. Candidates should also have experience with star schema or Snowflake modeling, Fabric Data Factory pipelines, Direct Lake models, and operational, analytical, and paginated reports.

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 Modeling
• Snowflake Modeling
• Data Factory
• Direct Lake
• Data Pipeline Development
• ETL Development
• SQL
• Medallion Architecture
• Data Security

Job areas

• Data & Analytics
• Software
• Technology
• Government & Public Sector

More jobs from S M Software Solutions Inc