Senior Data Modeller Data Product Designer — Enterprise Payments

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 6500 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 teamis looking for a Full-time Senior DataModeller/ Data Product Designer Enterprise Payments

Enterprise Payments is seeking aSenior DataModeller/ Data Product Designerto 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 onschema design data product design and context-layermodelling. The successful candidate will help define howPaymentsdata is represented governed reused and consumed across operational and analytical platforms.

The role is approximately75% data modelling / data product designand25% data engineering enablement working closely with business analysts data engineers analytics teams architects and Payments partners.

The ideal candidate can bridgesemi-structured JSON/MongoDB modellingDatabricks/Delta schema design andreusable domain-oriented data products. The team will provide training onISO 20022 payment schema relationships which will be used to help build a Payments context layer across payment types.

• DesignJSON schemasfor MongoDB-based transactional ODS capabilities aligned to business workflows query patterns and schema evolution needs.

• Design correspondingDatabricks/Delta table schemasfor curated reusable data products.

• Define reusablePaymentsdata products across individual payment types and combined cross-payment views.

• Design acontext layer /canonicalPayments modelthat 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 toUnity Catalogstructures 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 andappropriate documentation.

• Work with business and technology partners to ensure data products are understandable reusable and fit for consumption.

Must Have Skills:

• Strong experience designingJSON / semi-structured schemas preferably for MongoDB or similar document databases.

• Strong experience designingSQL / analytical schemasfor data platforms warehouses orlakehouses.

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

• Paymentsdomain knowledge.

• Awareness of ISO 20022Paymentsschemas 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 withPySpark 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.

#LI-Tech