Data Modeler
Quick facts
- Pay
- $88/hr C2C
- Type
- Full-time
- Location
- New York, NY
- Background
- Master's degree
- Experience
- 6+ years
- Skills
- Python, SQL, AWS, Machine Learning
- Industry
- Information Technology — 1359 open jobs
- Visa in listing
- H-1B, OPT
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
Job description
- Home
- About
- Adaptive AI
- Industries
- Consulting
- Jobs Portal
- Contact Us
- Home
- About
- Adaptive AI
- Industries
- Consulting
- Jobs Portal
- Contact Us
Job Overview
- 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
View All Jobs
Similar Jobs
- SAP Data Lead - Frisco, TX
- AWS Data Engineer - Exton, PA
- Senior Data Analyst - Little Rock, AR
- Data Engineer - Sunnyvale, CA
- Senior ETL Developer / Senior Data Engineer (Azure & SQL) - Brecksville, OH
Location: New York, NY
Duration: 12 Months + Extension
Bill Rate: $88/hr C2C
Job Type: W-2, 1099, C2C
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.
- 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.
- 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.
- 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.
Apply Now
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.
- Home
|
- About
|
- Adaptive AI
|
- Industries
|
- Consulting
|
- Contact Us
© 2004-2026, Machine Learning Technologies LLC, or its affiliates
Visa sponsorship record: Machine Learning Technologies LLC
Sponsors actively| Fiscal year | H-1B LCAs | USCIS approvals | USCIS denials | PERM |
|---|---|---|---|---|
| FY2026 | — | 7 | 0 | — |
| FY2025 | 20 | 1 | 0 | — |
| FY2024 | 20 | 4 | 0 | — |
Roles they sponsor most
- business analyst4 LCAs · median $71k
- java developer3 LCAs · median $85k
- accounts manager2 LCAs · median $60k
- application developer2 LCAs · median $115k
- cognitive implementation engineer2 LCAs · median $82k
Full sponsorship history of Machine Learning Technologies LLC →
Which visas can work for this job
- Mentioned in the listing
H-1B, OPT
- H-1B cap-exempt employer
Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).
- O-1 (extraordinary ability)
For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.
Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.