SQL Engineer, Analyst

🕒 2 days ago

Apply Now
Find Similar Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Logo of Machinify

Machinify

1001 - 5000 employees

⚕️ Healthcare Insurance

🤖 Artificial Intelligence

☁️ SaaS

💰 $10M Series A - Machinify on 2018-10

Healthcare Insurance • Artificial Intelligence • SaaS

Machinify is a healthcare-focused AI platform and services company that reshapes healthcare payments and payment integrity. Its AI operating system unifies claims, medical records, contracts, and policies, and uses foundation models and task-specific agents to automate and improve coding, payment accuracy, recoveries, and cost avoidance. Machinify serves health plans (including 18 of the top 20), supports insourced, hybrid, or fully-managed deployments, and emphasizes measurable outcomes — reporting 85+ customers, 270M member lives covered, and $6B+ in annual cost avoidance and recoveries.

📋 Description

• 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

• 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

• 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

Apply Now

Similar Jobs

🕒 2 days ago

CVS Health

10,000+ employees

⚕️ Healthcare Insurance

🛒 Retail

🧘 Wellness

Sr. Analyst handling customizations for Aetna's Resources for Living application and Provider Search tools. Collaborating with teams to deliver high-quality digital experiences across platforms.

🕒 2 days ago

Highmark Health

10,000+ employees

⚕️ Healthcare Insurance

🤝 Non-profit

🌍 Social Impact

Associate Managed Care Analyst in charge of managing hospital, professional, and ASC contracts. Collaborating with revenue cycle teams for contract analysis at Highmark Health.

🕒 2 days ago

Prime Therapeutics

1001 - 5000

⚕️ Healthcare Insurance

💊 Pharmaceuticals

☁️ SaaS

Senior Analyst at Prime Therapeutics managing complex pharmacy benefits data analysis and developing strategies for performance improvements. Leading high-complexity projects for the New York Medicaid PDL program.

🕒 2 days ago

Avantor

10,000+ employees

🔬 Science

🧬 Biotechnology

⚕️ Healthcare Insurance

RFP Analyst managing bids, tenders, and proposals for Avantor. Collaborating with sales management and cross-functional teams for accurate and timely submissions.

🕒 2 days ago

University of Arkansas System

10,000+ employees

📚 Education

🏛️ Government

🤝 Non-profit

Senior Application Systems Analyst supporting IT EMR Services at UAMS. Responsible for system applications and providing mentoring to junior analysts and on-call support for application.