Sr. Business Systems Analyst

TD Bank; Toronto; Hybrid; CAD 76,000 - 116,000; Full time

Job summary

A leading financial institution is seeking a Sr. Business Systems Analyst in Toronto. The role involves analyzing business requirements, optimizing SQL statements, and collaborating with technology teams. Candidates should have a strong background in data analysis and Agile methodologies. This hybrid position offers competitive compensation and opportunities for professional growth.

Benefits

Health and well-being benefits

Savings and retirement programs

Paid time off

Career development

Qualifications

• 5-7 years relevant experience on large scale projects.
• Experience in data analysis and performance tuning of SQL statements.

Responsibilities

• Analyze and document business rules requirements.
• Build extraction pipelines for regulatory requirements.
• Collaborate with technology teams for implementation.

Skills

Data Analysis

Problem Solving

Communication

Agile Methodology

Education

Undergraduate degree or Technical Certificate

Bachelor’s degree in a STEM field

Tools

Advanced Excel

Spark SQL

Visual Studio

SQL Integration Services

Hadoop

NoSQL databases

Job description

Sr. Business Systems Analyst page is loaded

Sr. Business Systems Analyst

Apply remote type Hybrid locations Toronto, Ontario time type Full time posted on Posted Yesterday time left to apply End Date: May 24, 2025 (8 days left to apply) job requisition id R_1395990

Work Location:

Toronto, Ontario, Canada

Hours:

37.5

Line of Business:

Technology Solutions

Pay Details:

$76,800 - $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 at TD. Our 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.

Job Description:

Within TBSM Technology, the Treasury Analytics Group (TAG) is dedicated to support the Treasury and Balance Sheet Management (TBSM) department in measuring and managing balance sheet, market and liquidity risks for the Bank's portfolios, both in Canada and US. This group manages technology infrastructure, processes and projects required to support various functional teams in TBSM

Within TAG, the Indigo team manages the "Indigo" Hadoop/Spark platform, which is used for collecting and storing incoming retail and wholesale banking activity data and also the resulting treasury related metrics such as Non-Trading Market Risk (NTMR) and Fund Transfer Pricing (FTP). The platform also supports the generation of key regulatory liquidity reporting such as FR2052A.

This is an exciting opportunity for a Business Systems Analyst to join the team and work on industry standard and cutting-edge technologies including Big Data and NoSQL databases (Hadoop, Hbase, Hive, SPARK and MongoDB) and help TBSM effectively manage the risk.

Examples of projects/work activities include (but not limited to):

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

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 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
• Works independently as the senior or lead system analyst and coaches/guides members within area of expertise
• Subject matter expert and consults with clients and/or project teams
• Reports to a Manager, Senior Manager, or Practice Lead

Experience and/or Education

• Undergraduate degree or Technical Certificate
• 5 -7 relevant experience working on large scale projects as well as handling day-to-day operational requests from the business
• Hands on experience in Advanced Excel
• SDLC / Agile methodology experience
• Over 3 years of 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
• Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
• Being comfortable working in a distributed teams environment
• Strong problem solving skills
• Experience working in Agile

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
• Bachelor’s degree in a STEM field

Who We Are:

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.

TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

Our Total Rewards Package
Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more

Additional Information:
We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

Colleague Development
If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.

Training & Onboarding
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process
We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.

Accommodation
Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Language Requirement (Quebec only):

Sans Objet

Similar Jobs (4)

Sr. Business Systems Analyst, TD Securities

remote type Hybrid locations Toronto, Ontario time type Full time posted on Posted 6 Days Ago time left to apply End Date: May 30, 2025 (14 days left to apply)

Business System Analysis, TD Securities

remote type Hybrid locations Toronto, Ontario time type Full time posted on Posted Yesterday time left to apply End Date: May 30, 2025 (14 days left to apply)

Sr. Business Systems Analyst

remote type Hybrid locations Toronto, Ontario time type Full time posted on Posted 7 Days Ago time left to apply End Date: May 22, 2025 (6 days left to apply)

Our Values
At TD we’re guided by our purpose to enrich the lives of our customers, communities and colleagues, and share a set of values that shape our culture and guide our behavior. In exchange for how our colleagues show up to help TD succeed, we are committed to delivering a colleague experience grounded in Impact, Growth and a Culture of Care. No matter where you work across TD, we empower you to make an impact at work and in your community, explore and grow your career and be part of our caring and inclusive culture.

Our Commitment to Diversity, Equity, and Inclusion
At TD, we’re committed to fostering an environment where all colleagues are encouraged to bring their authentic selves to work, experience equitable opportunities, and feel respected and supported. We’re dedicated to building an inclusive workforce that reflects the diversity of the customers and the communities in which we live and serve.

Helping to Make an Impact in Communities – TD Ready Commitment
TD has a long-standing commitment to help drive progress towards a more inclusive and sustainable future. That’s why we launched the TD Ready Commitment in 2018, now a multi-year North American initiative. Under the TD Ready Commitment, we are targeting a total of C$1 billion by 2030 in community giving across four key, interconnected drivers of change: Financial Security, Vibrant Planet, Connected Communities, and Better Health. It’s our goal to help support change, nurture progress, and contribute to making the world a better, more inclusive place for our customers, colleagues, and communities. Learn more: Canada | US | Europe & Asia Pacific