Sr. Bus Systems Analyst - 56374

Duration: 6 months, possibility to extend

Location: Hybrid, 4x a week, Toronto, ON

Scope of Project:

Project 1: Changing processes and creating adjustment framework for treasury feed’s (accepting data) (Sept start date)

Project 2: Transformation and integration of Canadian feeds for treasury (Oct start date)

Team Size/Culture: 10+ people

Selling Points of Position (CVP): exposure to capital markets, treasury and balance sheet management of the bank. Tech stacks like java, Hadoop, azure cloud.

SUMMARY OF DAY-TO-DAY RESPONSIBILITIES:

• Analyze, document and validate business rules requirements from business users.

• As Spark SQL is used as a programming language for the business rules, a successful candidate is required to be able to write, test Spark SQL statements to translate the business requirements into the programming code.

• Optimize performance and tune Spark SQL statements

• Use Visual Studio (SQL Integration Services) to analyze SSIS packages

• Analyze multiple system builds by completing and updating project requirements documentation; understanding project scope; determining project priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths.

• Collaborate closely with the technology team to implement the requirements, provide necessary guidance to testers during QA process

• Assess business process and system inefficiencies

• Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes

• Participate in standup and planning meeting as part of the Agile methodology framework

MUST-HAVE Hard Skills:

1.) 8+ years of experience working on large scale projects as well as handling day-to-day operational requests from the business

2.) 4+ years of experience with data analysis

3.) Familiarity with the general concepts of optimization and performance tuning of SQL statements.

4.) Familiarity with RDBMS (Oracle, SQL Server)

NICE-TO-HAVE

1.) Experience in financial services industry, specifically in Capital Markets and Treasury

2.) Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus