SQL Engineer, Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
SQL Prompt Engineer Analyst transforming complex healthcare claims data into powerful insights for business strategies. Collaborating with teams to enrich ML and analytics initiatives.
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 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
Similar Jobs
Credit Analyst II
Credit Analyst II making credit decisions and preparing detailed analysis at a private lending company in a fast-paced environment.
Analyst, Current Student
Investment Banking Analyst remote internship for motivated college students. Exposure to M&A processes, financial analysis, and strategic advisory in a collaborative environment.
Senior IT Analyst
Senior IT Analyst managing security policies using Fortinet firewalls at NETCENTER INFORMATICA LTDA. Overseeing network access and collaborating on security improvements.
Junior Media Analyst
Analista de Mídia Júnior/Pleno focado em criar e gerenciar campanhas de mídia paga em LATAM. Colaborando com equipes de marketing para otimização e geração de demanda.
Threat Intelligence Analyst
Threat Intelligence Analyst at Future Technologies Informatica conducting cyber threat data collection and analysis. Involved in identifying trends and supporting cybersecurity reports.
Accounting Analyst
Analista Contábil managing complete accounting routines including balance sheets and client guidance at CONTABILIZAZUL CONTABILIDADE DIGITAL LTDA. Focus on companies operating under Lucro Real.
Legal Controllership Analyst
Legal Analyst in charge of process control, documentation, and support at BRIGANTI SOCIEDADE DE ADVOGADOS. Role requires extensive handling of legal schedules and electronic protocols.
Precertification Analyst
Precertification Specialist responsible for securing insurance authorizations for procedures at CoxHealth. Reviewing patient records and entering information into various systems while collaborating with healthcare providers.
Senior Journey Analyst
Analista de Jornada Sênior working remotely, optimizing customer experiences and ensuring client satisfaction at Aurum, a legal tech company.
Tax Analyst
Analista Fiscal handling tax liabilities and compliance for Audicon Contadores. Involves managing municipal and state declarations, team training, and client support.
Mid-level Tax Analyst
Fiscal Analyst managing diverse client accounts remotely for ALLBATROZ. Ensuring compliance and excellent client communication in tax matters.
Senior Accounting Analyst
Senior Accounting Analyst ensuring compliance with accounting norms at Libbs Farmacêutica, enhancing financial decision-making and reporting processes. Involvement in diverse financial operations and audits.
Monitoring and Observability Analyst, Level 1
Analista de Monitoramento e Observabilidade para integrar o time de tecnologia de uma grande empresa do setor de varejo nacional. Responsável por monitoramento, gestão de alertas e melhoria contínua.
Senior Analyst, Compensation
Senior Analyst, Compensation responsible for advisor support and compensation initiatives at LPL Financial. Collaborating with internal teams to deliver high-quality experiences for financial advisors and clients.
PQR and Litigation Analyst
PQRs and Litigation Analyst at Addi ensuring compliance and timely responses to legal requests. Collaborating with legal and operational teams to enhance internal processes and efficiency.
Analista de Caracterización de Aplicaciones
Analista de Caracterización de Aplicaciones en Stefanini. Documentar aplicaciones y coordinar con equipos para levantar información crítica.
Senior Analyst
Senior Analyst supporting US Government customers in due diligence and supply chain risk management. Requires Ukrainian proficiency and experience in compliance and risk assessment.
Flow Cytometry Analyst
Flow Cytometry Analyst at Labcorp performing analyses of leukemia and lymphoma specimens. Requires Bachelor's degree and clinical lab testing experience with a focus on flow cytometry.
Senior Windows Analyst
Analista Windows Sr focusing on Microsoft infrastructure management and support in Barueri. Ensuring optimal operations for a range of Microsoft and VMware products.
Deal Desk Analyst
Deal Desk Analyst supporting critical power solutions at Anord Mardix. Collaborating with sales and pricing teams to streamline deal structures and approvals.