Senior Data Modeller / Data Product Designer - Payments

TD Bank Group; Toronto; Hybrid; CAD 105,000 - 129,000; Full time

Job summary

TD Bank Group in Toronto, Ontario, seeks a Senior Data Modeller / Data Product Designer for Enterprise Payments to design end-to-end data structures across the Payments data ecosystem, spanning MongoDB-based ODS to Azure Databricks curated data products.

The role focuses on schema design, data product creation, and a canonical Payments model to enable cross-product analytics, reporting, and governance, with collaboration across business analysts, data engineers, and partners.

Qualifications

• 8+ years of experience in data modelling across operational and analytical platforms.
• Strong experience designing JSON / semi-structured schemas, preferably for MongoDB.
• Strong experience designing SQL / analytical schemas for data platforms, warehouses, or lakehouses.
• Experience translating business workflows into durable, scalable schema designs.
• Experience with schema evolution, versioning, backward compatibility, and migration strategies.
• Experience designing reusable datasets or data products for analytics, reporting, APIs, or downstream consumers.
• Strong understanding of data product concepts, including usability, reuse, ownership, documentation, and consumer alignment.
• Working knowledge of Databricks / Delta Lake schema design, including partitioning and performance considerations.
• Familiarity with Unity Catalog or equivalent governed catalog / metadata structures.

Responsibilities

• Design JSON schemas for MongoDB-based operational data stores.
• Design Databricks/Delta table schemas for curated data products.
• Define reusable Payments data products across payment types.
• Create a context layer / canonical Payments model for cross-product analytics.
• Translate requirements into logical/physical data models for operational and analytical use cases.
• Support schema evolution, versioning, migration, and backward compatibility.
• Coordinate with data engineering to operationalize models via pipelines.
• Support governance: metadata, data quality, lineage, access controls, documentation.
• Collaborate with BSAs, engineers, architects, and business stakeholders.

Skills

JSON schemas

Databricks/Delta schema design

SQL / analytical schemas

Data product design

8+ years data modelling

Unity Catalog familiarity

Communication & collaboration

Tools

MongoDB

Azure Databricks

Snowflake/AWS (general)

Job description

TD Bank Group in Toronto, Ontario, seeks a Senior Data Modeller / Data Product Designer for Enterprise Payments to design end-to-end data structures across the Payments data ecosystem, spanning MongoDB-based ODS to Azure Databricks curated data products.

The role focuses on schema design, data product creation, and a canonical Payments model to enable cross-product analytics, reporting, and governance, with collaboration across business analysts, data engineers, and partners.