ZipRecruiter

Log In

1

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

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 ... BI platform.Implement data quality checks and validation rules to ensure data accuracy and ...

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 ... BI platform.Implement data quality checks and validation rules to ensure data accuracy and ...

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 ... BI platform.Implement data quality checks and validation rules to ensure data accuracy and ...

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 ... BI platform.Implement data quality checks and validation rules to ensure data accuracy and ...

New

blueStone

Sr. Data Analyst

Chicago, IL · Remote

$88K - $111K/yr

... BI environments such as Business Objects or Informatica; data warehouse architecture and design experience, data modeling as well as a strong understanding of star schema and snowflake schemas; an ...

Tempus

Senior Data Modeler

Chicago, IL · On-site

$120K - $170K/yr

Manage an enterprise data model in collaboration with clinicians, data scientists, engineers ... You have knowledge of ETL/ELT and BI architectures, concepts and frameworks, and experience ...

Tempus

Senior Data Modeler

Chicago, IL · On-site

$120K - $170K/yr

Manage an enterprise data model in collaboration with clinicians, data scientists, engineers ... You have knowledge of ETL/ELT and BI architectures, concepts and frameworks, and experience ...

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 ... for BI consumption. * Experience designing and operating data products with clear ownership ...

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 ... for BI consumption. * Experience designing and operating data products with clear ownership ...

Roadrunner

Data Engineer

Downers Grove, IL · On-site

$114K - $137K/yr

Create and support Power BI datasets, reports, and dashboards, connecting to SSAS models or direct data sources for interactive visualizations. * Collaborate with stakeholders to gather requirements ...

Roadrunner

Data Engineer

Downers Grove, IL · On-site

$114K - $137K/yr

Create and support Power BI datasets, reports, and dashboards, connecting to SSAS models or direct data sources for interactive visualizations. * Collaborate with stakeholders to gather requirements ...

Roadrunner

Data Engineer

Downers Grove, IL · On-site

$114K - $137K/yr

Create and support Power BI datasets, reports, and dashboards, connecting to SSAS models or direct data sources for interactive visualizations. * Collaborate with stakeholders to gather requirements ...

Roadrunner

Data Engineer

Downers Grove, IL · On-site

$114K - $137K/yr

Create and support Power BI datasets, reports, and dashboards, connecting to SSAS models or direct data sources for interactive visualizations. * Collaborate with stakeholders to gather requirements ...

next page

Showing results 1-20

All JobsBi Data Modeler JobsBi Data Modeler Jobs in Chicago, IL

Bi Data Modeler information

See Chicago, IL salary details

$55

$63

$66

How much do bi data modeler jobs pay per hour?

As of Aug 22, 2026, the average hourly pay for bi data modeler in Chicago, IL is $63.56, according to ZipRecruiter salary data. Most workers in this role earn between $62.16 and $65.62 per hour, depending on experience, location, and employer.

What is a BI data modeler?

BI Data Modelers are professionals who design, implement, and manage data models to support business intelligence (BI) solutions. They translate business requirements into data structures, ensuring that data is organized, accessible, and optimized for reporting and analytics. BI Data Modelers work closely with stakeholders to understand data needs, create logical and physical data models, and maintain data integrity within BI systems. Their work enables organizations to make data-driven decisions by providing a solid foundation for business analysis and reporting.

How does a BI data modeler typically collaborate with business analysts and IT teams during a project?

A BI Data Modeler works closely with business analysts to understand data requirements and translate business needs into effective data models. During projects, they also coordinate with IT teams to ensure proper data integration, database performance, and adherence to security standards. Regular meetings and workshops are common to align stakeholders, clarify requirements, and address challenges in data structure or reporting. This collaborative approach ensures that the final data models support both technical feasibility and business goals.

What are the key skills and qualifications needed to thrive as a BI data modeler, and why are they important?

To thrive as a BI Data Modeler, you need strong expertise in data modeling concepts, SQL, and database management, often supported by a degree in computer science or a related field. Proficiency with BI tools like Power BI, Tableau, and data modeling software such as ERwin or Microsoft Visio is typically required. Analytical thinking, attention to detail, and effective communication are crucial soft skills for collaborating with stakeholders and translating business requirements into technical solutions. These skills ensure the creation of accurate, scalable data models that support insightful business analytics and data-driven decision-making.

What is the difference between Bi Data Modeler vs Data Analyst?

AspectBi Data ModelerData Analyst
CredentialsBachelor's in Data Science, Computer Science, or related field; certifications in data modeling or BI toolsBachelor's in Statistics, Mathematics, or related field; certifications in data analysis or visualization tools
Work EnvironmentDesigns data models for BI systems, collaborates with data engineers and BI teamsAnalyzes data sets, creates reports, and visualizations for business insights
Industry UsageCommon in organizations with BI and data warehousing needsWidely used across industries for decision support and reporting

The Bi Data Modeler focuses on designing data structures for BI systems, ensuring data is organized for analysis. In contrast, a Data Analyst interprets data to generate reports and insights. Both roles require strong analytical skills but differ in their primary responsibilities and focus areas.

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

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

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

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

Bi Data Modeler jobs near you
Infographic showing various Bi 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 $132,201 per year, or $63.6 per hour.

Data Modeler

1872 Consulting

Chicago, IL • Hybrid

$56.50 - $73.25/hr

Full-time

Posted 3 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