Senior Business Systems Analyst with Data Analysis and RDBMS experience to support a treasury project with one of our major banking clients- 56141

Senior Business Systems Analyst with Data Analysis and RDBMS experience to support a treasury project with one of our major banking clients- 56141

Start Date: 1st position - Sept start, 2nd position - Oct start

Duration: 6 months (High Chance of Extension)

Location: Hybrid/Toronto- 2 days currently, starting Nov 3rd it will be on 4 days on site

STORY BEHIND THE NEED:

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

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

Best vs Average Candidate: good communication, very strong SQL knowledge, previous exposure to banking industry