ZipRecruiter

Log In

1

Director Power Bi Report Developer Jobs in Chicago, IL

Aprio

Business Intelligence Architect

Chicago, IL

... report developers, facilitate requirements sessions with business stakeholders, and architect ... Design and build enterprise semantic models in Microsoft Fabric using Direct Lake mode, Power BI ...

Aprio

Business Intelligence Architect

Schaumburg, IL

... report developers, facilitate requirements sessions with business stakeholders, and architect ... Design and build enterprise semantic models in Microsoft Fabric using Direct Lake mode, Power BI ...

Reli Group Inc

Power BI Intern

Aurora, IL · On-site

$15/hr

The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders. This is an excellent opportunity for ...

Reli Group Inc

Power BI Intern

Aurora, IL

$15/hr

The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders. This is an excellent opportunity for ...

SPS North America

Director, BI

Chicago, IL · Hybrid

... engineers, and analysts. * Design and deliver end-to-end analytics solutions utilizing Power BI ... Build executive dashboards, KPIs, and reporting solutions that enable data-driven business ...

Collectiv

Senior Power BI Consultant

Chicago, IL · On-site +1

Create visually appealing and interactive reports and dashboards using Power BI * Develop and optimize DAX formulas * Integrate data from diverse sources * Leverage SQL skills to facilitate efficient ...

Reli Group Inc

Power BI Intern

Hammond, IN · On-site

$15/hr

The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders. This is an excellent opportunity for ...

Reli Group Inc

Power BI Intern

Gary, IN · On-site

$15/hr

The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders. This is an excellent opportunity for ...

Collectiv

Senior Power BI Consultant

Chicago, IL · On-site +1

Create visually appealing and interactive reports and dashboards using Power BI * Develop and optimize DAX formulas * Integrate data from diverse sources * Leverage SQL skills to facilitate efficient ...

Reli Group Inc

Power BI Intern

Chicago, IL · On-site

$15/hr

The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders. This is an excellent opportunity for ...

Varsity Tutors

Microsoft Power BI Tutor

Oak Lawn, IL · Remote

$18 - $40/hr

Deep knowledge of Power BI data modeling, DAX formulas, data visualization, report design, dashboard creation, data transformation with Power Query, data source connections, and sharing and ...

Varsity Tutors

Microsoft Power BI Tutor

Wheaton, IL · Remote

$18 - $40/hr

Deep knowledge of Power BI data modeling, DAX formulas, data visualization, report design, dashboard creation, data transformation with Power Query, data source connections, and sharing and ...

Varsity Tutors

Microsoft Power BI Tutor

Lake Forest, IL · Remote

$18 - $40/hr

Deep knowledge of Power BI data modeling, DAX formulas, data visualization, report design, dashboard creation, data transformation with Power Query, data source connections, and sharing and ...

previous pagenext page

Showing results 21-40

All JobsPower Bi Report Developer JobsDirector Power Bi Report Developer JobsDirector Power Bi Report Developer Jobs in Chicago, IL

Director Power Bi Report Developer information

See Chicago, IL salary details

$30

$54

$72

How much do director power bi report developer jobs pay per hour?

As of Aug 17, 2026, the average hourly pay for director power bi report developer in Chicago, IL is $54.61, according to ZipRecruiter salary data. Most workers in this role earn between $49.76 and $60.19 per hour, depending on experience, location, and employer.

What does a Director Power BI Report Developer do?

A Director Power BI Report Developer leads the design, development, and implementation of business intelligence (BI) solutions using Microsoft Power BI. They oversee teams responsible for creating interactive reports and dashboards that help organizations make data-driven decisions. Their responsibilities also include setting BI strategy, ensuring data accuracy and security, and collaborating with stakeholders to understand reporting needs. Additionally, they often provide training and best practices to ensure the effective use of Power BI across the organization.

What are the key skills and qualifications needed to thrive as a Director Power BI Report Developer?

