Automation and Reporting Analyst II

At Collective Health, we’re transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design. As a Health Care Data Analyst, you will serve as a bridge between complex healthcare data and scalable analytical solutions.

You will be responsible for delivering high-impact insights by developing production-ready code and automating data pipelines. You won’t just run reports; you will partner with engineering and product teams to build self-service capabilities via Looker, manage codebase integrity, and ensure our analytics workflows are modular and efficient.

This role is ideal for a technical analyst who views "data as a product" and is passionate about improving healthcare through data excellence.

What You'll Do

Production-Level Development: Write clean, modular, and performant SQL and Python code. Participate in a rigorous QA environment, ensuring all analytical code is version-controlled and peer-reviewed. Pipeline Automation: Design, parameterize, and automate recurring data workflows. Transition manual reporting tasks into automated, scalable pipelines that minimize technical debt.

Strategic Reporting & Delivery: Manage the end-to-end delivery of bespoke reporting assets, ensuring data is actionable and delivered through automated schedules. Self-Service Architecture: Build and maintain scalable data models in Looker. Focus on creating reusable dimensions and measures that empower non-technical users.

Version Control & Governance: Utilize Git for all codebase management, adhering to branching strategies and collaborative development workflows to ensure "single source of truth" reporting. To be successful in this role, you'll need: Experience: At least 2 years of experience in healthcare analytics, with a focus on claims data, or member experience.  Python Competency: Proficiency in Python for data manipulation (e.g., Pandas, NumPy) and automation scripts.

Ability to write reusable functions and modular scripts. Git Proficiency: Demonstrated experience using Git/GitHub for version control, including branching, merging, and resolving conflicts within a team setting. Technical Proficiency: Advanced SQL optimization and experience building scalable models in Looker (LookML) or similar modeling-layer tools.

Automation Mindset: Proven ability to parameterize reports and automate data pipelines to reduce manual intervention. Education: Bachelor’s degree in Computer Science, Mathematics, Statistics, or a related quantitative field. Pay Transparency Statement  This is a hybrid position based out of our Lehi office, with the expectation of being in office at least two weekdays per week. #LI-hybrid The actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity.

In addition to the salary, you will be eligible for 35,000 stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.Lehi, UT Pay Range$75,200—$93,750 USDWhy Join Us? Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare Impactful projects that shape the future of our organization Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests Flexible work arrangements and a supportive work-life balance We are an equal opportunity employer and value diversity at our company.

We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.

Privacy Notice For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.

Collective Health simplifies employee healthcare with an integrated technology and service solution that makes administering company health benefit plans incomparably easier and more insightful than traditional health insurance company solutions. With over a quarter of a million members and over 50 enterprise customers—including Driscoll's, Pinterest, Red Bull, RH, Zendesk, and more—Collective Health is reinventing the healthcare experience for forward-thinking organizations and their people...