Job Title: Software Engineer
City: Toronto
State/Province: Ontario
Posting Start Date: 11/18/26
Job Description:
Job DescriptionRole Purpose
The purpose of this role is to develop multi-module test cases and set up test environments while preparing test evidence and validating system functionality.
͏Areas of responsibility
Requirement Analysis and Documentation-Create technical requirement documents basis the inputs received from clients through discussions and demos.
Creation of test cases-Create test cases basis the functional requirements ensuring test coverage across multiple modules.
Test Data and Environment Setup-Create data validation scenarios and set up test environment in collaboration with the client stakeholder.
Test Execution and Result Analysis -"Execute functional and regression testing to identify defects and document the result of the test cases.
Prepare test evidence and test review documents.
Log and update the defect status in the test management tool."
͏͏͏Key Responsibilities- Design, build, and maintain enterprise ETL/ELT pipelines for data ingestion, transformation, validation, and integration.
- Integrate data from SQL databases, enterprise applications, SharePoint, cloud platforms, and other structured or semi-structured sources.
- Design automated data validation and reconciliation processes to maintain accuracy and integrity.
- Monitor and troubleshoot data pipelines to resolve performance and data-quality issues.
- Support modernization and migration of legacy ETL processes to Azure-based data platforms.
Data Warehousing & Modeling- Design, develop, and maintain enterprise data warehouses and data marts.
- Create dimensional data models using fact/dimension structures, star schemas, and snowflake schemas.
- Develop robust data models to support Finance, Operations, Health & Safety, and executive reporting.
- Design and maintain SSAS/OLAP models and data cubes where required.
- Optimize warehouse structures and queries for scalability and reporting performance.
Business Intelligence & Analytics- Develop interactive dashboards, reports, and analytics solutions using Microsoft Power BI.
- Create advanced measures and transformations using DAX and Power Query.
- Work with business stakeholders to identify and define meaningful KPIs and performance metrics.
- Build executive-level and operational reporting solutions.
- Develop and maintain reports using Power BI, SSRS, and OBIEE.
- Analyze business and operational data to identify trends, anomalies, risks, and opportunities.
Mandatory Skills: Python Application Programming .
Experience: 3-5 Years .
The expected compensation for this role ranges from CAD 60/hr to CAD 70/hr .