ZipRecruiter

Log In

1

Senior Data Modeler Jobs in Chicago, IL (NOW HIRING)

1872 Consulting

Senior Data Modeler

Chicago, IL · Hybrid

Senior Data Modeler - Erwin & Azure FocusHybrid Onsite - 3-4 days work from home, 1-2 days onsiteThis role is responsible for data modeling using Erwin in an Azure environment, working with Azure ...

New

1872 Consulting

Senior Data Modeler

Chicago, IL · Hybrid

Senior Data Modeler - Erwin & Azure FocusHybrid Onsite - 3-4 days work from home, 1-2 days onsiteThis role is responsible for data modeling using Erwin in an Azure environment, working with Azure ...

New

Tempus

Senior Data Modeler

Chicago, IL

$120K - $170K/yr

Manage an enterprise data model in collaboration with clinicians, data scientists, engineers, product managers, and operators to integrate clinical data from source systems in multiple complex ...

Tempus

Senior Data Modeler

Chicago, IL · On-site

$120K - $170K/yr

Manage an enterprise data model in collaboration with clinicians, data scientists, engineers, product managers, and operators to integrate clinical data from source systems in multiple complex ...

1872 Consulting

Data Modeler

Chicago, IL · Hybrid

$56.50 - $73.25/hr

Senior Data Modeler - Erwin & Azure FocusHybrid Onsite - 3-4 days work from home, 1-2 days onsiteThis role is responsible for data modeling using Erwin in an Azure environment, working with Azure ...

New

1872 Consulting

Data Modeler

Chicago, IL · Hybrid

$56.50 - $73.25/hr

Senior Data Modeler - Erwin & Azure FocusHybrid Onsite - 3-4 days work from home, 1-2 days onsiteThis role is responsible for data modeling using Erwin in an Azure environment, working with Azure ...

New

blueStone

Sr. Data Analyst

Chicago, IL · Remote

$88K - $111K/yr

The Sr. Data Warehouse /Business Analyst will serve as a leader for Business Intelligence and work ... Data modeler/analyst must have good experience in rational database systems and architecture.

TIAA

Sales Distribution Data Modeler

Chicago, IL · On-site

$56.50 - $73.25/hr

Develops and maintains dimensional models, star and snowflake schemas, data vault structures, and ... including senior leadership and cross-functional business partners. * Provides guidance and ...

TIAA

Sales Distribution Data Modeler

Chicago, IL · On-site

$56.50 - $73.25/hr

Develops and maintains dimensional models, star and snowflake schemas, data vault structures, and ... including senior leadership and cross-functional business partners. * Provides guidance and ...

Caterpillar

Senior Data Specialist

Chicago, IL · On-site

$160K - $169K/yr

Document data models for domains to be deployed including a logical data model, candidate source ... Senior Data Specialist / Reference R0000385140 #LI-DNI] . Visa Sponsorship is not available for ...

hightower

Senior Data Architect

Chicago, IL · On-site +1

$150K - $175K/yr

Your Future Team As a Senior Data Architect, you will design and evolve Hightower's enterprise data ... Enterprise Data Architecture & Modeling * Lead development of conceptual, logical, and physical ...

UL Standards and Engagement

Senior Data Engineer

Evanston, IL · On-site

$101K - $138K/yr

The Senior Data Engineer will design, develop, and scale enterprise data infrastructure that ... Architect and implement robust data models, metadata frameworks, and data quality controls that ...

AArete

Senior Data Scientist

Chicago, IL

Senior Data Scientist AArete is one-of-a-kind when it comes to consulting firm culture. We're a ... Develop custom AI/ML models and algorithms to apply to data sets * Develop processes and tools to ...

next page

Showing results 1-20

All JobsData Modeler JobsSenior Data Modeler JobsSenior Data Modeler Jobs in Chicago, IL

Senior Data Modeler information

See Chicago, IL salary details

$36

$69

$87

How much do senior data modeler jobs pay per hour?

As of Aug 21, 2026, the average hourly pay for senior data modeler in Chicago, IL is $69.70, according to ZipRecruiter salary data. Most workers in this role earn between $61.73 and $79.04 per hour, depending on experience, location, and employer.

What does a senior data modeler do?

A Senior Data Modeler is responsible for designing, implementing, and managing data models that define how data is stored, organized, and accessed within an organization. They work closely with stakeholders to understand business requirements and translate them into efficient data structures, often using tools like ER diagrams and database modeling software. Senior Data Modelers ensure data integrity, optimize data flows, and support data governance initiatives. They may also mentor junior data modelers and collaborate with database administrators, data architects, and developers to deliver effective data solutions.

What are the key skills and qualifications needed to thrive as a senior data modeler?

To thrive as a Senior Data Modeler, you need deep expertise in database design, data modeling techniques, and strong proficiency in SQL, often supported by a degree in computer science or a related field. Familiarity with data modeling tools such as ERwin, IBM InfoSphere Data Architect, or Microsoft Visio, and knowledge of database systems like Oracle or SQL Server, are typically required. Excellent analytical thinking, attention to detail, and strong collaboration and communication skills help you work effectively with cross-functional teams. These competencies ensure accurate, scalable, and efficient data structures that support business intelligence and decision-making across the organization.

