Healthcare Data Analyst

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.