Must Have Technical/Functional Skills We are seeking an experienced Data Modeler to design and implement high-quality analytical data models that support enterprise reporting, analytics, and data science use cases. The ideal candidate will have hands-on expertise in Silver and Gold layer modeling, dimensional data warehouse design, and Python automation to streamline data modeling, validation, and documentation processes.

Roles & Responsibilities
• Experience with database modeling tools such as LucidChart"
• Experience with standard data models such as S-95
• Design and develop Silver and Gold layer data models following medallion architecture principles.
• Create and maintain dimensional models (Star and Snowflake schemas) for enterprise data warehouses.
• Define fact and dimension tables aligned with business KPIs and analytical requirements.
• Apply best practices for slowly changing dimensions (SCDs) and historical data tracking.
• Lead end-to-end data warehouse design and modeling initiatives.
• Translate business requirements into scalable, performant data models.
• Optimize models for query performance, usability, and extensibility.
• Partner with data engineers to ensure accurate implementation of models.
• Develop Python-based automation for data model validation, reconciliation and documentation.
• Automate metadata extraction, schema comparison, and impact analysis.
• Support automated testing of data models and transformations.
• Build reusable Python utilities to improve modeling efficiency.
• Collaborate with data engineers, analysts and architects.
• Participate in design reviews and ensure alignment with enterprise data standards.
• Support data governance initiatives including data definitions, lineage, and documentation.
• Ensure consistency in naming conventions, data types, and modeling standards.

Salary Range $120,000-$130,000 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 & amp; Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SP1