Senior Data Modeller for Data Warehouse & Analytics

Corevia Staffing; California (MO); Hybrid; USD 100,000 - 160,000; Full time

Job summary

Corevia Staffing is seeking an experienced Data Modeller to design, develop, and maintain enterprise data models that support BI, analytics, reporting, and operations.

The role translates business requirements into conceptual, logical, and physical models, ensuring data quality, governance, and scalable architectures. Collaboration with analysts, data engineers, solution architects, DBAs, and stakeholders is essential.

Qualifications

• Strong understanding of conceptual, logical, and physical data modelling.
• Strong knowledge of relational data modelling and ER modelling.
• Experience with dimensional data modelling.
• Experience designing Star and Snowflake schemas.
• Understanding of slowly changing dimensions (SCD), fact tables, dimension tables, and surrogate keys.

Responsibilities

• Strong SQL skills.
• Good knowledge of relational databases such as: PostgreSQL, Oracle, SQL Server, MySQL, Snowflake.
• Understanding of database performance, indexing, partitioning, and query optimization.
• Knowledge of database constraints and referential integrity.

Skills

Data modelling

SQL

Data warehousing

ETL/ELT

Cloud data platforms

Education

Bachelor's or Master’s degree in CS/IT/Data Management

Tools

Erwin Data Modeler

ER/Studio

SAP Power Designer

Oracle SQL Developer Data Modeler

Sparx Enterprise Architect

Lucidchart

Microsoft Visio

Job description

Corevia Staffing is seeking an experienced Data Modeller to design, develop, and maintain enterprise data models that support BI, analytics, reporting, and operations.

The role translates business requirements into conceptual, logical, and physical models, ensuring data quality, governance, and scalable architectures. Collaboration with analysts, data engineers, solution architects, DBAs, and stakeholders is essential.