Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.
Description: Job Title: Senior Data modeler
Work Location: ChicagoIL60604
Vendor Rate: ***
Contract duration: 6
Target Start Date: 05 Sep 2026
Does this position require Visa independent candidates only? Yes
**hybrid**Need to work from Chicago office weekly 3 days**
Job Details:
Detailed Job Description
Key Responsibilities
Data Modeling: Create conceptual, logical, and physical data models.
Cloud Architecture: Architecture data solutions specifically for cloud platforms.
Pipeline Design: Assist in designing ETL/ELT data integration workflows.
Optimization: Tune database performance, indexing, and storage costs.
Governance: Establish data standards, metadata registries, and security rules.
Required Technical Skills
Cloud Platforms: AWS (Redshift), Azure (Synapse), or Google Cloud (BigQuery).
Data Warehouses: Snowflake, Databricks, or cloud-native relational databases.
Modeling Tools: Erwin, ERwin, Hackolade, or DbSchema.
Methodologies: Kimball Data Warehousing, Data Vault 2.0, or Inmon.
Languages: Advanced SQL and scripting languages like Python.
Minimum years of experience
8-10 years
Certifications Needed :No
Top 3 responsibilities you would expect the Subcon to shoulder and execute
Data Modeling Architecture Architect cloudnative Snowflake data warehouses, implementing starsnowflake schemas and optimizing dimensional models.
Strong knowledge in data ingestion no ETL and data warehousing concepts
Hands on experience in Python preferred
Interview Process (Is face to face required?)
No
Any additional information you would like to share about the project specs/ nature of work
Custom Fields:
Name: Intake Call Completed
Value: false
Name: Intake Call Requested
Value: true
EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.