Senior Data Modeler - Cloud Data Architecture & DWH

Quantum Technologies. LLC; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Quantum Technologies. LLC seeks a skilled Data Modeler to design and maintain enterprise data models for BI, analytics, and reporting initiatives in a fast-paced environment.

The role translates business requirements into dimensional models (Star, Snowflake, Data Vault), optimizes SQL, and collaborates with architects, engineers, and analysts to ensure scalable, high-quality data architecture.

Qualifications

• Design and maintain conceptual, logical, and physical data models based on business and technical requirements.
• Develop ERDs, data dictionaries, and database design documentation.
• Create dimensional models using Star Schema, Snowflake Schema, and Data Vault methodologies.

Responsibilities

• Design and maintain conceptual, logical, and physical data models based on business and technical requirements.
• Analyze business requirements and translate them into effective database structures and data models.
• Develop entity relationship diagrams (ERDs), data dictionaries, and database design documentation.
• Create dimensional models using Star Schema, Snowflake Schema, and Data Vault methodologies.
• Define entities, attributes, relationships, primary keys, foreign keys, and data constraints.
• Collaborate with data architects, data engineers, business analysts, and application developers.
• Optimize data models to improve database performance, scalability, and storage efficiency.
• Support the development of enterprise data warehouses, data marts, and analytical platforms.
• Review existing database structures and recommend improvements to data architecture.
• Establish data standards, naming conventions, metadata definitions, and modeling best practices.
• Ensure data consistency, integrity, accuracy, and compliance with governance policies.
• Support ETL/ELT development teams with source-to-target mapping and data transformation requirements.
• Perform data model reviews, impact analysis, and documentation updates.
• Identify data quality issues and recommend appropriate modeling and structural improvements.

Skills

Data modeling

Dimensional modeling

Star Schema

Snowflake Schema

Data Vault

SQL

ETL/ELT

Data governance

Python (scripting)

Cloud platforms

Education

Bachelor's degree in CS/IT/Data Engineering

Master's degree in Data Science/Architecture (preferred)

Certifications in Snowflake/AWS/Azure (advantage)

Tools

ERwin Data Modeler

ER/Studio

SAP PowerDesigner

Oracle SQL Developer Data Modeler

Job description

Quantum Technologies. LLC seeks a skilled Data Modeler to design and maintain enterprise data models for BI, analytics, and reporting initiatives in a fast-paced environment.

The role translates business requirements into dimensional models (Star, Snowflake, Data Vault), optimizes SQL, and collaborates with architects, engineers, and analysts to ensure scalable, high-quality data architecture.