# Healthcare Data Analyst
**Company:** [Machinify](https://hotfix.jobs/companies/machinify)
**Location:** Remote
**Salary:** $140K-$170K
**Experience:** 3+ years
**Skills:** SQL, Spark Sql, Claude, OpenAI, Prompt Engineering, Data Visualization, Healthcare Claims Data, Medical Charts, Clinical Reviews
**Posted:** 2026-06-26
> Create advanced SQL/Spark SQL queries and prompt-engineered LLM workflows to transform healthcare claims data into clinical insights and automated policy tools. Requires 3-5 years SQL plus 2-3 years healthcare experience.
## Job Description
## What You’ll Do

### SQL & Data Engineering
- Create advanced SQL and Spark SQL expressions for complex calculators, data extractions, and data table construction.
- Troubleshoot and fix SQL issues within complex queries and transformations.
- Own and maintain libraries of clinical calculators and technical reference definitions used across many top 50 payer clients.
- Create data visualizations of medical data points such as glucose levels, mean arterial pressure, and other clinical indicators.

### Prompt Engineering
- Use prompt engineering to create advanced prompts for medical record research and extractions.
- Leverage Claude / OpenAI to answer complex medical identification questions.
- Troubleshoot and refine prompt logic to improve accuracy and reliability.

### Clinical Collaboration & Delivery
- Collaborate with medical and clinical staff to create efficiencies in medical case review processes.
- Lead initiatives on advancements in clinical policy building and automation.
- Drive sprints regarding new client launches as they relate to clinical policies and clinical case reviews.
- Collaborate with data science and engineering teams on clinical case needs.

## What You Bring

- BS or MS in Healthcare / technical degree or equivalent experience.
- 3-5 years of advanced SQL experience along with 2-3 years of healthcare experience.
- Advanced SQL skills, including the ability to understand and work with Spark SQL.
- Intermediate to advanced understanding of medical charts and the data included in them, and health insurance claims.
- At minimum, an intermediate understanding of prompt engineering.
- Comfortable using Claude / OpenAI to create advanced prompts needed to answer complex medical record identification questions.
- Basic understanding of how clinical reviews operationally work in the medical claims space.
- Ability to work independently once instructions are given.
- Ability to troubleshoot and fix SQL or prompt-related errors within complex queries and prompt statements.
- Strong interpersonal communication skills to collaborate with clinical / medical staff as needed.

## What We Offer

- Work from anywhere in the US. Machinify is digital-first.
- Full Medical/Dental/Vision for employees & their families.
- Flexible and trusting environment where you’ll feel empowered to do your best work.
- Unlimited FTO.
- Competitive salary, equity, 401(k) including employer match.
**Apply:** https://hotfix.jobs/jobs/healthcare-data-analyst-at-machinify-fc9add72-bd2a-4302-9774-f807a2913f51
**Canonical:** https://hotfix.jobs/jobs/healthcare-data-analyst-at-machinify-fc9add72-bd2a-4302-9774-f807a2913f51