SQL Engineer, Analyst

Machinify

SQL Prompt Engineer Analyst transforming complex healthcare claims data into powerful insights for business strategies. Collaborating with teams to enrich ML and analytics initiatives.

Posted 6/27/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $140,000 - $170,000 per yearWebsite

Tech Stack

Tools & technologies

SparkSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLSpark SQLdata visualizationprompt engineeringdata extractiontroubleshootingdata table constructionmedical data analysisclinical calculatorsautomation

Soft Skills

interpersonal communicationcollaborationindependent workproblem-solvingleadership

Certifications

BS in HealthcareMS in Healthcaretechnical degree