Lead - Business Intelligence Analyst

Who we Are

Oncourse Home Solutions (OHS) is a people-centric, $500M organization that is owned by private equity firm, Apax Partners operating under the brands American Water Resources, Pivotal Home Solutions and American Home Solutions. We do what is right for our people so they can do their best when serving our 1.8+ million customers across the U.S. Our mission is to create lasting value for our customers and our partners by helping homeowners navigate the unexpected, reduce costs, and make homeownership enjoyable for all. Our vision is to make our products and services accessible to our customers and our partners by becoming the most trusted and reliable home solutions organization in the market. We are committed to fostering an environment that embraces diversity in all forms, where our employees, customers and partners feel valued, respected, and supported.  

As a US-based warranty provider, we provide expertise in safety and homecare to our customers. Our integrated solutions meet customer needs both inside and outside the home. Inside the home we protect critical aspects of home function such as plumbing, heating and cooling, appliances, power surges, hot water heater, and interior electrical. Outside the home we provide protection for critical lines (water, gas, wells, sewers, electric and septic). We primarily go to market B2B2C, partnering mostly with water/gas/electric utilities and municipalities to offer our product leveraging their brand for marketing and often adding our subscription fee to the water/gas/electric bill itself. When our customers need help with home maintenance, repair, or coverage, OHS is there. This is what it means to be an ‘Oncourse SUPER’—Successful, United, Progressive, Empathetic, Reliable. SUPERs get it done. We sweat homeownership so our customers and partners don’t have to.  

As an equal opportunity employer, our employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, ancestry, marital status, parental status, mental or physical disability, military or veteran status, or any other basis protected by federal, state, or local law. Oncourse Home Solutions is committed to recruiting and retaining talented applicants and to providing all employees with a workplace free from discrimination and/or harassment. 

Position Summary

We are seeking a strategic and technically adept Business Intelligence and Analytics Lead to support our Claims organization. This role is ideal for someone who thrives in solving business problems through data strategy and process improvement, and is passionate about driving operational excellence

This Hybrid role is based in our Naperville, IL office.  Our office environment is a key driver of our company culture and employee experience, so a regular in-office hybrid model (generally T-TH in office and M & F remote) is required. 

Responsibilities include but are not limited to:

• Translate business needs into strategic data solutions, proactively solving problems beyond standard reporting requests  
• Establish and manage KPIs to monitor claims performance and operational effectiveness.  
• Collaborate with cross-functional teams (e.g., Call Center, Marketing, Finance, IT) to ensure alignment with business strategies.  
• Support long-term strategy development, helping leadership identify priorities and convert them into actionable plans.  
• Evaluate risks and develop mitigation strategies, including preparing risk reports for senior leadership.  
• Develop and enhance reporting tools and dashboards using Looker, LookML, SQL/Snowflake, and other BI platforms.  
• Guide process documentation and redesign efforts to improve reporting workflows and data accessibility.   
• Track and manage action items across multiple projects to ensure timely execution and strategic alignment.   
• Communicate insights and recommendations to stakeholders in a clear, actionable format tailored to different audiences 
• Provide guidance on technical development, strategic thinking, and performance improvement. 
  
  

We’re Excited If This Is You

Experience and Qualifications of the Role  

• 8+ years of progressive experience in analytics, business intelligence, financial reporting, or strategic planning roles, with a strong track record of delivering business impact.  
• Proven ability to translate business needs into strategic solutions, not just fulfill reporting requests.  
• Strong SQL and data modeling skills, with hands-on experience using Looker, Snowflake, SQL Server, and Excel.  
• Experience with data visualization platform