SENIOR MICROSOFT DEVELOPER
Location: downtown Toronto business core
Salary: Market rate +
RESPONSIBILITIES
Translate business requirements into detailed technical designs.
Analyze current manual processes and implement automated solutions through detailed design and testing.
Design, build, run, and deploy SSIS-based ETL jobs for data movement and data mart population.
Schedule and orchestrate ETL jobs using Windows Agent and SQL Agent.
Develop dashboards and reports using Power BI.
Design and execute migration paths for moving on-premises MS SQL-based data and SSIS solutions to cloud-based platforms.
Apply agile approach for development and delivery.
Produce estimates for analysis, design, development, and testing.
Support testing activities and troubleshoot integration or functional issues.
Ensure compliance with business, data, and technical requirements.
Ensure compliance with coding standards, client policies, business, data, and technical requirements on client engagements.
REQUIREMENTS
Bachelor’s degree in Computer Science or Engineering.
Minimum 8 years of experience in system design and development for ETL and business intelligence projects.
At least 5 years of experience in ETL development using SSIS and T-SQL-based solutions.
Strong working knowledge in Microsoft SQL Server or Azure SQL databases (standalone or managed instances) and Power BI report/dashboard development.
Experience with GCP is preferred.
Experience in automated unit testing, integration testing, and end-to-end testing.
Experience with release processes and deployments to higher environments such as QA, UAT, and Production.
Working knowledge in agile software methodologies and development tools (e.g., Confluence and Jira).
Good overall business knowledge within the financial industry (in one or more of retail banking, commercial banking, capital markets, wealth management, insurance, pension fund, and fintech).
Excellent communication, diagnostic, and problem-solving skills.
Ability to work independently and excel in a collaborative team environment.