Senior Business Systems Analyst

Work Location:

Toronto, Ontario, Canada

37.5

Technology Solutions

$81,600 - $115,200 CAD

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience  compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.

As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

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 No

SQL databases (Hadoop, HBase, Hive, Spark and Mongo

DB) to allow the business to gain advanced insight into their portfolios and valuation metrics.

• Lead business requirements elicitation, analysis, and documentation efforts
• Assist technology team in Azure cloud solution implementation; write Spark SQL queries to analyze and transform data; provide feedback to User Interface team; testing and documentation
• Analyze solution requirements; understand project scope; determine project priorities; ensure efficient and on-time delivery of project tasks and milestones; follow proper escalation paths
• Look for opportunities for process improvement and automation
• 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

• Onboarding new feeds to ensure completeness and accuracy of TBSM metrics.
• Build extraction pipelines from Indigo to other applications to support regulatory or business requirements.
• Integrate third party vendor based upstream data sources or downstream analytics with Indigo.
• Migrate Indigo to the Azure Cloud.
• Guide junior BSAs in the team.
• Code review of junior BSAs.
• Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production.

• Leverage specialized domain, product, and systems knowledge to have a thorough understanding of the business, product, and vision; provide business-technology interaction subject matter expertise as well as recognize and drive the focus toward business value.
• Identify, document, and validate current state technology capabilities/ecosystem and support stakeholders to design the desired future state; provide recommendations and/or…