Data Analyst - Healthcare

An independent New York nonprofit working to build a more effective healthcare system is seeking a Data Analyst . A growing new area of its work focuses on Medicaid: advancing quality and equity and supporting the screening and delivery of health-related social needs (HRSN) services.

Our client is looking for 2+ years of deep SQL expertise to build and run the data transformations behind its Medicaid initiatives. You will build robust, scalable SQL infrastructure that turns messy claims and HRSN administrative data into clean, analysis-ready datasets.

Location: New York, NY (3 days/week)

Salary: Up to $110k base + bonus

Responsibilities

• Advanced SQL development. Design complex SQL queries and stored procedures for high-volume data cleaning, transformation and aggregation. Help build and maintain the team's core codebase, working efficiently across millions of records.
• Data pipelines and ETL. Build automated workflows that detect and fix data quality issues. Act as a co-owner of data readiness, making sure Medicaid claims and other administrative data are structured for fast analysis.
• Metric design. Write SQL to calculate quality improvement metrics, equity outcomes and disparities across physical and behavioral health services.
• Visualization and storytelling. Work with stakeholders to turn backend data into visualizations and narratives that support leadership decisions.
• Technical data governance. Run code reviews and apply version control (Git) and documentation standards so results are reproducible.

Requirements:

• 2+ years writing advanced SQL (complex joins, CTEs, window functions, query optimization) on cloud-based platforms.
• Deep understanding of healthcare data, such as Medicaid claims, provider networks or clinical data, and its data quality challenges.
• An engineering mindset: you write clean, modular, reusable code and enjoy solving tricky data transformation problems.
• Ability to explain technical data architecture to non-technical policy experts.

Preferred:

• Bachelor's degree in Data Science, Computer Science, Health Informatics or related
• R programming experience, including nested and higher-order functions.
• Tableau or other data visualization and dashboard tools (Power BI, etc).
• Experience with HRSN (social determinants of health) or Census data.