Data Modeller Job at Corevia Staffing, California

  • Corevia Staffing
  • California

Job Description

Title: Data Modeller

Work Location: SFO - Hybrid

Project Duration: 1 year, with possible extension

Role Overview

We are looking for an experienced Data Modeller to design, develop, and maintain enterprise data models that support business intelligence, analytics, reporting, and operational applications. The role involves translating business requirements into conceptual, logical, and physical data models while ensuring data quality, consistency, scalability, and governance.

The Data Modeller will work closely with Business Analysts, Data Engineers, Solution Architects, Database Administrators, and business stakeholders to create robust and scalable data architectures.

Key Responsibilities:

Data Modelling
  • Strong understanding of Conceptual, Logical, and Physical Data Modelling .
  • Strong knowledge of Relational Data Modelling and ER Modelling .
  • Experience with Dimensional Data Modelling .
  • Good understanding of normalization and denormalization techniques.
  • Experience designing Star and Snowflake schemas.
  • Understanding of slowly changing dimensions (SCD), fact tables, dimension tables, and surrogate keys.
Database & SQL
  • 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.
Data Warehousing & Cloud
  • Experience with data warehouse and data lake concepts.
  • Understanding of ETL/ELT processes and data integration.
  • Experience with one or more cloud data platforms such as:
    • AWS
    • Microsoft Azure
    • Google Cloud Platform
  • Exposure to platforms such as Snowflake, Databricks, Azure Synapse, BigQuery, or Amazon Redshift is desirable.
Data Modelling Tools

Experience with one or more of the following:

  • Erwin Data Modeler
  • ER/Studio
  • SAP Power Designer
  • Oracle SQL Developer Data Modeler
  • Sparx Enterprise Architect
  • Lucid chart
  • Microsoft Visio
Education & Experience
  • Bachelor's or master's degree in computer science, Information Technology, Data Management, or a related field.
  • 5 10 years of experience in data modelling, database design, data warehousing, or related roles.
  • Experience working on enterprise data platforms and large-scale data projects.
  • Experience working in Agile/Scrum environments is preferred.

Job Tags

Similar Jobs

Mangrum Career Solutions LLC

Family Medicine Physician Job at Mangrum Career Solutions LLC

 ...Family Medicine Physician Location: Long Island City / Queens, New York Job Type: Full-Time | Permanent | Direct Hire A dedicated community healthcare organization is seeking a full-time Family Medicine Physician to join its health center in Long Island... 

Sonepar

Emerging Professional (Step), Early Career Rotational Job at Sonepar

 ...Houston, TX Job type: Full time What Youll Do The Sonepar Training for Emerging Professionals Program (STEP) is a (12-Month ) dynamic, intensive rotational program designed to educate, train, and develop skills in emerging professionals and help establish your... 

Yakima Neighborhood Health Services

Medical Assistant Supervisor Job at Yakima Neighborhood Health Services

 ...high value benefits of employer provided medical, dental, vision, life, disability and...  ...Nurse License, and/or unencumbered Medical Assistant Certification or Registration through an...  ... Administer procedures as directed by supervisors and in accordance with Washington State... 

Ambassador Worldwide Protection Agency

Unarmed Security Guard Job at Ambassador Worldwide Protection Agency

 ...experienced and highly qualified individuals to join our team as Unarmed Security Officers in Memphis, TN metropolitan area. Ambassador...  ...of an active State of Tennessee Unarmed Security License (Guard Card) Must have a valid driver's license and clean driving... 

AECON

Directional Driller Job at AECON

 ...and supplies. Coordinate machine actions with other activities, positioning or moving of loads, and conduct in response to hand or audio signals from team members. Understand and analyze locate marks, stakes, and property markers. Ensure all reporting...