SQL Prompt Engineer Analyst
TLDR
Transform complex healthcare claims data into actionable insights using SQL/Spark SQL and prompt engineering, driving clinical decisions and policy automation.
Machinify is a leading healthcare intelligence company with expertise across the payment continuum, delivering unmatched value, transparency, and efficiency to health plan clients across the country. Deployed by over 85 health plans, including many of the top 20, and representing more than 270 million lives, Machinify brings together a fully configurable and content-rich, AI-powered platform along with best-in-class expertise. We’re constantly reimagining what’s possible in our industry, creating disruptively simple, powerfully clear ways to maximize financial outcomes and drive down healthcare costs.
We’re seeking a skilled SQL Prompt Engineer Analyst to join our team!
Join our Data Engineering team and help transform complex healthcare claims data into powerful insights that shape business strategy, drive clinical decisions, and support ML and analytics initiatives. You’ll ensure data integrity, and serve as the go-to expert on claims data—bridging the gap between raw data and actionable outcomes.
Does this sound like the right opportunity to explore?... Let's connect!
What You’ll Do
- 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 in the country.
-
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.
- Comfortable leveraging 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
The salary for this position is based on an array of factors unique to each candidate: Such as years and depth of experience, set skills, certifications, etc. The base salary range for this role is $140k-$170k. We are hiring for different levels, and our Recruiting team will let you know if you qualify for a different role/range. Salary is one component of the total compensation package, which includes meaningful equity, excellent healthcare, flexible time off, and other benefits and perks.
Benefits
Equity Compensation
Competitive salary, equity, 401(k) including employer match
Flexible Work Hours
Flexible and trusting environment where you’ll feel empowered to do your best work
Health Insurance
Full Medical/Dental/Vision for employees & their families
Paid Time Off
Unlimited FTO
Remote-Friendly
Work from anywhere in the US! Machinify is digital-first.
Machinify provides healthcare intelligence solutions that enhance transparency and efficiency across the payment continuum for health plans. With an AI-powered platform utilized by top health plans representing over 270 million lives, we simplify complex financial processes to improve outcomes and reduce healthcare costs.