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.
