Senior Fabric OneLake Data Modeler

Tata Consultancy Services; Los Angeles (CA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Time Off: Vacation & Holidays

401K Plan & Financial Benefits

Job summary

Tata Consultancy Services in Los Angeles, CA seeks an experienced Data Modeler to design and maintain enterprise data models and semantic models. You will drive standardization, facilitate workshops, and mentor engineers across domains to enable self-service analytics and governed reporting platforms.

Responsibilities include defining facts and dimensions, aligning with enterprise standards, and reviewing designs before development to ensure scalable analytics across the organization.

Qualifications

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

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.

Skills

Enterprise data modeling

Analytical data warehouses design

SQL expertise

Dimensional modeling

Master data management

Power BI support

PK/FK design

Data modeling workshops

Documentation using modeling tools

Mentoring Data Engineers

Tools

Lucidchart

ERwin

ER/Studio

Microsoft Fabric

OneLake

Job description

• 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 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.
• 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
• Model Documentation and Governance
• Microsoft Fabric and OneLake Objects Governed

Job Description

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

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.