Source description
About the role
Must Have Technical/Functional Skills
8+ years of enterprise data modeling experience.
5+ years designing analytical data warehouses.
Experience with Microsoft Fabric and OneLake.
Experience implementing Medallion Architecture.
Experience with Corporate Information Factory methodologies.
Strong SQL expertise.
Experience with dimensional modeling techniques.
Experience designing enterprise semantic models.
Experience with master data management concepts.
Experience documenting enterprise models using Lucidchart, ERwin, ER/Studio, or equivalent platforms.
Strong understanding of PK/FK design and referential integrity.
Experience supporting Power BI and enterprise analytics environments.
Roles & Responsibilities
Design and maintain enterprise conceptual, logical, and physical data models.
Define enterprise facts, dimensions, hierarchies, metrics, relationships, and business entities.
Facilitate data modeling workshops and requirement discovery sessions.
Establish enterprise standards for data modeling, naming conventions, grain definition, and metadata management.
Create reusable canonical business models across all domains.
Review and approve data designs prior to development.
Partner with architects and engineering teams to ensure alignment with enterprise standards.
Coach Data Engineers and Junior Engineers on modeling best practices.
Support self-service analytics, AI solutions, semantic models, and governed reporting platforms.
Corporate Information Factory and Medallion Architecture Ownership
Enterprise Data Domains
Enterprise Data Modeling Standards
Model Documentation and Governance
Microsoft Fabric and OneLake Objects Governed
Salary Range-$120,000-$150,000 a year
#LI-KR3
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.
Role: Senior Data Scientist
Desired skills: Data Modeling
Experience: 6 - 8 Years
Job function: TECHNOLOGY
Location: Los Angeles, CA
Salary range: $120,000–$150,000
Apply by: 2026-09-26 00:00:00
More at Tata Consultancy Services