Senior Data Modeller / Data Product Designer - Enterprise Payments

TD Bank; Toronto; On-site; CAD 105,000 - 129,000; Full time

Job summary

TD Securities seeks a Senior Data Modeller / Data Product Designer to architect end-to-end data structures across the Payments ecosystem, from MongoDB ODS to Azure Databricks curated data products.

The role emphasizes schema design, data product design, and a context layer modelling approach, bridging semi-structured JSON/MongoDB with Databricks schemas and reusable data products for analytics and reporting.

Qualifications

• 8+ years of experience in data modelling across operational and analytical platforms.
• Strong experience designing JSON / semi-structured schemas, preferably for MongoDB or similar document databases.
• Strong experience designing SQL / analytical schemas for data platforms, warehouses, or lakehouses.
• Experience translating business workflows and query patterns into durable, scalable schema designs.

Responsibilities

• Design JSON schemas for MongoDB-based transactional ODS capabilities, aligned to business workflows, query patterns, and schema evolution needs.
• Design corresponding Databricks/Delta table schemas for curated, reusable data products.
• Define reusable Payments data products across individual payment types and combined cross-payment views.
• Design a context layer / canonical Payments model that supports cross-product analytics, reporting, and downstream consumption.
• Translate business requirements into logical and physical data models for both operational and analytical use cases.
• Support schema evolution, versioning, migration, and backward compatibility across MongoDB and Databricks.
• Design data products aligned to Unity Catalog structures, access patterns, discoverability, and governed sharing.
• Differentiate between source-aligned, domain-aligned, and consumer-aligned data products.
• Collaborate with data engineering teams to operationalize models through ingestion, curation, and transformation pipelines.
• Support governance expectations including metadata, data quality, lineage, access controls, and appropriate documentation.
• Work with business and technology partners to ensure data products are understandable, reusable, and fit for consumption.

Skills

Data modelling

JSON schemas

MongoDB

SQL schemas

Tools

MongoDB

Databricks

Unity Catalog

Job description

Work Location

Toronto, Ontario, Canada

Hours

37.5

Line of Business

Technology Solutions

Pay Details

$105,100 - $129,400 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

TD Securities provides a wide range of capital market products and services to corporate, government and institutional clients who choose us for our knowledge and experience in six key areas of finance: Investment Banking, Debt Capital Markets, Institutional Equities, Private Equity, Precious Metals and Foreign Exchange & Money Market. Our services include the underwriting and distribution of new debt and equity issues, providing advice on strategic acquisitions and divestitures, and executing daily trading and investment needs.

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.

We are growth-oriented, people-focused, and community-minded. As a team, we work to deliver value for our clients every day.

Job Description

TDS Payments Technology team is looking for a Full-time Senior Data Modeller / Data Product Designer - Enterprise Payments

Enterprise Payments is seeking a Senior Data Modeller / Data Product Designer to design end-to-end data structures across our Payments data ecosystem - from MongoDB-based transactional Operational Data Stores (ODS) through to Azure Databricks curated data products.

This role is focused on schema design, data product design, and context-layer modelling . The successful candidate will help define how Payments data is represented, governed, reused, and consumed across operational and analytical platforms.

The role is approximately 75% data modelling / data product design and 25% data engineering enablement , working closely with business analysts, data engineers, analytics teams, architects, and Payments partners.

The ideal candidate can bridge semi-structured JSON/MongoDB modelling , Databricks/Delta schema design , and reusable domain-oriented data products . The team will provide training on ISO 20022 payment schema relationships , which will be used to help build a Payments context layer across payment types.

Key Responsibilities

• Design JSON schemas for MongoDB-based transactional ODS capabilities, aligned to business workflows, query patterns, and schema evolution needs.
• Design corresponding Databricks/Delta table schemas for curated, reusable data products.
• Define reusable Payments data products across individual payment types and combined cross-payment views.
• Design a context layer / canonical Payments model that supports cross-product analytics, reporting, and downstream consumption.
• Translate business requirements into logical and physical data models for both operational and analytical use cases.
• Support schema evolution, versioning, migration, and backward compatibility across MongoDB and Databricks.
• Design data products aligned to Unity Catalog structures, access patterns, discoverability, and governed sharing.
• Differentiate between source-aligned, domain-aligned, and consumer-aligned data products.
• Collaborate with data engineering teams to operationalize models through ingestion, curation, and transformation pipelines.
• Support governance expectations including metadata, data quality, lineage, access controls, and appropriate documentation.
• Work with business and technology partners to ensure data products are understandable, reusable, and fit for consumption.

Qualifications & Skills

Must Have Skills:

• 8+ years of experience in data modelling across operational and analytical platforms.
• Strong experience designing JSON / semi-structured schemas , preferably for MongoDB or similar document databases.
• Strong experience designing SQL / analytical schemas for data platforms, warehouses, or lakehouses.
• Experience translating business workflows and query patterns into durable, scalable schema designs.
• Experience with schema evolution, versioning, backwar