Senior Data Modeler: Fabric/OneLake & Medallion Architect

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

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.