Senior Data Modeller / Data Product Designer — Enterprise Payments
The Toronto-Dominion Bank (Canada)
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Benefits offered by this job
Job summary
The Toronto-Dominion Bank (Canada) is seeking a Senior Data Modeller / Data Product Designer for the Enterprise Payments data ecosystem. You will design end-to-end data structures from MongoDB ODS to Azure Databricks curated products, focusing on schema design and context-layer modelling.
The role is ~75% data modelling / data product design and ~25% data engineering enablement, partnering with analysts, engineers, architects, and Payments partners to build reusable data products and governance
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.
- Experience with schema evolution, versioning, backward compatibility, and migration strategies.
- Experience designing reusable datasets or data products for analytics, reporting, APIs, or downstream consumers.
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
Tools
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.
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.
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.
- 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.
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, 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.
- Strong SQL skills.
- Ability to work closely with BSAs, engineers, architects, and business stakeholders.
- Excellent communication, documentation, analytical thinking, and problem-solving skills.
Good To Have Skills:
- Payments domain knowledge.
- Awareness of ISO 20022 Payments schemas and relationship structures.
- Experience designing canonical data models or context layers across multiple source systems.
- Experience with MongoDB indexing, sharding, performance tuning, or MongoDB Atlas.
- Experience with PySpark, Spark SQL, Delta Lake optimization, and Databricks performance patterns.
- Experience with Azure Databricks, Azure Data Factory, Azure Synapse, or similar cloud data services.
- Experience with Kafka, event schemas, schema registry, or streaming data patterns.
- Familiarity with data governance processes such as privacy impact assessments, data access controls, metadata standards, lineage, and regulated-environment audit expectations.
- Experience with Collibra or similar catalog / data governance tooling.
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.
- base salary
- variable compensation
- health and well-being benefits
- savings and retirement programs
- paid time off
- banking benefits and discounts
- career development
- reward and recognition programs
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.
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.
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.
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.
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.
Sans Objet
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.
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.
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
