Full Job Description
Job Title: Software Engineer
City: Toronto
State/Province: Ontario
Posting Start Date: 11/18/26
Job Description:
Role 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
ullet Design, build, and maintain enterprise ETL/ELT pipelines for data ingestion, transformation, validation, and integration.
ullet Integrate data from SQL databases, enterprise applications, SharePoint, cloud platforms, and other structured or semi-structured sources.
ullet Design automated data validation and reconciliation processes to maintain accuracy and integrity.
ullet Monitor and troubleshoot data pipelines to resolve performance and data-quality issues.
ullet Support modernization and migration of legacy ETL processes to Azure-based data platforms.
Data Warehousing & Modeling
ullet Design, develop, and maintain enterprise data warehouses and data marts.
ullet Create dimensional data models using fact/dimension structures, star schemas, and snowflake schemas.
ullet Develop robust data models to support Finance, Operations, Health & Safety, and executive reporting.
ullet Design and maintain SSAS/OLAP models and data cubes where required.
ullet Optimize warehouse structures and queries for scalability and reporting performance.
Business Intelligence & Analytics
ullet Develop interactive dashboards, reports, and analytics solutions using Microsoft Power BI.
ullet Create advanced measures and transformations using DAX and Power Query.
ullet Work with business stakeholders to identify and define meaningful KPIs and performance metrics.
ullet Build executive-level and operational reporting solutions.
ullet Develop and maintain reports using Power BI, SSRS, and OBIEE.
ullet Analyze business and operational data to identify trends, anomalies, risks, and opportunities.
SQL & Database Development
ullet Develop complex SQL, T-SQL, and PL/SQL queries, stored procedures, views, and data-processing scripts.
ullet Optimize SQL queries and database objects to improve performance.
ullet Support SQL Server, Oracle, Azure SQL Database, and related data environments.
ullet Monitor database performance, storage capacity, data integrity, and availability.
ullet Troubleshoot database, replication, and data warehouse issues.
ullet Develop automated database and KPI validation checks.
Mandatory Skills: Python Application Programming .
Experience: 3-5 Years .
The expected compensation for this role ranges from CAD 60/hr to CAD 70/hr .