Sr. Business Systems Analyst: SQL, Spark

er 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:

Department Overview :

Building a World-Class, Diverse and Inclusive Technology Team

We can't afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it a business imperative for us to be smart and open-minded in the way we think about technology. TD's technology and business teams become more intertwined as new opportunities present themselves. This new era in banking does not equal boring. Not at TD, anyway.

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.

There is room for all to grow in it.

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

Job Requirements :

What can you bring to TD? Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. It helps if you have:

Mandatory Skills:

• Experience working on large scale projects as well as handling day-to-day operational requests from the business

• 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

• Being comfortable working in a distributed teams environment

• Strong problem solving skills

• Bachelor's degree in either computer science, electrical engineering, information technology, or statistics

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

Additional Information :

Join in on what others in TD Technology Solutions are doing:

• Inspire a positive work environment and help champion quality, innovation, teamwork and service to the business.

• Learn voraciously, stretch your thinking, share your knowledge and educate others.

• Communicate and collaborate with both technical and non-technical professionals.

• Cultivate winning relationships by building trust with business and technology partners.

• Share our commitment to productivity, effectiveness and operational efficiency.

#LI-Tech

Who We Are:

TD Securities offers a wide range of capital markets products and services to corporate, government, and institutional clients who choose us for our innovation, execution, and experience. With more than 6,500 professionals operating out of 40 cities across the globe, we help clients meet their needs today and prepare for tomorrow. Our services include underwriting and distributing new issues, providing trusted advice and industry-leading insight, extending access to global markets, and delivering integrated transaction banking solutions. In 2023, we acquired Cowen Inc., offering our clients access to a premier U.S. equities business and highly-diverse equity research franchise, while growing our strong, diversified investment bank. We are growth-oriented, people-focused, and community-minded. As a team, we work to deliver value for our clients every day.

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