Senior SQL Developer

CareConnectMD, Inc.; Costa Mesa (CA); On-site; USD 130,000 - 150,000; Full time

Job summary

CareConnectMD, Inc. is seeking a Senior SQL Developer to join our Costa Mesa office. The role emphasizes SQL, Python scripting, data analysis, and data modeling across clinical and claims data, with Power BI reporting from EMR, claims, and external data sources.

The candidate should have 6+ years in healthcare data environments, knowledge of CMS/Value Based Care programs, and be able to work onsite 1–2 days per week as needed.

Qualifications

• Bachelor's degree or equivalent practical experience.
• 6+ years of experience with Medicare Shared Savings Program.
• Strong understanding of CCLF claims and EMR data structures.
• Proficiency with back-end technologies such as Node.js, Python, Ruby, Java, or .NET.
• Experience with Power BI in healthcare.

Responsibilities

• Estimate impact with retrospective analyses (LOS, readmissions, mortality, reimbursement).
• Contribute to end-to-end data modeling of clinical and claims data.
• Produce efficient, reusable SQL code to meet business needs.
• Develop, test, and maintain Power BI reports from EMR, claims, and external data.
• Collaborate with cross-functional teams to design new reports and dashboards.
• Create data visualizations to support decision-making.
• Ensure performance, quality, and responsiveness of reporting tools.
• Stay updated on healthcare regulations and HIPAA compliance.
• Participate in code reviews and continuous improvement.

Skills

SQL

Python

Data modeling

Data analysis

Power BI

SSRS

Qlik

Healthcare data

Education

Bachelor's degree in CS/IT or related field

Tools

Azure

SQL

MySQL

Node.js

Java

Ruby

.NET

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior SQL Developer

Full Time Professional Costa Mesa, CA, US

3 days ago Requisition ID: 1102

Salary Range: $130,000.00 To $150,000.00 Annually

Position Overview:

We are seeking a strong skilled SQL developer with python scripting experience in the healthcare industry. The ideal candidate should have several years of experience in data analysis and data modeling using SQL, Python, and data visualization tools such as PowerBI, SSRS, Qlik. Experience with CMS (Center for Medicare and Medicaid) and Value Based Care programs is highly preferred with an emphasis on knowledge with claims data (CCLF) and electronic medical records (EMRs). This is not a data engineer position.

Candidates must be local to Costa Mesa, CA and able to work onsite in the Costa Mesa office 1–2 days per week, at the discretion of the hiring manager.

Key Responsibilities:

• Estimate impact with rigorous retrospective analyses (LOS, readmissions, mortality, reimbursement).
• Contribute into building end-to-end data modeling of clinical and claims data.
• Productionize efficient, reusable, and reliable SQL code to meet business requirements and help to define technical requirements as needed.
• Develop, test, and maintain reporting in Power BI driven from electronic medical records data, claims data, HIE data, Salesforce data and other external data sources.
• Collaborate with cross-functional teams to understand and define, design, and deliver new reports, dashboards, features and enhancements.
• Create comprehensive reports and data visualizations using Power BI to support decision-making processes.
• Ensure the performance, quality, and responsiveness of reporting tools.
• Maintain up-to-date knowledge of emerging technologies and industry trends.
• Participate in code reviews and contribute to a culture of continuous improvement.
• Ensure compliance with healthcare regulations and standards, including HIPAA.

Required Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent practical experience.
• Six plus years of experience in working with Medicare Shared Savings Program
• Strong understanding of CCLF claims and EMR data structures.
• Proficiency in back-end technologies such as Node.js, Python, Ruby, Java, or .NET.
• Experience with database management systems such as Azure, SQL, and MySQL.
• Expertise in report writing and data visualization using Power BI in the healthcare industry.
• Strong understanding of healthcare regulations and standards.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to work in the Costa Mesa office 1-2 days per week (at discretion of hiring manager).

Preferred Qualifications:

• Strong understanding of CMS and Value Based Care programs such as MSSP.
• Good understanding with Azure, MySql, MSSQL and Data Factory.
• Knowledge of healthcare interoperability standards (e.g., HL7, FHIR).
• Experience with DevOps practices and tools (e.g., Docker, Kubernetes, Jenkins, Github).
• Familiarity with Agile development methodologies.
• Familiar with LLM and AI technology solutions in healthcare.