Lead Data Modeler

Programmers.io; Malvern (Chester County); On-site; USD 120,000 - 175,000; Full time

Job summary

Vanguard is seeking a senior data modeling architect to own the Personal Wealth canonical data model and ensure traceability to implementations across advice, wealth management, and client servicing initiatives.

You will collaborate with Enterprise Data Architecture to design reusable concepts, drive governance, and mentor architects, analysts, and engineers in modern data modeling practices. This role requires strong domain knowledge of US capital markets and enterprise-wide data governance.

Qualifications

• 10+ years of experience in data modeling and architecture.
• Proven ability to define canonical and semantic data models.
• Experience with enterprise data governance and metadata management.

Responsibilities

• Own the Personal Wealth logical and canonical data model and maintain traceability to implementation assets.
• Lead development of canonical models supporting householding, advisor teaming, client relationships, investment offerings, and operational workflows.
• Support strategic initiatives by designing canonical models and abstraction layers that isolate business concepts from vendor schemas.
• Define standards and best practices for conceptual, logical, physical, canonical, and semantic data modeling.
• Establish governance processes for model stewardship, versioning, lifecycle management and change control.
• Collaborate with Enterprise Data Architecture and Engineering teams to implement tooling for model management, metadata management, lineage and governance.
• Mentor architects, analysts, and engineers in modern data modeling practices.
• Support data models used across analytics, regulatory reporting, and AI-enabled experiences.

Skills

Data modeling

Enterprise data architecture

Metadata management

ERwin

ER Studio

Python

AWS Cloud Computing

Collibra

US Capital Markets

Tools

ERwin

ER Studio

Job description

ROLE_DESCRIPTION -
Demonstrated expertise in conceptual, logical, canonical, semantic, and physical data modeling.
Deep understanding of enterprise information architecture and metadata management.
Experience developing business-oriented canonical models independent of application implementations.
Strong understanding of business rule modeling, cardinality, optionality, integrity constraints, and
relationship semantics.
Expertise in enterprise modeling patterns such as Party, Role, Agreement, and Classification.
Strong understanding of Supertype / subtype modeling, Temporal modeling. Associative entities, Reference
data design, and Master data concepts
Experience supporting analytics, regulatory reporting, operational data quality, and AI-enabled business use
cases through enterprise data modeling.
Experience establishing or contributing to enterprise data modeling, governance and stewardship functions.
Experience with enterprise data modeling tools such as ERwin, ER Studio, and maintaining enterprise data
dictionaries.
Ability to create reusable business concepts and canonical models that support long-term information
architecture strategy.
Roles & Responsibilities
Partner with business data stewards and product teams to define and evolve business concepts, entities, relationships, and business rules. Own the holistic Personal Wealth logical and canonical data model and maintain traceability to implementation assets. Lead development of canonical models supporting householding, advisor teaming, client relationships, investment offerings, and operational workflows. Support strategic initiatives such as Portfolio of the Future by designing canonical models and abstraction layers that isolate Vanguard business concepts from vendor-specific schemas. Define standards and best practices for conceptual, logical, physical, canonical, and semantic data modeling. Establish governance processes supporting model stewardship, versioning, lifecycle management, and change control. Partner with Enterprise Data Architecture and Engineering teams to implement tooling supporting model management, metadata management, lineage, and governance. Collaborate with integration teams to design Anti-Corruption Layer (ACL) patterns and mapping frameworks between vendor platforms and Vanguard canonical data models. Facilitate workshops to identify, define, and validate enterprise business concepts and relationships. Mentor architects, analysts, and engineers in modern data modeling practices. Support data models used across advice delivery, wealth management, client servicing, analytics, regulatory reporting, and AI-enabled experiences. Drive adoption of enterprise modeling standards and reusable business concepts across product and engineering teams. Establish and promote common business language and shared enterprise concepts across Personal Wealth platforms. Ensure canonical models provide a stable abstraction layer between business domains, internal systems, and vendor platforms.
Skills: Digital : Python~Digital : Amazon Web Service(AWS) Cloud Computing~Digital : Collibra~Domain : US Capital Markets
Experience Required: 10 & Above