Business Intelligence Analyst (Data & Analytics)

Overview Company Overview 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) 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…