Data Analyst - Healthcare

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 relatedR 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.