Business Intelligence & Data Strategy Analyst at Hoefer Welker in Kansas City, MO | Kablio

Role

Description

power bi

dashboard design

data integration

automation tools

data governance

executive reporting

Proactively identify opportunities for improvement and innovation.
Design, build, and maintain Power BI dashboards, Excel models, and automated reporting tools.
Support annual planning, forecasting cycles, KPI development, and performance tracking.
Increase operational efficiency through automation and data-driven solutions.
Deliver accurate, timely dashboards and reporting tools that enhance decision-making.
Develop a deep understanding of the firm’s business model, workflows, financial frameworks, and project delivery methods.
Maintain confidentiality and handle firmwide data responsibly.
Train staff and support adoption of dashboards and tools across the firm.
Writes documentation to describe solution development, logic, coding, and corrections.
Analyze business performance across sectors, geographies, and service lines to identify trends, risks, and opportunities.
Integrate data from multiple sources into unified reporting environments and improve data accuracy, governance, and workflows.
Ensure data quality, consistency, and governance across reporting environments.
Partner effectively with leadership across all business units and maintain strong internal relationships.
Implement automation tools and AI-enabled solutions to increase productivity and streamline processes.
Collaborate with finance, operations, HR, marketing, and practice leaders to gather requirements and deliver analytical solutions.
Present insights and recommendations to executive leadership in clear, accessible formats.

Requirements

ai tools

power bi

tableau

erp

excel

sql

Experience implementing AI-powered productivity or analytic tools.
Strong communication, collaboration, and stakeholder management skills.
Experience in the A&E industry (architecture, engineering, design, construction) or professional services.
Knowledge of ERP systems (e.g., Deltek Vision/Vantagepoint) and project accounting.
Proficiency in Power BI (preferred), Tableau, or similar visualization software.
Ability to travel when necessary.
Ability to synthesize complex data into clear insights and tell compelling stories with data.
Experience building data pipelines or automations (Power Automate, Python, etc.).
Demonstrate measurable impact within the first 6–12 months through improvements in reporting, automation, and strategic insight.
Strong skills in Excel, SQL, and data modeling / dashboard development.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

$53M

Mental Health Campus Project

Designed a state-of-the-art mental health campus in Kansas City that opened in 2024.

500,000

Annual Patient Visits

The Phoenix VA clinic design handles over half a million patient visits annually, showcasing its impact on healthcare infrastructure.

Founded in 1996, the firm began as a regional practice and evolved into a multidisciplinary design studio.
In 2020, the firm expanded its focus to include MEP engineering and medical equipment planning.
In 2021, leadership rebranded the firm to reflect its growing influence under a new partner-led identity.
Headquartered in Kansas City, with offices in Dallas and Jacksonville, the firm delivers nationwide projects.
The firm's work typically spans VA clinics, mental health hospitals, university campuses, and civic headquarters.
The self-designed corporate HQ on Plaza features living-room-style studios, cafés, and collaborative spaces.
The firm integrates natural light and biophilic principles to create welcoming, performance-driven environments.
An in-house MEP division was launched, signaling deeper technical integration into the firm's operations.

Culture + Values

Top 500 Design Firms

Engineering News‑Record Ranking

Ranked among the Top 500 Design Firms by Engineering News‑Record, demonstrating exceptional design and professional services.

Clients love us because of our unwavering commitment to meaningful design, innovation and sustainability.
We believe that the best idea wins, and we strive to interact with each other and our clients with empathy and humility.
Collaboration and curiosity are the driving force behind every project and interaction.
Every member of our team is encouraged to bring their expertise and perspective to the table to create the best possible design solutions.
Close collaboration between Architecture and Engineering—‘we are on the same team…which allows us to come up with better solutions faster than anyone else.’
Culture supports career growth, opens the door to new market sectors, and is constantly evolving.
Award‑winning workplace—‘one of Kansas City’s Best Places to Work’, ‘AIA Central States Region Emerging Professional Friendly Firm’.

Environment + Sustainability

30% Less

Energy Consumption Goal

Projects designed to use 30% less energy compared to industry standards.

2030 Goal

Carbon Neutrality Pledge

Commitment to achieve carbon neutrality across projects by 2030 through the AIA 2030 initiative.

40% Water Reduction

Water Efficiency Target

Projects designed to use 40% less water than typical designs.

Embeds sustainability in every project phase with an eco-charrette audit.
Internal office practices include healthy materials, daylighting, acoustical adjustments, efficient fixtures, low-use water, recycling, and composting.
Offers specialized services such as energy audits, life-cycle carbon analysis, ESG reporting, sustainability charrettes, and certification coordination (LEED, WELL, etc.).
A Materials-Pledge committee focuses on sustainable material selection through firm-wide education and champion programs.

Inclusion & Diversity

No women or minorities in partnership or senior leadership roles—Glassdoor reports indicate leadership positions are exclusively held by men.
Promotions perceived to favor those ‘cozied up to leadership’ and longevity over performance, with women and minorities overlooked.
Employee feedback describes a ‘frat/boys club’ culture, reports of misogynistic tones and inappropriate comments directed at or about female staff and clients.
Reports of systemic favoritism and lack of clear advancement structure, particularly disadvantaging gender diversity in leadership.

