Business Intelligence Analyst (Data & Analytics)

Apex Service Partners (“Apex” or the “Company”) is a group of leading residential services businesses 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 significant organic growth initiatives and high-frequency M&A. This roll-up strategy 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 Company and its executive team are being backed by Alpine Investors (“Alpine”), a private equity firm that specializes in majority or full buyouts of founder-owned businesses and corporate carve- outs. Alpine specializes in middle-market companies (i.e., those with valuations up to $500 million), having invested in 50+ businesses since inception in 2001. Alpine recently closed its Fund IX at $4.5 billion in capital commitments. 

Job Description –Business Intelligence Analyst (Data & Analytics) 

Mission of the 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 product lifecycle.  

• Present findings and recommendations clearly to both technical and non-technical audiences.  

• Continuously learn new technologies, development techniques, and AI-assisted workflows to improve productivity and quality.  

Qualifications: 

• Required 

• Bachelor's degree in Business Analytics, Information Systems, Finance, Economics, Statistics, Mathematics, Data Science, Computer Science, or a related field.  

• Strong Microsoft Excel skills, including the ability to organize, model, analyze, and validate data.  

• Strong analytical and problem-solving abilities.  

• Experience with Git and Snowflake is a plus. Familiarity with Microsoft Fabric ecosystem is highly desirable. 

• Excellent attention to detail.  

• Strong written and verbal communication skills.  

• Demonstrated ability to learn new technologies quickly.  

• Comfortable working in a fast-paced, collaborative environment.  

• Preferred 

• Exposure to Power BI through coursework, internships, or personal projects.  

• Basic SQL knowledge.  

• Familiarity with relational databases and data modeling concepts.  

• Experience using AI tools (e.g., ChatGPT, Claude, GitHub Copilot, etc.) to accelerate learning, troubleshoot problems, and improve productivity.  

Personal Characteristics: 

• Loves solving difficult problems and figuring things out independently.  

• Has exceptional analytical aptitude and strong business intuition.  

• Produces work with a high level of accuracy and attention to detail.  

• Cares deeply about both the quality of the data and the user experience of the final product.  

• Enjoys learning new tools and technologies.  

• Takes ownership and follows through.  

• Welcomes feedback and continuously looks for ways to improve.  

• Works well with both technical and business partners.  

• Thrives in a fast-moving, entrepreneurial environment. 

Other: 

Location: Tampa, FL  

Compensation: Competitive 

Other Benefits: medical, dental and vision coverage; unlimited PTO; 401(k) matching