Automation and Reporting Analyst II

💰 $75k-$93k
🇺🇸 United States - Remote
📊 Data🟢 Entry Level

Job description

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 USD

Why 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 [email protected].

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

Share this job:
Please let Collective Health know you found this job on Remote First Jobs 🙏

Similar Remote Jobs

Find Remote Jobs

Connect with top companies hiring for remote jobs, work-from-home roles, and 100% online jobs worldwide.

Discover Hidden Jobs

Unique jobs you won't find on other job boards.

Advanced Filters

Filter by category, benefits, seniority, and more.

Priority Job Alerts

Get timely alerts for new job openings every day.

Manage Your Job Hunt

Save jobs you like and keep a simple list of your applications.

Apply