Business Systems Analyst

• Reason for request/why opened: Specific project to support
• 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

• Degree/Certifications Required: Post secondary (asset)
• Years of experience: 8+
• % Interaction with Stakeholders: 30%
• Ideal Candidate Background: banking industry (asset)
• How will performance be measured: meeting deliverables and deadlines
• Selling Points of Position (CVP): exposure to capital markets, treasury and balance sheet management of the bank. Tech stacks like java, Hadoop, azure cloud.
• Best vs Average Candidate: good communication, very strong SQL knowledge, previous exposure to banking industry

• 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

• 8+ years of experience working on large scale projects as well as handling day-to-day operational requests from the business
• 4+ years of experience with data analysis
• Familiarity with the general concepts of optimization and performance tuning of SQL statements.
• Familiarity with RDBMS (Oracle, SQL Server)

• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills
• Being comfortable working in a distributed teams environment
• Strong problem-solving skills

• Experience in financial services industry, specifically in Capital Markets and Treasury
• Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus

ProViso Consulting