Business Intelligence Specialist I

We are seeking a Power BI / Data Visualization Specialist to design, develop, and maintain business intelligence solutions that transform complex data into actionable insights. This role will partner with Operations, Finance, and Business Technology teams to deliver clear, accurate, and impactful reporting that supports data-driven decision-making.

The ideal candidate combines strong technical expertise with business acumen and excels at translating data into meaningful, visually compelling narratives .

About HFA - Employee Owned. People Powered.

HFA is a 100% employee-owned multidisciplinary architectural, engineering, and interior architecture firm who thrives in a people-first environment. Employee ownership isn't just a structure - it's a mindset that fuels everything we do. This mindset empowers us to think beyond our roles, pushing us to find innovative solutions that strengthen our client relationships and deepen our connections with our people internally. We believe that our people are our greatest asset which aligns with our culture code: We aspire to be a people-first culture of empowerment where talent thrives.

The ownership mindset also means that every team member is personally invested in the success of our projects and clients. This approach ensures that every decision aligns with our purpose: Leading our clients to fulfill their vision while building lasting partnerships.

With our focus on our people, we offer competitive salaries and a comprehensive benefits package including medical, dental, vision, disability, and life insurance, a 401(k) with company match, an employee stock ownership plan (ESOP), and a flexible work schedule. We provide our team members with professional development opportunities and learning stipends to pursue professional growth, and we take any chance we can get to recognize and reward our people for their amazing work.

Job Responsibilities:

• Design, develop, and maintain business intelligence solutions that transform complex data into actionable insights
• Collaborate with Operations, Finance, and Business Technology teams to deliver clear, accurate, and impactful reporting
• Support data-driven decision-making through reporting and analytics
• Translate complex data into meaningful, visually compelling narratives
• Support data governance, reporting performance, and end-user enablement

Job Duties:

• Design and develop interactive dashboards and reports using Power BI and similar visualization tools
• Create intuitive visualizations that communicate trends, risks, and opportunities
• Build and maintain standardized reporting frameworks and templates
• Develop data models to support scalable and high-performance reporting
• Clean, transform, and integrate data from multiple sources such as ERP, CRM, and data warehouses
• Create calculated measures and KPIs using DAX and Power Query
• Collaborate with stakeholders to understand reporting and analytics needs
• Translate business requirements into technical specifications and dashboards
• Provide insights that support operational, financial, and strategic decisions
• Ensure data accuracy, consistency, integrity, and appropriate security across reports
• Maintain documentation of data sources, transformations, and reporting logic
• Train and support end users on Power BI tools and reports
• Troubleshoot report issues and optimize performance
• Stay current with Power BI features and industry trends

Education Requirements: Bachelor's degree in Data Analytics, Computer Science, Information Systems, or related field

Licensure Requirements: None required

Required Qualifications

• 3+ years of experience in Power BI, data visualization, or business intelligence
• Strong proficiency in Power BI, DAX, and Power Query
• Experience with SQL and relational databases
• Solid understanding of data modeling and data warehousing concepts

Preferred Qualifications:

• Experience with Microsoft ecosystem tools such as Dynamics 365, Azure, Excel, and Dataverse
• Experience working with ERP or project-based financial data
• Power BI certification such as PL-300
• Familiarity with ETL processes and data pipelines