To thrive as a Director Power BI Report Developer, you need advanced expertise in data visualization, business intelligence, and analytics, usually supported by a degree in computer science, information systems, or a related field. Mastery of Power BI, SQL, DAX, and experience with data warehousing, alongside relevant certifications like Microsoft Certified: Data Analyst Associate, are typically required. Strong leadership, strategic thinking, and effective communication skills help in managing teams and translating business needs into actionable insights. These competencies ensure the delivery of impactful data solutions that drive organizational decision-making and foster data-driven cultures.

How does a Director Power BI Report Developer typically collaborate with cross-functional teams to deliver impactful data solutions?

As a Director Power BI Report Developer, collaboration with cross-functional teams is essential for translating business needs into effective data visualizations and insights. This role regularly works with stakeholders from finance, operations, IT, and executive leadership to gather requirements, prioritize projects, and ensure reports align with organizational objectives. Directors also guide and mentor junior analysts, foster best practices in data governance, and facilitate workshops to enhance data literacy across departments. Strong communication and project management skills are crucial for coordinating multi-team efforts and delivering timely, actionable dashboards.

What is the difference between Director Power Bi Report Developer vs Power BI Report Developer?

AspectDirector Power Bi Report DeveloperPower BI Report Developer
CredentialsTypically requires advanced certifications (e.g., Microsoft Certified: Data Analyst Associate), extensive experienceOften requires basic to intermediate Power BI certifications, relevant experience
Work EnvironmentLeads teams, manages projects, strategic planningFocuses on report creation, data modeling, dashboard development
Employer & Industry UsageUsed in large organizations, enterprise-level projectsCommon in various industries, including finance, healthcare, retail

The main difference between a Director Power Bi Report Developer and a Power BI Report Developer lies in their scope and responsibilities. The director oversees teams and strategic initiatives, while the report developer focuses on creating and maintaining reports. Both roles require Power BI skills, but the director position involves leadership and higher-level planning.

What are the most commonly searched types of Power Bi Report Developer jobs in Chicago, IL?

The most popular types of Power Bi Report Developer jobs in Chicago, IL are:

What cities near Chicago, IL are hiring for Director Power Bi Report Developer jobs?

Cities near Chicago, IL with the most Director Power Bi Report Developer job openings:

Director Power Bi Report Developer jobs near you
Infographic showing various Director Power Bi Report Developer job openings in Chicago, IL as of July 2026, with employment types broken down into 1% As Needed, 77% Full Time, 17% Part Time, 1% Temporary, 3% Contract, and 1% Nights. Highlights an 94% Physical, 2% Hybrid, and 4% Remote job distribution, with an average salary of $113,599 per year, or $54.6 per hour.

Business Intelligence Architect

Aprio

Libertyville, IL

Full-time

Medical, Dental, Vision, Retirement

Posted 26 days ago

Job description

Work with a Top 20 CPA and advisory firm that Accounts for Anything.  Aprio has 40 U.S. office locations, as well as international office locations and more than 3,200 team members that speak 60+ languages across the globe.  By bringing together proven expertise, deep understanding, and strategic foresight for fast-growing industries, Aprio ensures clients are prepared for wherever life or business may take them. Discover a top-rated culture, vast growth opportunities and your next big career move with Aprio.

Join Aprio's Information Technology team and you will help clients maximize their opportunities.  Aprio Advisory Group, LLC is a progressive, fast-growing firm looking for a Business Intelligence Architect to join their dynamic team. 

Aprio's Insights & Analytics team is expanding its Microsoft Fabric platform capabilities and is seeking a skilled Power BI & Fabric Semantic Model Architect to lead the design, development, and governance of enterprise-grade semantic models. This role bridges the gap between raw data and business insight-translating complex stakeholder requirements into well-structured, performant data models that power decision-making across the firm. 

