Senior Fabric OneLake Data Modeler

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