Padmi

Lead Data Modeler

United StatesPosted 2 months ago
Infrastructure And DatabasesSenior
Apply at Tata Consultancy Services

Opens the source posting on ibegin.tcsapps.com

Source description

About the role

View original

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

</div

Role: Modeller

Desired skills: Data Modeling

Qualifications: BACHELOR OF COMPUTER APPLICATION

  • Experience: 10 - 15 Years

  • Job function: TECHNOLOGY

  • Location: Malvern, PA

Salary range: $120,000–$150,000

Apply by: 2026-09-29 00:00:00

One address, no account. We’ll tell you when matching roles go live.

More at Tata Consultancy Services

Related open roles

View all roles