Job Description

Candidate Profile Details:

• 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

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:

• 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)

Soft Skills:

• 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

Nice-To-Have:

• 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

Job Details
13637
Contract
8 months
Toronto
91.00 CAD
Recruiter
Pranshu Gupta

Skills Required