Data Modeler

Valiant Technologies LLC; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Valiant Technologies LLC is seeking a Data Modeler to design, develop, and maintain enterprise data models supporting BI, analytics, and application development.

The role requires expertise in conceptual, logical, and physical modeling, dimensional modeling, and data governance, with strong SQL and experience across Oracle, SQL Server, and cloud platforms.

Qualifications

• 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.
• Practical experience with dimensional modeling (Star Schema, Snowflake Schema, Data Vault).
• Experience with data warehouses and cloud-based data platforms.
• Strong SQL skills and performance optimization.
• Experience with data governance.

Responsibilities

• Design conceptual, logical, and physical data models.
• Translate business requirements into effective database structures.
• Develop ERDs, data dictionaries, and design docs.
• Create dimensional models using Star Schema, Snowflake Schema, and Data Vault.
• Define entities, keys, descriptions, relationships, and constraints.
• Collaborate with data architects, engineers, analysts, and developers.
• Optimize models for performance and storage efficiency.
• Support data warehouses and data marts.
• Review existing structures and propose improvements to data architecture.
• Establish data standards and metadata definitions.

Skills

Data modeling

Data architecture

SQL proficiency

ETL/ELT knowledge

Data governance

Agile teamwork

Communication

Education

Bachelor's degree in CS/IT/Data-related

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

Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

Oracle SQL Developer Data Modeler

Informatica

Talend

dbt

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.