Manager - Stress Testing Data, Controls and Analytics

The Toronto-Dominion Bank (Canada); Toronto; On-site; CAD 97,000 - 137,000; Full time

Job summary

The Toronto-Dominion Bank in Toronto, Ontario is seeking a senior Manager to lead stress testing data, controls and analytics. You will drive aggregation, data mapping, governance and regulatory reporting while modernising MST 2.0 using Python, Databricks and Power BI.

You will challenge results, ensure audit-ready evidence and collaborate with cross-functional teams. The role requires extensive experience in stress testing, data engineering and analytics, with a strong focus on governance,

Qualifications

• University degree or higher in a quantitative field.
• 5+ years of experience in stress testing, regulatory reporting, or related areas.
• Demonstrated experience with large datasets, mappings, transformations and controlled reporting.
• Ability to translate requirements into data specifications, controls and tests.
• Advanced SQL and Python for data manipulation, validation, automation and testing.
• Experience with Databricks or similar cloud analytics platforms.
• Strong Power BI experience including data modelling and dashboards.

Responsibilities

• Lead or coordinate aggregation, validation and submission of stress testing results and related reporting.
• Translate regulatory template requirements into data, ownership, control and reporting needs.
• Coordinate cross-workstream activities, monitor data readiness, and communicate status to stakeholders.
• Review results, perform variance analysis, and ensure audit-ready support for submissions.
• Design and govern data quality rules, lineage, metadata and reconciliation points.
• Support modernized data pipelines and analytics products using Python and Databricks.

Skills

Stress testing

Regulatory reporting

Data manipulation

Python

Databricks

SQL

Power BI

Data governance

Education

University degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, Data Engineering, or related quantitative discipline

Tools

Python

Databricks

SQL

Power BI

SAS

Excel

Job description

Work Location: Toronto, Ontario, Canada Hours: 37.5 Line of Business: Analytics, Insights, & Artificial Intelligence Pay Details: $96,900 - $136,800 CAD This role is eligible for a discretionary variable compensation award that considers business and individual performance. 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: Department Overview

The Enterprise Stress Testing group manages the Bank’s enterprise and regulatory stress testing programs, ad hoc stress analysis and support for climate stress analysis. The group coordinates scenario execution, balance sheet and income statement projections, aggregation of results, and reporting to senior management, Board committees and regulators. The Aggregation & Control team is responsible for combining outputs from multiple workstreams and producing complete, accurate, controlled and traceable enterprise stress testing results.

Role Overview

The Manager, Stress Testing Data, Controls & Analytics is a senior hands-on delivery role within Aggregation & Control. The role combines stress testing subject-matter expertise, data management, technical analysis, control design, regulatory reporting and cross-functional delivery. The successful candidate will sustain current MST and EWST execution while helping modernize the operating model for MST 2.0 using Python, Databricks and Power BI. This role requires a professional who can move confidently between business requirements, regulatory templates, data mappings, transformation logic, controls, reconciliations and executive-ready reporting. The individual must be able to challenge results, investigate issues to root cause, translate requirements for technology partners and maintain audit-ready evidence of key decisions and approvals.

Key Accountabilities

1. Stress Testing Execution and Regulatory Reporting

   • Lead or coordinate the aggregation, validation and submission of MST, EWST and related regulatory stress testing results, including templates, supporting schedules and management reporting outputs.
   • Interpret regulatory template requirements and translate them into clear data, mapping, ownership, control and reporting requirements for business segments and technology partners.
   • Coordinate cycle activities across workstreams, monitor data readiness and issue resolution, and provide clear status, risks and decisions to senior stakeholders.
   • Perform detailed review and challenge of results, including actuals, projections, ratios, adjustments, eliminations, scenario and version comparisons, and movement analysis.
   • Maintain complete and audit-ready support for submissions, including approvals, attestations, reconciliations, control evidence, issue logs and change records.

2. Data Aggregation, Mapping and Governance

   • Own and maintain critical mapping and reference data used to connect source data, regulatory codes, management reporting line items, model outputs, schedules and enterprise reporting views.
   • Design and govern data quality rules, lineage, ownership dictionaries, metadata and reconciliation points across the end-to-end aggregation process.
   • Partner with Finance, business segments, reporting teams and technology to improve access to source data, reduce manual data handling and establish reusable governed datasets.
   • Support the design and implementation of stress testing data marts, semantic models and scalable data structures that provide a controlled single source for reporting and analysis.
   • Assess downstream impacts of source, methodology, template and configuration changes and ensure changes are appropriately tested, approved and documented.

3. Controls, Reconciliation and Assurance

   • Design, execute and enhance preventative and detective controls for completeness, accuracy, reasonability, mapping integrity, version consistency, actuals-to-projection continuity, ratios and consolidation eliminations.
   • Investigate data and reporting exceptions, determine root cause, quantify impact, coordinate remediation and document conclusions for management and audit review.
   • Establish repeatable testing, peer review and sign-off practices for configuration files, data transformations, dashboards, reports and automation solutions.
   • Monitor controls performed by technology teams and dependent workstreams, challenge unresolved exceptions and confirm evidence is sufficient for regulatory and internal assurance expectations.
   • Identify opportunities to automate reconciliations, exception reporting, attestation workflows and evidence capture.

