Data Modeler

Pasadena, CA, us on site Until 8/22/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 2026
Job description

Tech Tammina LLC

Relevant Experience (in Yrs): 10+ Years

Bachelor's degree in Information Management, Computer Science, or related field 

Minimum 5 years of experience in data/information modeling 

Strong logical and physical data modeling skills. Should have expert knowledge of conceptual, logical and physical data models including 3rd Normal Form and dimensional data modeling. Physical should include a good understanding of database views, indexing, table and index partitioning. 

Experience with implementation of physical data models in a Big Data / Hadoop data warehouse environment 

Excellent communication skills, both written and oral 

Ability to understand business requirements 

Use of ERwin data modeling tool 

Ability to write SQL queries 

Data warehouse architecture concepts 

Ability to create and understand process and data flows 

Previous experience in the healthcare industry, particularly in Healthcare Sales and Marketing 

Working knowledge of Oracle RDBMS and SQL Server 

Familiarity with ETL/ELT technologies 

SQL tuning techniques

Job Status: Full Time 

Eligiblity: GC or US Citizens

Share the Profiles to mkonni(at)1stitsolutions.com

Contact: 703-349-1214

Keep the subject line with Job Title and Location

About this role

Summary

Designs and implements data models for data warehouses, especially in healthcare and big data environments.

Job title

Data Modeler

Experience level

10+ years

Industry

software

Location requirements

Pasadena, CA, US; on-site; no remote work

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

data modelingSQLERwindatabase viewsindexingpartitioningbig dataHadoopETL/ELTOracle RDBMSSQL Server

Preferred skills

healthcarehealthcare sales and marketingdata warehouse architectureprocess and data flowsSQL tuning

Specializations

data modelingbig datahealthcareSQLETL
Locations

Structured locations inferred from the posting.

Pasadena, CA, USA

On-site City