ZipRecruiter

Log In

1

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

Brown & Brown, Inc.

Senior Power BI Lead

Chicago, IL · On-site

Creates the foundation for a new Power BI department inside the AHI Data Strategy & BI team, including team structure, operating model, standards, intake, delivery, quality control, and support ...

Arrowhead Programs

Senior Power BI Lead

Chicago, IL · On-site

Creates the foundation for a new Power BI department inside the AHI Data Strategy & BI team, including team structure, operating model, standards, intake, delivery, quality control, and support ...

Core Specialty

Actuarial Data Analyst

Chicago, IL · Hybrid

$70K - $75K/yr

Experience with/or working knowledge of Lakehouse, Warehouse, Semantic models, Datamarts, SQL ... Python, PySpark, SQL, Dataflow gen 2, Pipelines, Apache Spark jobs, One Lake, Power BI, Data agents ...

Core Specialty

Actuarial Data Analyst

Chicago, IL · On-site

$70K - $75K/yr

Experience with/or working knowledge of Lakehouse, Warehouse, Semantic models, Datamarts, SQL ... Python, PySpark, SQL, Dataflow gen 2, Pipelines, Apache Spark jobs, One Lake, Power BI, Data agents ...

Primo Brands

Sr. Data Analyst

Northbrook, IL · On-site

$142K - $152K/yr

... statistical models or industry accepted tools. Provide automated data solutions, tools, and ... BI Data Analysis or Visualization Tools; * 5 years of experience in Microsoft Excel including ...

Primo Brands

Sr. Data Analyst

Northbrook, IL · Hybrid

$142K - $152K/yr

... statistical models or industry accepted tools. Provide automated data solutions, tools, and ... BI Data Analysis or Visualization Tools; * 5 years of experience in Microsoft Excel including ...

previous page

Showing results 41-60

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 10, 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 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.

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 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 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.
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, 83% Full Time, 12% Part Time, and 4% Contract. Highlights an 87% Physical, 4% Hybrid, and 9% Remote job distribution, with an average salary of $132,201 per year, or $63.6 per hour.

Senior Power BI Lead

Bridge Specialty Group

Chicago, IL • On-site

Full-time

Medical, Dental, Vision, Life, Retirement, PTO

Posted 14 days ago

Job description

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.

Arrowhead Intermediaries and its divisions-Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty are seeking a Senior Power BI Lead to join our growing team. This hybrid opportunity is ideally suited for candidates based in Atlanta, Chicago, Denver, or San Diego.

Arrowhead Intermediaries (AHI), the Specialty segment of Brown & Brown, is seeking a senior Power BI leader toestablishand scale a centralized Power BI function within the AHI Data Strategy & BI team. This role will serve three independently operated divisions and willbe responsible forsetting the enterprise standard for Power BI reporting, governance, security, semantic modeling, and report lifecycle management across AHI.

How You Will Contribute:

  • Creates the foundation for a new Power BI department inside the AHI Data Strategy & BI team, including team structure, operating model, standards, intake, delivery, quality control, and support practices.

  • Sets the standard for all AHI Data Strategy Power BI reporting across Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty, balancing divisional needs with enterprise consistency.

  • Ensurebusiness users receive correct, governed, and accessible information through certified datasets, standardized metrics, report governance, and disciplined release management.

  • Leads complex reporting scenarios involving unique row-level security requirements, different business models, varying levels of data maturity, and cross-division datasets that must be combined responsibly.

Skills & Experience to Be Successful:

Required:

  • 10+ years of business intelligence, analytics, data platform, or reporting experience, including 5+ years of advanced Power BI experience and 3+ years in a senior lead, architect, administrator, or BI platform ownership role.

  • Required insurance industry experience, preferably in property and casualty, specialty insurance, MGA/MGU, wholesale brokerage, retail agency, carrier, or insurance distribution environments.

  • Demonstrated experience building or maturing a BI team, reporting function, governance program, center of excellence, or enterprise analytics operating model.

  • Expert-level Power BI skills, including semantic modeling, DAX, Power Query, dataflows, deployment pipelines, workspace design, performance tuning, incremental refresh, composite models, report design, and tenant/capacity administration.

  • Strong understanding of Power BI governance, report certification, data cataloging, stewardship, metric standardization, security, lifecycle management, production support, and adoption practices.

  • Proven ability to design and implement complex row-level security models and access-control patterns across multiple business units, hierarchies, and user groups.

  • Advanced SQL and data modeling experience, including dimensional modeling, star and snowflake schemas, relational databases, data warehouses,lakehousepatterns, curated datasets, and semantic layers.

  • Experience combining data across multiple divisions, platforms, source systems, and maturity levels, with the judgment toidentifylimitations, document assumptions, and avoid misleading insights.

  • Strong business analysis and stakeholder management skills, with the ability to translate executive and operational needs into clear data products, technical specifications, and governance practices.

  • Excellent written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences and influence leaders to adopt standards.

  • Strong designsensibility for executive reporting, including visualization best practices, accessibility, user experience, branding, storytelling, layout, filters, slicers, navigation, and actionable insights.

  • Demonstrated ability to lead highly visible initiatives whileremaininghands-on in architecture, development, troubleshooting, and quality review.

  • Bachelor's degree in computer science, Information Systems, Statistics, Analytics, Data Science, Business, or a related field, or equivalent practical experience.

Preferred Qualifications

  • Experience with Azure, Databricks, Microsoft Fabric, Azure Data Lake, Synapse, SQL Server, Analysis Services, Purview, or related Microsoft data platform capabilities.

  • Experience with Tableau or other BI tools, especially where tool rationalization or standardizationwasrequired.

  • Experience in data governance, master data management, data quality, metadata management, data lineage, stewardship, or enterprise data strategy.

  • Power BI, Fabric, Azure Data Engineer, Azure Solutions Architect, or related Microsoft certifications.

  • Experience with Python, R, APIs, automation, DevOps, Git, or advanced analytics workflows.

Pay Range

170,000.00 - 180,000.00 Annual

The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role.

Teammate Benefits & Total Well-Being

We go beyond standard benefits, focusing on the total well-being of our teammates, including:

  • Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance
  • Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement
  • Mental Health & Wellness: Free Mental Health &Enhanced Advocacy Services
  • Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more.

Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations.


Recruiting Vendor Disclosure Statement

Brown & Brown does not accept unsolicited resumes from external recruiters, recruitment vendors or employment agencies ("Recruiting Vendors"). Recruiting Vendors must have a valid written agreement and received prior written authorization from an authorized Brown & Brown representative before submitting candidates for any publicly posted role. Any unsolicited resumes submitted to Brown & Brown or its employees become the property of Brown & Brown, and no fees will be paid for such submissions. Additional information regarding this policy can be found on our careers page.

The Power To Be Yourself

As an Equal Opportunity Employer, we are committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, "The Power to Be Yourself".

Apply