SQL Prompt Engineer Analyst

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

Apply for this job