Intermediate Technical Business Analyst to work on a Basel III implementation project using SQL for a large banking client - 30434

Job Type: Contract
Positions to fill: 2
Start Date: Jul 03, 2023
Job End Date: Feb 29, 2024
Pay Rate: Hourly: Negotiable
Job ID: 130257
Location: Toronto
Intermediate Technical Business Analyst to work on a Basel III implementation project using SQL for a large banking client - 30434

Location Address: Hybrid (1x/week on site), Downtown Toronto
Contract Duration: ASAP until 02/29/2024

Business group: The Risk Modeling Technology team supports various stakeholders Global Risk Management (GRM) - Risk Models and Analytics Team, Regulatory Capital, IFRS9 provisioning & Enterprise stress Testing team in the implementation of regulatory and non-regulatory initiatives, utilizing both Agile and Waterfall approaches.

Risk Modeling Technology team is seeking an experienced Technical Business Analyst with practical business analysis experience and technical capabilities to navigate and drive resolution of complex business problems. The role will require liaising with stakeholders on existing and/or new business initiatives, delivering solutions to meet the needs of multiple lines of business stakeholders, and managing medium to large projects, and providing ongoing support. The candidate must have strong project management, communication skills, with hands on experience in execution of all key phases on project lifecycle (e.g. requirements gathering, documentation, design and development, testing, implementation). The incumbent will have strong data analytics skills capabilities using SQL, understanding data models, ability to read and understand code such as SQL, SAS, IBM Informatica, IBM DataStage. 

Project: Basel III project, working on the Risk Modelling technology team

Typical Day in Role
• 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.
• 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

Must Have Skills:
• 8+ years’ as a Technical Business Analyst
• Experience writing and reading advanced SQL queries independently
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, Python
• Database Systems: Hive/Hadopp, DB2

Degrees or certifications:
• Bachelor's degree in a related field required.

Candidate Review & Selection
• Structure and Format: MS Teams Interviews (video)
o First round: behavioral and technical interview with HM and team BA
o Second round: behavioral panel interview