Lead Data Modeler

Tata Consultancy Services; Malvern (Chester County); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Discretionary annual incentive

Comprehensive medical coverage (M/H, D

401K Plan

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services is seeking a senior data modeling professional to own and evolve the Personal Wealth canonical data model and related architectures. You will drive architecture for householding, advisor teaming, client relationships, investments, and operational workflows.

You will collaborate with business data stewards, product teams and Enterprise Data Architecture to enforce standards, governance, and reusable concepts across Wealth platforms.

Qualifications

• Demonstrated expertise across conceptual, logical, canonical, semantic and physical data modeling.
• Deep understanding of enterprise information architecture and metadata management.
• Experience building business-oriented canonical models independent of applications.
• Strong knowledge of business rule modeling, cardinality, optionality, integrity constraints and relationship semantics.
• Expertise with enterprise modeling patterns such as Party, Role, Agreement and Classification.
• Strong understanding of Supertype/subtype modeling, Temporal modeling, associative entities and master data concepts.
• Experience supporting analytics, regulatory reporting, data quality and AI-enabled use cases via data modeling.
• Ability to contribute to governance, stewardship and model lifecycle processes.

Responsibilities

• Partner with data stewards and product teams to define and evolve business concepts and relationships.
• Own Personal Wealth logical and canonical data model and ensure traceability to implementations.
• Lead development of canonical models for householding, advisor teaming and client relationships.
• Support Portfolio of the Future by designing canonical models and abstraction layers that isolate business concepts.
• Define standards and best practices for conceptual to semantic data modeling.
• Establish governance processes for model stewardship, versioning, lifecycle, and change control.
• Collaborate with architecture/engineering to implement tooling for model management, metadata, lineage, and governance.
• Work with integration teams on ACL patterns and mapping frameworks to vendor platforms.
• Facilitate workshops to identify and validate enterprise concepts and relationships.
• Mentor architects, analysts and engineers in modern data modeling practices.
• Support data models used across wealth management, analytics and AI-enabled experiences.
• Drive adoption of enterprise modeling standards across product and engineering teams.
• Promote common business language across Personal Wealth platforms.
• Ensure canonical models provide stable abstractions between business domains and systems.

Skills

Conceptual data modeling

Logical data modeling

Canonical data modeling

Semantic data modeling

Physical data modeling

Enterprise information architecture

Metadata management

Business rules modeling

Modeling patterns (Party, Role, Class,

Supertype/subtype modeling

Temporal modeling

Governance & stewardship

Data dictionaries

ERwin / ER Studio

Data modeling tools

Education

Bachelor of Computer Applications

Tools

ERwin

ER Studio

Job description

Job 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.
• 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.

Must Have Technical/Functional Skills

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

Generic Managerial Skills, If any

• Strong business acumen with the ability to challenge assumptions and influence decisions.
• Ability to facilitate modeling workshops with business stakeholders and domain experts.
• Experience translating ambiguous business concepts into well-defined enterprise models.
• Proven ability to balance reusable, extensible architecture with practical implementation needs.
• Strong communication skills with the ability to influence technical and non-technical stakeholders.

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
• Salary Range: $120,000 - 150,000 a year

Qualifications

• BACHELOR OF COMPUTER APPLICATION