How does a senior data modeler typically collaborate with other departments during large-scale projects?

A Senior Data Modeler often works closely with business analysts, data architects, and software engineers to ensure that data models align with both technical requirements and business objectives. Collaboration typically involves gathering requirements, translating business needs into data structures, and participating in design reviews. Senior Data Modelers also play a key role in facilitating communication between IT and non-technical stakeholders to ensure data integrity and usability across systems. Effective teamwork and clear documentation are essential to navigate the complexities of large-scale data initiatives.

What is the difference between Senior Data Modeler vs Data Architect?

AspectSenior Data ModelerData Architect
Required CredentialsBachelor's or Master's in Computer Science, Data Management, or related field; certifications like CDMPBachelor's or Master's in Computer Science, Information Systems; certifications like TOGAF, CDMP
Work EnvironmentData teams, database development, data analysis projectsIT departments, enterprise data strategy, system design
Employer & Industry UsageFinance, healthcare, tech companies focusing on data modelingLarge enterprises, consulting firms, organizations with complex data infrastructure
Common Search & ComparisonOften compared for technical data modeling skillsBroader scope including data infrastructure and architecture planning

While both roles require strong data management skills and similar certifications, Senior Data Modelers focus primarily on designing and optimizing data models, whereas Data Architects develop comprehensive data strategies and oversee overall data infrastructure. The roles often collaborate but differ in scope and responsibilities.

What are the most commonly searched types of Data Modeler jobs in Chicago, IL?

The most popular types of Data Modeler jobs in Chicago, IL are:

What are popular job titles related to Senior Data Modeler jobs in Chicago, IL?

For Senior Data Modeler jobs in Chicago, IL, the most frequently searched job titles are:

What job categories do people searching Senior Data Modeler jobs in Chicago, IL look for?

The top searched job categories for Senior Data Modeler jobs in Chicago, IL are:

What cities near Chicago, IL are hiring for Senior Data Modeler jobs?

Cities near Chicago, IL with the most Senior Data Modeler job openings:

Senior Data Modeler jobs near you
Infographic showing various Senior Data Modeler job openings in Chicago, IL as of August 2026, with employment types broken down into 1% As Needed, 84% Full Time, 12% Part Time, and 3% Contract. Highlights an 86% Physical, 4% Hybrid, and 10% Remote job distribution, with an average salary of $144,974 per year, or $69.7 per hour.

Senior Data Modeler

1872 Consulting

Chicago, IL • Hybrid

Full-time

Posted 2 days ago

New

Job description

Senior Data Modeler – Erwin & Azure FocusHybrid Onsite – 3-4 days work from home, 1-2 days onsiteThis role is responsible for data modeling using Erwin in an Azure environment, working with Azure Data Factory (ADF) on a regular basis. You will be working with large enterprise data sets, and working closely with business analysts, data engineers, and other stakeholders to design/optimize data structures and flows that facilitate efficient data analysis and reporting.What You'll Be DoingWork with business resources to identify business needs then design and develop conceptual, logical, and physical data models for the needs and support data analysis and reporting.Define and create ETL processes for data extraction, transformation, and loading into the data warehouse or BI platform.Implement data quality checks and validation rules to ensure data accuracy and consistency.Continuously monitor and optimize data models with Erwin and database performance for efficient data retrieval and reporting.Maintain comprehensive documentation of data models, schemas, and related processes.Apply knowledge of the data in our ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.Implement data security measures and access controls to protect sensitive data.Ensure compliance with data governance and data management best practices.Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, trouble shooting and analysis.Identify and execute on new process improvement opportunities.Work in a highly agile development environment.Develop a strong understanding of the business and its systems to support the company's strategic objectives.Maintain up-to-date awareness of current and future directions of business industry and associated technologies.Skills We're Seeking5+ years of experience with Data ModelingMust have strong Erwin experience to create and manage Logical/physical data models Also experience modeling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row / object level security designsExperience working in Azure environments, and must have experience with Azure Data Factory (more the better)Must have strong SQL experienceNice To HavesExperience with Azure Synapse Data MartsT-SQL experienceETL experience, ideally using Talend or ADFPower BI experience (but not looking for a Power BI Developer)

1872 Consulting logo

About 1872 Consulting

Sourced by ZipRecruiter

1872 Consulting, based in Chicago, IL, USA, operates within the IT consulting industry. Armed with a diverse team of experts, the company offers specialized IT consulting services, focusing on modernizing business technologies and driving innovative business strategies. Established in 1872, the company has a rich history marked by its commitment to bridging the gap between businesses and technology. Its mission is to empower organizations to surpass their business goals by providing state-of-the-art IT solutions and service. The company prides itself on its core values of integrity, excellence, and innovation, instilling these principles in every project they undertake.

Industry

It services

Company size

11 - 50 Employees

Headquarters location

Chicago, IL, US

Year founded

2014

View All 1872 Consulting Jobs

Apply