Senior Business Systems Analyst with SQL and Power BI experience to support an EOL decommissioning project for a Legacy Value-At-Risk (VAR) project with on

Senior Business Systems Analyst with SQL and Power BI experience to support an EOL decommissioning project for a Legacy Value-At-Risk (VAR) project with one of our major banking clients- 39690

Location Address: Hybrid - Toronto - 2 days/week (Tues, Wed)

Subject to change: 3-4 days onsite may be required based on business needs

Contract Duration: ASAP to 10/31/2026 (Possibility of extension & conversion to FTE)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group: GBME - Risk Technology - software development for market risk technology - 3 developers on the team currently

Project: We are seeking a Contract Business Analyst to join our Market Risk Technology team. This role is focused on an end-of-life (EOL) decommissioning project for a legacy Value-at-Risk (VaR) application. The successful candidate will act as the functional bridge between Market Risk Managers and the Development team to ensure a seamless transition to modern platforms.

Typical Day in Role:

The primary objective of this role is to translate legacy system logic into clear requirements for the new Java and Power BI target states.

• Requirements Gathering: Work with Risk Managers to document existing legacy VaR reporting, graphing, and portfolio hierarchy management workflows.

• Functional Specification: Define the logic and data mapping required to migrate legacy graphs and reports into Power BI dashboards.

• Process Mapping: Document the legacy portfolio hierarchy and risk limits functionality to assist developers in building a replacement application

• Data Validation & UAT: Coordinate User Acceptance Testing (UAT) and perform data reconciliation between the legacy system and the new platform

Candidate Requirements/Must Have Skills:

1) 10+ years as a Business Systems Analyst, with proficiency in writing clear functional specifications, user stories, and mapping documents.

2) 5+ years’ experience querying databases using SQL for data analysis and validation.

3) 3+ years’ experience Power BI capabilities to effectively guide the migration of reporting and visualization.

4) Experience working creating and managing business reports

Nice-To-Have Skills:

1) Experience with Market Risk concepts, specifically Value-at-Risk (VaR), risk limits, and portfolio hierarchical structures

Soft Skills Required:

• Good communication skills

Education:

Bachelor’s in relevant field

Best VS. Average Candidate:

Ideal candidate is a strong BSA who has knowledge or experience in market risk and has good PowerBI reporting skills

Candidate Review & Selection - Interview Process

2 rounds - Teams Video Interviews - 30 minutes - standard

1st with HM

2nd with Director