BI Developer

Overview

The BI Developer is responsible for designing, developing, and maintaining enterprise‑grade Business Intelligence solutions using Power BI, DAX, SQL, and semantic models. This role works closely with business stakeholders, data engineers, and analysts to translate requirements into scalable data models and intuitive, high-performing dashboards. The ideal candidate has strong technical skills, a solid understanding of data modeling best practices, and the ability to deliver insights that support strategic decision‑making.

Responsibilities

Power BI Development

• Design and develop interactive dashboards and reports using Power BI.

• Build shared and certified semantic models to support self-service analytics and standardized reporting.

• Develop complex DAX calculations, measures, and KPIs that ensure accurate, consistent business logic.

• Optimize Power BI performance through model tuning, query reduction, and best-practice visualization standards.

Data Modeling & Semantic Layer

• Design star schemas, dimensional models, and reusable semantic models for enterprise reporting.

• Define relationships, hierarchies, and calculation groups to ensure scalable and maintainable datasets.

• Align semantic models with enterprise data governance, naming conventions, and data definitions.

SQL & Data Engineering Support

• Write advanced SQL queries to extract, transform, and validate datasets from relational and cloud data platforms.

• Collaborate with data engineering teams to refine source data structures and improve data quality.

• Troubleshoot data discrepancies, performance issues, and ETL/ELT data flow challenges.

Requirements Gathering & Stakeholder Engagement

• Partner with business teams to understand reporting needs, KPIs, and functional requirements.

• Translate business needs into technical specifications and reporting solutions.

• Provide user training, documentation, and support for Power BI adoption across the organization.

Qualifications

Required

• Bachelor’s degree in Computer Science, Information Systems, Analytics, or related field.

• 3+ years of hands-on experience with Power BI development .

• Strong expertise with DAX , including advanced calculations and time-intelligence functions.

• Proficient with SQL (joins, CTEs, window functions, performance tuning).

• Experience building and maintaining Power BI semantic models (star schema, fact/dim tables).

• Knowledge of BI best practices, data modeling methodologies, and performance optimization.

Preferred

• Experience with cloud data platforms (Azure Synapse, Fabric, Databricks, Snowflake, etc.).

• Familiarity with data governance, metadata, and enterprise reporting standards.

• Experience with version control (Git) and DevOps CI/CD for BI assets.

• Understanding of modern analytics platforms and data architecture patterns.

Equal Opportunity Field

We offer a comprehensive benefit package. For a complete overview of our benefits package, please visit our Joint Commission Career Page (

We are an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by law.

Min

USD $89,000.00/year

Max

USD $114,000.00/year

Job Locations US-IL-Oak Brook

Job ID 2026-7189

# of Openings 2

Category Information Technology

• Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.

• Please view Equal Employment Opportunity Posters provided by OFCCP here.

• The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.

• This Organization Participates in E-Verify. Click here for more information.