Data Modeler

MACHINE LEARNING TECHNOLOGIES LLC; New York (NY); On-site; USD 110,000 - 138,000; Full time

Job summary

Machine Learning Technologies LLC in New York, NY seeks a Data Modeler to design and maintain enterprise data models supporting BI, analytics, reporting, and application development in the insurance domain.

You will translate business requirements into structured data models, ensure data quality and governance, and collaborate with data architects, engineers, and analysts to optimize performance and scalability.

Qualifications

• 6+ years of experience in Data Modeling, Data Architecture, or related roles.
• Experience with logical, physical, and conceptual data models.
• Familiarity with data governance and metadata management.

Responsibilities

• Design and maintain conceptual, logical, and physical data models based on business requirements.
• Create ERDs, data dictionaries, and database design documentation.
• Develop dimensional models using Star Schema, Snowflake, and Data Vault methodologies.
• Collaborate with data architects, engineers, and analysts to optimize data structures.
• Support enterprise data warehouses and data marts with scalable data models.

Skills

Data Modeling

SQL

Dimensional Modeling

ETL/ELT

Python

Cloud Data Platforms

Education

Bachelor's degree in CS/IT/Data Engineering

Tools

ERwin

ER/Studio

PowerDesigner

Job description

Job Description

Job ID: J54653

Job Title: Data Modeler

Location: New York, NY

Duration: 12 Months + Extension

Domain Exposure: Insurance

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

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

Bill Rate: $88/hr C2C

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.

Equal Opportunity Employer

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.