At Collective Health, the business problem is to transform how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design, specifically in the area of analytics to improve member outcomes and drive business performance.
Requirements
- Strong SQL skills with a track record of writing efficient, scalable queries for analysis and reporting.
- To be technically savvy with modern data tools. This includes advanced SQL, hands-on experience with cloud data platforms like Databricks, and expert-level proficiency in BI tools, especially Looker.
- Proven ability to work with complex, large-scale datasets from disparate silos, with a deep focus on healthcare data.
- A strong functional understanding of the claims adjudication process, from submission to payment.
- To champion data governance and quality by conducting audits and validation. This includes the ability to pull and interpret data from EDI files to support claims audits and analysis.
- Demonstrated project management skills, with the ability to prioritize tasks, manage timelines, and drive cross-functional collaboration.
- Strong communication skills, with the ability to translate technical findings into clear, actionable recommendations for non-technical stakeholders.
Responsibilities
- Design, build, and deliver sophisticated analyses focusing on core metrics from various domains such as claims, eligibility, customer experience, digital engagement, and the complete member journey.
- Translate business questions into analytic plans and communicate results in a clear, actionable manner to both technical and non-technical audiences.
- Design logical categorizations for dashboards and views, building scalable and automated reports in Looker and other BI tools to provide self-service insights to the business.
- Support internal stakeholders (e.g., Product, Customer Success, Marketing, etc.) by generating insights that inform strategy and operational improvements.
- Proactively identify and execute opportunities to build automated reports and analytical processes, reducing manual effort and increasing reliability.
- Provide technical mentorship and peer review, including refactoring and optimizing complex code for existing reports to improve performance and scalability.
- Work closely with the Data Architect and engineering teams to help build and refine the semantic layer, ensuring data models are optimized for analytical use.
Other
- A minimum of 5+ years in data analytics, ideally within a related healthcare or health tech field.
- Requires a track record of success in a high-velocity environment and a strong technical aptitude for simplifying and scaling complex data assets to support long-term standardization.
- Demonstrated project management skills, with the ability to prioritize tasks, manage timelines, and drive cross-functional collaboration.
- Strong communication skills, with the ability to translate technical findings into clear, actionable recommendations for non-technical stakeholders.
- Hybrid employees are expected to be in the office two days per week.