The ideal candidate is both technically deep and interpersonally strong-someone who can lead and coach a team of report developers, facilitate requirements sessions with business stakeholders, and architect scalable solutions within Microsoft Fabric and Power BI. As Aprio accelerates its AI strategy, this role will play a central part in enabling natural language query (NLQ) capabilities, AI-powered analytics, and Copilot integration across the firm's reporting ecosystem.

Responsibilities:

Semantic Modeling & Architecture 

  • Design and build enterprise semantic models in Microsoft Fabric using Direct Lake mode, Power BI Datasets, and Dataflows Gen2 
  • Develop well-structured star and snowflake schemas optimized for Power BI performance, NLQ discoverability, and Copilot compatibility 
  • Author complex DAX measures, calculated columns, and KPI logic following organizational standards; ensure measure naming and descriptions support AI-assisted querying 
  • Establish and maintain a governed, reusable semantic layer across reporting domains (finance, operations, marketing, HR, growth) 
  • Evaluate and implement incremental refresh, aggregations, and query reduction strategies 
  • Architect semantic models to support natural language query (Q&A, Power BI Copilot, Azure OpenAI integration) by enforcing descriptive field names, synonyms, and measure annotations 
  • Define and maintain Q&A synonyms, linguistic schemas, and field-level descriptions that enable accurate AI-driven query interpretation 

AI, Natural Language Query & Copilot Enablement 

  • Lead Aprio's adoption of Power BI Copilot and Microsoft Fabric AI features, including AI-generated report summaries, smart narratives, and anomaly detection 
  • Design semantic models and data products with AI-readiness in mind-ensuring metadata quality, field descriptions, and schema consistency support large language model (LLM) integrations 
  • Collaborate with IT and data engineering to evaluate and implement natural language query interfaces, including Power BI Q&A, Copilot for Microsoft 365, and Azure OpenAI Service connections to Fabric data 
  • Develop prompting strategies and governance guardrails for AI-generated insights to ensure accuracy, auditability, and alignment with firm standards 
  • Evaluate emerging Microsoft AI capabilities (Fabric Workload Hub, Copilot Studio, OneLake AI catalog) and provide architectural recommendations for phased adoption 
  • Partner with business stakeholders to identify high-value use cases for AI-assisted analytics, self-service insights, and conversational BI 
  • Educate and upskill team members and business users on responsible use of AI tools within the BI ecosystem 

Team Coaching & Development 

  • Mentor and coach a team of 4+ report developers, providing technical guidance on best practices, model design, DAX, and AI-era BI patterns 
  • Conduct code and model reviews, establishing a culture of quality and continuous improvement 
  • Create internal documentation, standards guides, and reusable component libraries for the team 
  • Support onboarding of new team members and facilitate skill development in Power BI, Fabric, and emerging AI analytics tools 

Business & Stakeholder Engagement 

  • Lead requirements-gathering sessions with business stakeholders, translating needs into data model specifications and AI-assisted analytics roadmaps 
  • Serve as a trusted advisor, clearly communicating model design decisions, tradeoffs, and AI capability opportunities to executive and non-technical audiences 
  • Collaborate with data engineers, DevOps, and business analysts to ensure analytical models support downstream use cases including Copilot and self-service BI 
  • Champion data literacy and responsible AI use across the organization in collaboration with the data governance manager and data governance committee 

Fabric Platform & Governance 

  • Own the semantic model layer within the Aprio Microsoft Fabric Lakehouse architecture (OneLake, Lakehouse, Notebooks) 
  • Define and enforce naming conventions, model governance standards, certification processes, and AI metadata standards for published datasets 
  • Coordinate with the data engineering team to ensure clean, well-documented source data is available for modeling and AI consumption 
  • Monitor model health, performance, and usage via Power BI Admin portal and Fabric Monitoring Hub 
  • Ensure compliance with data security, row-level security (RLS), and data privacy requirements across all published models and AI-accessible data products 
  • Establish AI governance practices including prompt auditability, output validation standards, and acceptable use policies for AI-generated content within BI workflows 
