Senior Data Modeler - Enterprise Data Modeling & Analytics

SOMERSET STAFFING; Torrance (CA); On-site; USD 120,000 - 190,000; Full time

Job summary

SOMERSET STAFFING seeks an experienced Data Modeler to design scalable, business-aligned data models for enterprise data platforms in Torrance, CA. You will work with business stakeholders, data architects, engineering, and application teams to translate requirements into conceptual, logical, and physical models.

You will maintain data dictionaries and standards, perform source-to-target mapping, and ensure models meet governance and enterprise architecture guidelines.

Qualifications

• Hands-on experience with conceptual, logical, and physical data modeling.
• Strong understanding of relational and dimensional modeling (Star/Snowflake).
• Proficiency in SQL, normalization, denormalization, keys, and constraints.
• Experience with data warehousing, ETL/ELT, data integration, and analytics ecosystems.
• Knowledge of metadata management, data lineage, and governance concepts.

Responsibilities

• Work directly with onshore business and technology stakeholders to understand data requirements and business processes.
• Develop and maintain Conceptual, Logical, and Physical Data Models.
• Translate business requirements into appropriate entities, attributes, relationships, hierarchies, and data structures.
• Design normalized and dimensional data models based on analytical and operational requirements.
• Define and maintain data dictionaries, metadata naming standards, and modeling documentation.
• Perform data analysis, source-to-target mapping and impact analysis for new requirements and enhancements.
• Collaborate with Data Architects, Data Engineers, ETL teams, BI teams, and application teams.

Skills

Data modeling

SQL concepts

Communication

Stakeholder management

Analytical thinking

Tools

ERwin

ERStudio

PowerDesigner

MS SQL Server

Redshift

BigQuery

Snowflake

Job description

SOMERSET STAFFING seeks an experienced Data Modeler to design scalable, business-aligned data models for enterprise data platforms in Torrance, CA. You will work with business stakeholders, data architects, engineering, and application teams to translate requirements into conceptual, logical, and physical models.

You will maintain data dictionaries and standards, perform source-to-target mapping, and ensure models meet governance and enterprise architecture guidelines.