Business Intelligence Analyst; Data & Analytics

Apex Service Partners (“Apex”orthe“Company”)isagroupofleadingresidentialservicesbusinesses that conducts HVAC, plumbing and electrical work for residential homeowners. In this fragmented industry dominated by small and founder-owned businesses, the Company’s strategy is to execute significantorganic growth initiatives andhigh-frequency M&A. This roll-upstrategy necessitates an A+ finance team.

Apex Service Partners was founded in 2019 with a mission to build a partnership of like-minded world-class service providers to build an industry leading national platform. Apex focuses on leveraging the power of people to build a strong network of industry leaders who can share resources, best practices, and expertise to deliver unparalleled service to customers and opportunities for employees.

The Companyanditsexecutiveteamarebeingbackedby Alpine Investors (“Alpine”),aprivateequity firm that specializes in majority or full buyouts of founder-owned businesses and corporate carve- outs. Alpine specializes inmiddle-market companies (i.e., those with valuations up to $500 million), havinginvestedin
50+businessessinceinceptionin
2001.Alpinerecentlyclosedits

FundIXat $4.5 billion in capital commitments.

Job Description –Business Intelligence Analyst (Data & Analytics)

Missionofthe Role:

Apex is seeking a Business Intelligence Analyst to join our growing Data & Analytics team. This role is responsible for helping design, build, validate, and continuously improve Power BI products that enable better decision-making across the business.

This is an ideal opportunity for a recent graduate with exceptional analytical ability, strong Excel skills, and a desire to build a career in business intelligence. Prior Power BI experience is helpful but not required—we're looking for someone who thinks logically, enjoys solving complex problems, learns new technologies quickly, and is comfortable leveraging AI tools to research, troubleshoot, and accelerate their learning.

The BI Analyst will work closely with Product Managers, Data Engineers, and business stakeholders to translate business requirements into intuitive, visually polished, and highly usable BI products. Success in this role requires strong attention to detail, a passion for creating exceptional user experiences, intellectual curiosity, and the initiative to independently solve problems and continuously improve both the product and the way work gets done.

Responsibilities:

• Business Intelligence Development:

• Design, develop, and enhance Power BI dashboards and reports.

• Build intuitive, visually polished BI products that help users quickly understand and act on data.

• Develop and maintain DAX measures, calculations, and semantic models.

• Find opportunities to upgrade and enhance existing dashboards and reports with additional functionality and better UI/UX.

• Ensure reports are accurate, performant, and easy to use.

• Participate in dashboard testing, validation, and quality assurance prior to release.

• Product Development:

• Partner with Product Managers to translate business requirements into technical solutions.

• Contribute ideas to improve existing BI products and user experience.

• Document report logic, calculations, and design decisions.

• Support ongoing feature releases and continuous product improvements.

• Data Analysis & Problem Solving:

• Investigate reported data issues and assist with root cause analysis.

• Validate report outputs against underlying data.

• Perform exploratory analysis to answer business questions and identify trends.

• Help improve data quality through testing and validation.

• Collaboration:

• Work closely with Product Managers, Data Engineers, and business stakeholders throughout the…