Articles

About Us

Careers

Portfolio

Role

Description

power bi

dashboard design

data integration

automation tools

data governance

executive reporting

Proactively identify opportunities for improvement and innovation.
Design, build, and maintain Power BI dashboards, Excel models, and automated reporting tools.
Support annual planning, forecasting cycles, KPI development, and performance tracking.
Increase operational efficiency through automation and data-driven solutions.
Deliver accurate, timely dashboards and reporting tools that enhance decision-making.
Develop a deep understanding of the firm’s business model, workflows, financial frameworks, and project delivery methods.
Maintain confidentiality and handle firmwide data responsibly.
Train staff and support adoption of dashboards and tools across the firm.
Writes documentation to describe solution development, logic, coding, and corrections.
Analyze business performance across sectors, geographies, and service lines to identify trends, risks, and opportunities.
Integrate data from multiple sources into unified reporting environments and improve data accuracy, governance, and workflows.
Ensure data quality, consistency, and governance across reporting environments.
Partner effectively with leadership across all business units and maintain strong internal relationships.
Implement automation tools and AI-enabled solutions to increase productivity and streamline processes.
Collaborate with finance, operations, HR, marketing, and practice leaders to gather requirements and deliver analytical solutions.
Present insights and recommendations to executive leadership in clear, accessible formats.

Requirements

ai tools

power bi

tableau

erp

excel

sql

Experience implementing AI-powered productivity or analytic tools.
Strong communication, collaboration, and stakeholder management skills.
Experience in the A&E industry (architecture, engineering, design, construction) or professional services.
Knowledge of ERP systems (e.g., Deltek Vision/Vantagepoint) and project accounting.
Proficiency in Power BI (preferred), Tableau, or similar visualization software.
Ability to travel when necessary.
Ability to synthesize complex data into clear insights and tell compelling stories with data.
Experience building data pipelines or automations (Power Automate, Python, etc.).
Demonstrate measurable impact within the first 6–12 months through improvements in reporting, automation, and strategic insight.
Strong skills in Excel, SQL, and data modeling / dashboard development.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

$53M

Mental Health Campus Project

Designed a state-of-the-art mental health campus in Kansas City that opened in 2024.

500,000

Annual Patient Visits

The Phoenix VA clinic design handles over half a million patient visits annually, showcasing its impact on healthcare infrastructure.

Founded in 1996, the firm began as a regional practice and evolved into a multidisciplinary design studio.
In 2020, the firm expanded its focus to include MEP engineering and medical equipment planning.
In 2021, leadership rebranded the firm to reflect its growing influence under a new partner-led identity.
Headquartered in Kansas City, with offices in Dallas and Jacksonville, the firm delivers nationwide projects.
The firm's work typically spans VA clinics, mental health hospitals, university campuses, and civic headquarters.
The self-designed corporate HQ on Plaza features living-room-style studios, cafés, and collaborative spaces.
The firm integrates natural light and biophilic principles to create welcoming, performance-driven environments.
An in-house MEP division was launched, signaling deeper technical integration into the firm's operations.

Culture + Values

Top 500 Design Firms

Engineering News‑Record Ranking

Ranked among the Top 500 Design Firms by Engineering News‑Record, demonstrating exceptional design and professional services.

Clients love us because of our unwavering commitment to meaningful design, innovation and sustainability.
We believe that the best idea wins, and we strive to interact with each other and our clients with empathy and humility.
Collaboration and curiosity are the driving force behind every project and interaction.
Every member of our team is encouraged to bring their expertise and perspective to the table to create the best possible design solutions.
Close collaboration between Architecture and Engineering—‘we are on the same team…which allows us to come up with better solutions faster than anyone else.’
Culture supports career growth, opens the door to new market sectors, and is constantly evolving.
Award‑winning workplace—‘one of Kansas City’s Best Places to Work’, ‘AIA Central States Region Emerging Professional Friendly Firm’.

Environment + Sustainability

30% Less

Energy Consumption Goal

Projects designed to use 30% less energy compared to industry standards.

2030 Goal

Carbon Neutrality Pledge

Commitment to achieve carbon neutrality across projects by 2030 through the AIA 2030 initiative.

40% Water Reduction

Water Efficiency Target

Projects designed to use 40% less water than typical designs.

Embeds sustainability in every project phase with an eco-charrette audit.
Internal office practices include healthy materials, daylighting, acoustical adjustments, efficient fixtures, low-use water, recycling, and composting.
Offers specialized services such as energy audits, life-cycle carbon analysis, ESG reporting, sustainability charrettes, and certification coordination (LEED, WELL, etc.).
A Materials-Pledge committee focuses on sustainable material selection through firm-wide education and champion programs.

Inclusion & Diversity

No women or minorities in partnership or senior leadership roles—Glassdoor reports indicate leadership positions are exclusively held by men.
Promotions perceived to favor those ‘cozied up to leadership’ and longevity over performance, with women and minorities overlooked.
Employee feedback describes a ‘frat/boys club’ culture, reports of misogynistic tones and inappropriate comments directed at or about female staff and clients.
Reports of systemic favoritism and lack of clear advancement structure, particularly disadvantaging gender diversity in leadership.

Articles

About Us

Careers

Portfolio