Data Modeler

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Position Overview:

The Data Modeler will be responsible for designing, developing, and maintaining enterprise data models that support business intelligence, analytics, reporting, and application development initiatives. The ideal candidate will have strong expertise in conceptual, logical, and physical data modeling, database design, data architecture, and data integration. This role involves translating business requirements into structured data models, improving data quality, and ensuring consistency, scalability, and performance across enterprise data environments.

Data Modeling Technologies & Technical Expertise:

Strong experience with conceptual, logical, and physical data modeling.

Hands-on experience with dimensional modeling, Star Schema, Snowflake Schema, and Data Vault modeling.

Proficiency in SQL, including complex queries, joins, CTEs, stored procedures, and query optimization.

Experience with relational databases such as Oracle, SQL Server, PostgreSQL, MySQL, or DB2.

Knowledge of cloud data platforms such as Snowflake, Amazon Redshift, Google BigQuery, and Azure Synapse Analytics.

Experience with data modeling tools such as ERwin Data Modeler, ER/Studio, SAP PowerDesigner, or Oracle SQL Developer Data Modeler.

Strong understanding of data warehousing, data lakes, data marts, and enterprise data architecture.

Experience with ETL/ELT processes and data integration tools such as Informatica, Talend, or dbt.

Knowledge of dimensional modeling concepts, facts, dimensions, surrogate keys, and slowly changing dimensions (SCD).

Experience with metadata management, data lineage, data dictionaries, and business glossaries.

Understanding of data governance, master data management (MDM), and data quality frameworks.

Familiarity with Python or other scripting languages for data validation and automation.

Knowledge of cloud-based data architecture and distributed data processing is preferred.

Key Data Modeling 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.

Experience & Professional Competencies:

6+ years of experience in Data Modeling, Data Architecture, Database Design, or related roles.

4+ years of hands-on experience developing logical and physical data models.

Strong understanding of relational database design and normalization techniques.

Practical experience with dimensional modeling, Star Schema, Snowflake Schema, and Data Vault.

Experience with enterprise data warehouses and cloud-based data platforms.

Strong SQL skills and understanding of database performance optimization.

Experience with data modeling tools such as ERwin, ER/Studio, or similar platforms.

Knowledge of ETL/ELT processes, data integration, and data governance.

Ability to interpret complex business requirements and convert them into scalable data structures.

Strong analytical, documentation, communication, and problem-solving skills.

Experience working with Agile teams and cross-functional technical stakeholders.

Academic Qualifications & Preferred Certifications:

Bachelor's degree in Computer Science, Information Technology, Data Engineering, Database Management, or a related field.

Master's degree in Data Science, Data Architecture, or Information Systems is preferred.

Relevant certifications in data modeling, database design, Snowflake, AWS, Microsoft Azure, or data architecture are an advantage.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.