Senior Data Modeler for Enterprise Data & Warehousing

Zuven technologies Inc; Torrance (CA); On-site; USD 140,000 - 170,000; Full time

Job summary

Zuven Technologies Inc. in Torrance, CA seeks an experienced Data Modeler to design scalable enterprise data models for data platforms.

Collaborate with business stakeholders, data architects, engineering and application teams to translate requirements into conceptual, logical and physical data models. You will develop and maintain data models, enforce naming standards, maintain data dictionaries, and support data integration across sources.

Qualifications

• Hands-on experience with conceptual, logical, and physical data modeling.
• Strong understanding of relational and dimensional modeling including star and snowflake schemas.
• Knowledge of database concepts, SQL, normalization/denormalization, keys and constraints.
• Experience with data warehousing, ETL/ELT, data integration and analytics ecosystems.
• Familiarity with metadata management, data lineage and governance concepts.
• Excellent communication and stakeholder management skills.

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 requirements into 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.
• Collaborate with Data Architects, Data Engineers, ETL teams, BI teams and application teams.
• Support data integration initiatives across multiple source and target systems.
• Identify data quality issues and recommend solutions; participate in design reviews.
• Support model versioning, change management and documentation throughout projects.
• Communicate design decisions, dependencies, risks and issues to stakeholders.

Skills

Enterprise data modeling

Conceptual/logical/physical modeling

Relational and dimensional modeling

Star and Snowflake schemas

Data warehousing ETL/ELT

Metadata management and data治理

Analytical and problem solving

Communication and stakeholder管理

Requirement discussions and designWalk

Tools

ERWIN

GCP BigQuery

Microsoft Fabric

MS SQL Server

Redshift

Job description

Zuven Technologies Inc. in Torrance, CA seeks an experienced Data Modeler to design scalable enterprise data models for data platforms.

Collaborate with business stakeholders, data architects, engineering and application teams to translate requirements into conceptual, logical and physical data models. You will develop and maintain data models, enforce naming standards, maintain data dictionaries, and support data integration across sources.