Business Systems Analyst (Data)

*********For a TOP5 bank in Canada!*********

Job Overview

Title - Business Systems Analyst (Data Management/Analytics & SQL)

Duration – 12 Months Contract + possible extensions!

Location – *Hybrid - 1 time a week to office, in Toronto, ON

Rate: $60-70 per hour INC

Typical Day in Role

• Work with Program lead to manage requirements related activities and deliverables throughout the project life cycle (e.g. change requests, issues, risks, schedules, status reporting etc.).

• Work with the Project Owner and Project Manager to document the project vision and the project’s scope.

• Work with the Project Delivery Teams to identify, anticipate, assess, manage and resolve issues and risks related to requirements' activities and deliverables.

• Play a key role in understanding and evolving data-engineered solutions to enable the risk modeling capabilities of our RMA business partners

• Thoroughly understand and communicate stakeholder requirements and distribute relevant information, documentation and artifacts to project stakeholders.

• Elicit requirements using interviews, document analysis, requirements workshops, surveys, use cases, scenarios, business analysis and workflow analysis.

• Translate high-level business and user requirements into functional & IT specific requirements with appropriate level of detail suitable for use by those who must base their work & development on the requirements.

• Develop and execute function, end-to-end test cases to ensure requirements are met

• Responsible for data analysis, profiling, data mapping, data lineage activities to support business requirements, and data governance requirements.

• Proactively communicate and collaborate with external and internal customers to analyze information needs.

• Work collaboratively with Business and IT staff to develop and maintain thorough knowledge of product, system and process capabilities, ensuring precise communications between IT and stakeholders, technical compatibility and user satisfaction.

• Providing support to month-end and quarter-end risk model calculations and Capital/Regulatory reporting until transitioned to operations team.

Candidate Requirements/Must Have Skills:

• 10+ years’ relevant experience, with at least 5+ years’ recent experience as a BSA

• Recent hands-on experience writing and reading advanced SQL queries independently

• 4+ years’ experience data management and data analytics experience is required

• Banking experience and understanding of the industry is required

• SDLC knowledge is required

Nice-To-Have Skills:

• Retail product experience and associated risk models is an asset (PD,EAD, LGD models for Mortgage, Credit Card)

• Working knowledge of SAS, Informatica, DataStage, or Python are an asset

• Database Systems: Hive/Hadoop, DB2 is an asset