SQL Prompt Engineer Analyst

Responsibilities

• 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
• Create data visualizations of medical data points and clinical indicators
• Use prompt engineering to create advanced prompts for medical record research and extractions using Claude or OpenAI
• Collaborate with medical and clinical staff to create efficiencies in medical case review processes
• Lead initiatives on advancements in clinical policy building and automation
• Collaborate with data science and engineering teams on clinical case needs

Requirements

• BS or MS in Healthcare, technical degree, or equivalent experience
• 3-5 years of advanced SQL experience
• 2-3 years of healthcare experience
• Proficiency with Spark SQL
• Intermediate to advanced understanding of medical charts and health insurance claims
• Intermediate understanding of prompt engineering
• Experience using Claude or OpenAI for complex medical record identification
• Strong interpersonal communication skills

Benefits

• Work from anywhere in the US (digital-first)
• Full Medical, Dental, and Vision for employees and families
• Unlimited FTO
• Competitive salary and equity
• 401(k) with employer match

About the Company

Machinify is a leading healthcare intelligence company that delivers value, transparency, and efficiency to health plan clients through an AI-powered platform.