More jobs:
Data Modeler
Job in
Norwell, Plymouth County, Massachusetts, 02061, USA
Listed on 2026-02-14
Listing for:
Tata Consultancy Services
Full Time
position Listed on 2026-02-14
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst
Job Description & How to Apply Below
Overview
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.
Responsibilities- Experience with database modeling tools such as Lucid Chart
- 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 & Training Reimbursement. - Time Off:
Vacation, Time Off, Sick Leave & Holidays. - Legal & Financial Assistance:
Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
- BACHELOR OF COMPUTER SCIENCE
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×