Senior Fabric OneLake Data Modeler

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

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.