Senior SQL & Python Data Analyst - Healthcare

CareConnectMD; Costa Mesa (CA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

CareConnectMD seeks a skilled SQL developer with Python scripting experience for healthcare data analysis and modeling. The role focuses on SQL, Python, Power BI, and CMS/Value Based Care related data (CCLF) with EMR data.

The candidate should be local to Costa Mesa and able to work onsite 1-2 days per week; a hybrid schedule may be offered at the hiring manager’s discretion. Responsibilities include building end-to-end data models, producing reports, dashboards, and ensuring data quality and

Qualifications

• Bachelor’s degree in computer science, IT, or related field or equivalent practical experience.
• Six+ years of experience in Medicare Shared Savings Program and healthcare data environments.
• Strong understanding of CCLF claims and EMR data structures.
• Proficiency in backend tech: Node.js, Python, Ruby, Java, or .NET.
• Experience with database systems: Azure, SQL, MySQL.
• Expertise in reporting and data visualization using Power BI in healthcare.

Responsibilities

• Estimate impact with retrospective analyses (LOS, readmissions, mortality, reimbursement).
• Build end-to-end data modeling of clinical and claims data.
• Productionize reusable SQL code to meet business requirements.
• Develop, test, and maintain Power BI reports using EMR, claims, and external data sources.
• Collaborate with cross-functional teams to design and deliver new reports and dashboards.
• Create comprehensive reports and visualizations to support decision making.
• Ensure performance, quality, and reliability of reporting tools.
• Stay updated on healthcare regulations and industry trends.
• Participate in code reviews and continuous improvement.
• Ensure compliance with HIPAA and healthcare standards.

Skills

SQL

Python

Data analysis

Data modeling

Power BI

SSRS

Qlik

EMR data

CCLF

CMS

Azure

MySQL

Node.js

Ruby

Java

.NET

Docker

Kubernetes

Jenkins

Github

Education

Bachelor’s degree in Computer Science / IT or related field

Tools

Azure

SQL

MySQL

Power BI

SSRS

Qlik

Data Factory

Docker

Kubernetes

Jenkins

Github

Job description

CareConnectMD seeks a skilled SQL developer with Python scripting experience for healthcare data analysis and modeling. The role focuses on SQL, Python, Power BI, and CMS/Value Based Care related data (CCLF) with EMR data.

The candidate should be local to Costa Mesa and able to work onsite 1-2 days per week; a hybrid schedule may be offered at the hiring manager’s discretion. Responsibilities include building end-to-end data models, producing reports, dashboards, and ensuring data quality and