4. MLE 2.0 and Analytics Modernization

   • Act as a business and data lead for the transition from SAS and Excel-intensive processes toward Python and Databricks-based data pipelines, controls and analytics.
   • Translate current business logic, mappings and controls into well-defined requirements, acceptance criteria and test cases for MST 2.0 and MLE 2.0.
   • Use Python, SQL and Databricks notebooks to profile data, validate transformations, reconcile outputs, automate repeatable analysis and support production readiness.
   • Design or oversee Power BI semantic models, measures, dashboards and reporting products that support controlled self-service analysis and consistent enterprise reporting.
   • Ensure modernized solutions include versioning, lineage, role-based access, change control, testing, monitoring, documentation and support procedures from inception.
   • Support parallel-run testing and back-testing between current and target-state solutions, with clear documentation of variances, defects and resolution.

5. Process Improvement and Change Delivery

   • Lead initiatives to automate manual actuals population, projections, adjustments, ratio checks, management and regulatory reconciliations, and recurring reporting outputs.
   • Develop process maps, business requirements, control requirements, implementation plans, test strategies, standard operating procedures and training materials.
   • Prioritize enhancements based on regulatory risk, control effectiveness, cycle efficiency, scalability and stakeholder value.
   • Coordinate delivery across business, data, technology and reporting teams and ensure solutions are operationally supportable after implementation.
   • Promote reusable design patterns, disciplined documentation and continuous improvement across the Aggregation & Control function.

6. Stakeholder Leadership

   • Build strong working relationships across Enterprise Stress Testing, Finance, Treasury, business segments, Data, Technology, Risk and regulatory reporting teams.
   • Communicate complex data, financial and technical issues clearly to audiences with varied levels of seniority and technical expertise.
   • Facilitate working groups, requirements discussions, issue-resolution sessions and decision forums, and drive actions to completion.
   • Provide technical and process guidance to team members and project resources and support knowledge transfer for critical processes.

Required Qualifications and Experience

· University degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, Data Engineering, or another relevant quantitative discipline.

· Five or more years of progressive experience in stress testing, regulatory reporting, treasury, finance data, risk data, advanced analytics, data engineering or a related field.

· Demonstrated experience working with large financial datasets, complex mappings, transformation logic, reconciliations and controlled reporting processes.

· Experience translating business and regulatory requirements into data specifications, controls, test cases and implementation deliverables.

· Advanced SQL skills and practical programming experience in Python for data manipulation, validation, automation and testing.

· Hands-on experience with Databricks or a comparable cloud analytics platform, including notebooks, data pipelines, data quality checks and version-controlled development practices.

· Advanced Power BI experience, including data modelling, semantic models, DAX, report development, refresh processes, security concepts and performance considerations.

· Working knowledge of SAS and Excel sufficient to understand, validate and transition existing stress testing processes and end-user computing solutions.

· Strong understanding of data governance, lineage, metadata, change management, control design and audit evidence requirements.

· Excellent written and verbal communication, stakeholder management, problem solving and project delivery skills.

Preferred Qualifications and Experience

· Knowledge of enterprise stress testing, MST, EWST, OSFI regulatory templates, capital, liquidity, balance sheet and income statement concepts.

· Experience with MLE, M4, P3, BCAR, Hyperion/FCCS, regulatory reporting data or comparable financial reporting infrastructure.

· Experience designing star schemas, governed semantic layers, reusable reporting datasets or data marts for financial reporting.

· Experience with Azure data services, ADLS, Git or Azure DevOps, CI/CD practices, automated testing and production support controls.

· Experience leading cross-functional initiatives and supporting implementation through requirements, design, testing, deployment and stabilization.

· CPA, CFA, FRM, MBA, PMP, data engineering, cloud or analytics certification is an asset.

Core Competencies and Personal Qualities

· Deep analytical curiosity and strong attention to detail

· Controls mindset and professional skepticism

· Ability to connect business, financial and technical concepts

· Sound judgement under tight regulatory timelines

· Structured problem solving and root-cause analysis

· Clear executive and technical communication

· Strong relationship management and ability to influence

· Ownership, initiative and follow-through

· Comfort operating through ambiguity and change

· Commitment to documentation, knowledge transfer and sustainable solutions

Work activities include a blend of highly collaborative activities and individual deliverables. Individuals are expected to be onsite 4 days a week. Colleagues may spend more or less days in office as required by the business line.

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 strive to make every interaction, product, and experience remarkably human and refreshingly simple for 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 foster deeper relationships, ensure disciplined execution, and build a simpler, faster banking experience. TD is deeply committed to being a leader in client experience, that is why we believe that all colleagues, no matter where they work, are client facing. Together, we are reimagining what banking can be for our clients, colleagues and communities.

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. If you’re passionate about helping clients and building deep, lasting relationships, TD offers diverse career paths where you can grow your expertise and make a meaningful impact. We're committed to your success and foster a respectful workplace where diverse perspectives are valued, everyone has fair opportunities to grow, and you can unlock your full potential to achieve your career goals. Here at TD, we hire and develop the best.

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 US Labor & Employment Posters | California Privacy | Accessibility | FAQ

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