Hoefer Welker · 1 day ago
Business Intelligence & Data Strategy Analyst
Kansas City, MO
Full-time
Hybrid
Mid, Senior Level
3+ years expHoefer Welker is a firm focused on transforming data into meaningful insights for strategic decision-making. The Business Intelligence & Data Strategy Analyst will develop dashboards and analytics tools while collaborating with leadership to enhance operational performance and support firm strategy.
Product Design
Responsibilities
Develop a deep understanding of the firm’s business model, workflows, financial frameworks, and project delivery methods
Analyze business performance across sectors, geographies, and service lines to identify trends, risks, and opportunities
Design, build, and maintain Power BI dashboards, Excel models, and automated reporting tools
Collaborate with finance, operations, HR, marketing, and practice leaders to gather requirements and deliver analytical solutions
Integrate data from multiple sources into unified reporting environments and improve data accuracy, governance, and workflows
Implement automation tools and AI-enabled solutions to increase productivity and streamline processes
Present insights and recommendations to executive leadership in clear, accessible formats
Writes documentation to describe solution development, logic, coding, and corrections
Train staff and support adoption of dashboards and tools across the firm
Support annual planning, forecasting cycles, KPI development, and performance tracking
Deliver accurate, timely dashboards and reporting tools that enhance decision-making
Increase operational efficiency through automation and data-driven solutions
Partner effectively with leadership across all business units and maintain strong internal relationships
Ensure data quality, consistency, and governance across reporting environments
Proactively identify opportunities for improvement and innovation
Demonstrate measurable impact within the first 6–12 months through improvements in reporting, automation, and strategic insight
Maintain confidentiality and handle firmwide data responsibly
Ability to travel when necessary
Qualification
Required
Bachelor's degree in Business Analytics, Data Science, Finance, Information Systems, or a related field required
3–7 years of experience in data analytics, business intelligence, or strategic operations
Strong skills in Excel, SQL, and data modeling / dashboard development
Ability to synthesize complex data into clear insights and tell compelling stories with data
Strong communication, collaboration, and stakeholder management skills
Proficiency in Power BI (preferred), Tableau, or similar visualization software
Ability to travel when necessary
Preferred
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
Experience implementing AI-powered productivity or analytic tools
Experience building data pipelines or automations (Power Automate, Python, etc.)
Company
Hoefer Welker
Founded in 1996, Hoefer Welker is a full-service design firm offering architecture, interior design, MEP engineering, and medical equipment planning and technology consulting.
51-200 employees
H1B Sponsorship
Hoefer Welker has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (1)
2021 (1)
Funding
Current Stage
Growth StageLeadership Team
Mitch Hoefer
CEO & Partner
Chris Andersen
Partner and CFO
Recent News
2025-06-13
Company data provided by crunchbase