Qualifications:
  • 5-8 years of experience designing and publishing Power BI semantic models in enterprise environments 
  • Proficiency in DAX, Power Query (M), and data modeling concepts (star schema, relationships, cardinality) 
  • Hands-on experience with Microsoft Fabric (OneLake, Lakehouses, Dataflows Gen2, Direct Lake mode) 
  • Demonstrated experience with Power BI Q&A, linguistic schema authoring, and synonym configuration for natural language query 
  • Familiarity with Power BI Copilot, Microsoft 365 Copilot, or Azure OpenAI Service integrations with Fabric data sources 
  • Demonstrated ability to gather, document, and translate business requirements into data models and AI-readiness roadmaps 
  • Experience coaching or mentoring junior analysts or developers 
  • Strong communication skills with the ability to explain technical concepts-including AI capabilities and limitations-to non-technical audiences 
  • Familiarity with data governance, RLS, dataset certification, and Power BI deployment pipelines 
  • Understanding of responsible AI principles, data privacy considerations, and AI output auditability in enterprise analytics contexts 
Preferred Qualifications:
  • Microsoft certifications: PL-300 (Power BI Data Analyst), DP-600 (Fabric Analytics Engineer), or DP-100 (Azure Data Scientist) 
  • Experience with Azure OpenAI Service, Semantic Kernel, or LangChain in analytics or data product contexts 
  • Exposure to Copilot Studio or Power Automate AI flows for automating insight delivery 
  • Experience in a professional services or accounting firm environment 
  • Familiarity with Microsoft Purview for data cataloging, lineage, and AI governance 
Core Competencies:
  • Data Modeling Proficiency 
  • Performance Optimization 
  • AI & NLQ Enablement 
  • Translating to Tech and Non-Tech 
  • Analytical Thinking 
  • Coaching & Mentorship 
  • Attention to Detail 
  • Internal/External Team Collaboration 
  • Strong Communication 
  • Continuous Learning Mindset 
  • Business Acumen 
  • Responsible AI Judgment 
Why work for Aprio:
Whether you are just starting out, looking to advance into management or searching for your next leadership role, Aprio offers an opportunity to grow with a future-focused, innovative firm.
 
 
Perks/Benefits we offer for full-time team members:
- Medical, Dental, and Vision Insurance on the first day of employment
- Flexible Spending Account and Dependent Care Account
- 401k with Profit Sharing
- 9+ holidays and discretionary time off structure
- Parental Leave - coverage for both primary and secondary caregivers
- Tuition Assistance Program and CPA support program with cash incentive upon completion
- Discretionary incentive compensation based on firm, group and individual performance
- Incentive compensation related to origination of new client sales
- Top rated wellness program
- Flexible working environment including remote and hybrid options
 
 
What's in it for you:
- Working with an industry leader: Be part of a high-growth firm that is passionate for what's next.
- An awesome culture: Thirty-one fundamental behaviors guide our culture every day ensuring we always deliver an exceptional team-member and client experience.  We call it the Aprio Way.  This shared mindset creates lasting relationships between team members and with clients.
- A great team: Work with a high-energy, passionate, caring and ambitious team of professionals in a collaborative culture.
- Entrepreneurship: Have the freedom to innovate and bring your ideas to help us grow to become the CPA firm of choice nationally.
- Growth opportunities: Grow professionally in an environment that fosters continuous learning and advancement.
- Competitive compensation: You will be rewarded with competitive compensation, industry-leading benefits and a flexible work environment to enjoy work/life balance.
 
 
EQUAL OPPORTUNITY EMPLOYER
Aprio is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race; color; religion; national origin; sex; pregnancy; sexual orientation; gender identity and/or expression; age; disability; genetic information, citizenship status; military service obligations or any other category protected by applicable federal, state, or local law.
 
Aprio, LLP and Aprio Advisory Group, LLC, operate in an alternative business structure, with Aprio Advisory Group, LLC providing non-attest tax and consulting services, and Aprio, LLP providing CPA firm services.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
apply for this job

Apply