Automation and Reporting Analyst II

Overview

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.

• 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.

• 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, Num Py) and automation scripts. Ability to write reusable functions and modular scripts.
• Git Proficiency:
  Demonstrated experience using Git/Git Hub 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.

This is a hybrid position based out of our Lehi office
, with the expectation of being in office at least two weekdays per week.

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

Lehi, UT Pay Range

$75,200—$93,750 USD

• 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-accomm

For more information about why we need your data and how we use it, please see our privacy policy: