SQL Analyst

Background:

• SQL Data analysis and expertise in big data
• The Treasury Analytics Group is responsible for measurement and management of market risk (interest rate and foreign exchange) for the Bank’s retail portfolios. The team develops financial models and processes required for measuring, transfer pricing, hedging product profitability, and financial management reporting.
• The Treasury Analytics Group is embarking on a brand new initiative to build the next generation strategic platform for risk, valuations and analytics to meet the growing and future needs of the department.
• This is an exciting opportunity to work on cutting edge technologies including Big Data and NoSQL databases (Hadoop, Hbase, Hive, SPARK and MongoDB) to allow the business to gain advanced insight into their portfolios and valuation metrics.

About this Role:

• 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 the 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 meetings as part of the Agile methodology framework.

Mandatory Skills:

• Experience working on large scale projects as well as handling day-to-day operational requests from the business.
• 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.

Nice to Have 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.

Job Details:

Contract: 18 months
Location: Toronto
Job ID: 12729