Senior Fabric OneLake Data Modeler

Position Summary

The Senior Fabric OneLake Data Modeler is responsible for designing, governing, and evolving the enterprise analytical data model within Microsoft Fabric OneLake. This role support the owners of business data structures, master data, metrics, hierarchies, dimensions, relationships, and analytical data products used across reporting, self-service analytics, AI solutions, Fabric Data Agents, and governed IT applications.

The position ensures that all enterprise data assets adhere to Medallion Architecture principles while aligning with the foundational concepts of the Corporate Information Factory (CIF). The role is accountable for establishing a scalable, governed, reusable enterprise information model that provides a single version of the truth across the organization.

The Senior Fabric OneLake Data Modeler partners closely with business stakeholders, architects, integration engineers, data engineers, analytics teams, and governance teams to ensure data consistency, reusability, transparency, and trust.

Key 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

The role ensures alignment between Corporate Information Factory principles and Fabric Medallion Architecture.

Bronze Layer:

• Raw source-aligned data
• CDC and ingestion structures
• API landing zones
• Event streams
• Audit and traceability data

Silver Layer (Single Version of the Truth):

• Enterprise fact tables
• Conformed dimensions
• Master data entities
• Standardized metrics and KPIs
• Historical integrated data
• Business transformations
• Approved business logic

The Silver Layer serves as the authoritative enterprise source of truth.

Gold Layer:

• Performance-optimized analytical structures
• Aggregated datasets
• Executive reporting datasets
• Power BI optimized models
• AI optimized datasets

No additional business logic, KPI calculations, or filtering rules may be introduced within Gold beyond what has been approved and governed within Silver.

Enterprise Data Domains

The role designs and governs enterprise models supporting:

Transaction Domains (examples):

• Sales Depletions (actuals and forecasts)
• Shipments
• Trade spend and accruals
• Retail POS
• E-Commerce Transactions
• Paid Media
• Earned Media
• Consumer Engagement
• CRM Activities

Master Data Domains (examples):

• Product Master
• Customer Master
• Retailer Master
• Bottler Master
• Geography Master
• Organization Master
• Campaign Master
• Digital Asset Master
• Calendar and Fiscal Calendar

Enterprise Data Modeling Standards

The Senior Fabric OneLake Data Modeler owns enterprise standards for:

• Fact table design
• Dimension modeling
• Conformed dimensions
• Slowly changing dimensions
• Data Vault integration patterns
• Star schemas
• Snowflake schemas
• Semantic model optimization
• Data lineage and traceability

The role ensures consistent implementation of:

• Business keys
• Surrogate keys
• Alternate keys
• Composite keys
• Primary keys
• Foreign keys

The role establishes and governs enterprise grain definitions, relationship standards, cardinality rules, and referential integrity requirements.

Model Documentation and Governance

The role is responsible for documenting all enterprise models using tools such as Lucidchart and approved enterprise repositories.

Documentation responsibilities include:

• Conceptual Data Models (CDM)
• Logical Data Models (LDM)
• Physical Data Models (PDM)
• Entity Relationship Diagrams (ERD)
• Business Glossaries
• Data Dictionaries
• KPI Catalogs
• Source-to-Target Mapping
• Data Lineage Diagrams
• Transformation Documentation

Documentation standards must clearly identify:

• Primary Keys
• Foreign Keys
• Surrogate Keys
• Business Keys
• Relationship Cardinality
• Data Ownership
• Metric Definitions
• Hierarchies
• Source System Dependencies

The objective is to create transparency, consistency, reusability, and governance across all enterprise data products.

Microsoft Fabric and OneLake Objects Governed

• OneLake Domains
• Lakehouses
• Warehouses
• Shortcuts
• Data Products
• Enterprise Fact Tables
• Enterprise Dimensions
• Master Data Objects
• Reference Data Objects
• KPI Frameworks
• Gold Layer Aggregates
• Power BI Semantic Models
• Fabric Data Agents
• AI Consumption Models

Leadership Responsibilities

• Support the team leading enterprise data modeling initiatives.
• Establish enterprise modeling standards.
• Conduct model reviews and design governance sessions.
• Resolve conflicting business definitions and KPI calculations.
• Facilitate alignment across business functions.
• Drive adoption of enterprise data standards.
• Promote reusable enterprise data products and self-service analytics.

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

Preferred Qualifications

• Experience with Snowflake.
• Experience with Salesforce.
• Experience with retailer and distributor data ecosystems.
• Experience with digital media and consumer engagement platforms.
• Experience supporting AI and data agent initiatives.

Success Measures

• Silver Layer trusted as the enterprise single version of the truth.
• Consistent enterprise KPI definitions across all domains.
• Reusable conformed dimensions adopted across projects.
• Reduced development rework through approved model designs.
• High-quality documentation and lineage.
• Consistent PK/FK implementation.
• Increased self-service analytics adoption.
• Improved AI and Fabric Data Agent consumption.
• Accelerated delivery of governed enterprise data products.

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.