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

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