Senior Data Analyst (SQL Expertise)

United Hospital Fund; New York (NY); On-site; USD 95,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

403b retirement plan

Paid time off

Commuting subsidy

Job summary

United Hospital Fund in New York, NY seeks a Senior Data Analyst with strong SQL expertise to architect and execute data transformations for Medicaid initiatives. You will translate complex claims and HRSN data into clean, analysis-ready datasets that drive health equity for New Yorkers.

This role emphasizes building scalable SQL infrastructure, data governance, and collaboration with policy stakeholders to deliver actionable insights and front-end visualizations.

Qualifications

• 4+ years of advanced SQL development on large healthcare/claims datasets.
• Experience transforming Medicaid or health data into analysis-ready datasets.
• Strong understanding of data quality, governance, and reproducible workflows.
• Ability to translate technical concepts for non-technical policy stakeholders.
• Professional experience with Git/GitHub and technical documentation.

Responsibilities

• Architect complex SQL queries, stored procedures, and data pipelines for Medicaid datasets.
• Develop automated ETL workflows to ensure data readiness and quality.
• Perform data governance tasks and maintain version-controlled codebase.
• Create metrics to measure quality improvements and health equity outcomes.
• Collaborate with stakeholders to translate data into dashboards and narratives.

Skills

SQL Proficiency

Data Scale Experience

Healthcare Domain Knowledge

Engineering Mindset

Reproducibility with Git

Communication Skills

Education

Bachelor's degree in Data Science/CS/Health Informatics

Master’s degree or relevant certifications

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 Data Analyst (SQL Expertise)

New York, New York, NY, US

2 days ago Requisition ID: 1052

Salary Range: $95,000.00 To $110,000.00 Annually

Improving Health Care for Every New Yorker

United Hospital Fund (UHF) is dedicated to creating an effective and equitable healthcare system for all New Yorkers. As an independent nonprofit, we analyze public policy, unite diverse stakeholders, and support innovative programs to improve health and healthcare. Our mission includes breaking down barriers in health policy and delivery to ensure equitable health opportunities. UHF’s emerging new line of Medicaid work seeks to achieve this vision by bridging and advancing quality and equity and supporting the delivery of health-related social needs (HRSN) screening and services.

About the Role:

We are seeking a technically-driven Senior Data Analyst with expertise in SQL to architect and execute data transformations for our Medicaid initiatives. This role is not just about analyzing data—it’s about building the robust, scalable SQL infrastructure that translates complex claims and HRSN data into actionable insights. You will be responsible for turning "messy" administrative data into clean, analysis-ready datasets that drive health equity for all New Yorkers.

Key Responsibilities:

• Advanced SQL Development: Architect complex SQL queries and stored procedures to perform high-volume data cleaning, transformation, and aggregation. You will help build and maintain the department’s primary codebase, ensuring efficiency when working with millions of records.
• Data Pipeline & ETL Optimization: Develop automated workflows to detect and address data quality issues. You will be one of the "owners" of data readiness, ensuring that Medicaid claims and other administrative data are structured for rapid analysis.
• Technical Data Governance: Perform code reviews and implement rigorous version control (Git) and documentation standards. You will ensure the reproducibility of results through advanced programming techniques in SQL.
• Metric Architecture: Write sophisticated SQL code to calculate quality improvement metrics, equity outcomes, and disparities across physical and behavioral health service delivery.
• Visualization: Collaborate with stakeholders as needed to translate backend data into front-end visualizations and narratives, bridging the gap between raw data and executive decision-making.

Required Qualifications:

• SQL Proficiency: Minimum of 4+ years of experience writing advanced SQL (e.g., complex joins, CTEs, window functions, and query optimization) within cloud-based platforms.
• Data Scale Experience: Proven track record of managing and transforming datasets exceeding one million records.
• Healthcare Domain Expertise: Deep understanding of health data (Medicaid claims, provider networks, or clinical data) and the specific nuances of healthcare data quality.
• Engineering Mindset: A passion for writing clean, modular, and reusable code. You should enjoy solving "puzzle-like" data transformation challenges.
• Reproducibility: Professional experience with Git/GitHub and creating thorough technical documentation.
• Communication: Ability to explain technical data architecture to non-technical policy experts.

Preferred Qualifications:

• Education: Bachelor’s degree in Data Science, Computer Science, Health Informatics, or a related quantitative field. Additional relevant education, training, or experience, including Master’s degree in relevant field, coding bootcamps, or advanced technical certifications is preferred.
• R Programming: Ability to create advanced (e.g., nested, higher-order) functions in R.
• Visualization: Proficiency in Tableau or other data visualization and dashboard tools.
• Social Determinants Knowledge: Experience working with HRSN (Health-Related Social Needs) or Census data.
• SQL Programming sample (Please provide a sample that demonstrates your ability to join and transform complex datasets).

Salary Range: $95,000 – $110,000

Compensation and Benefits: United Hospital Fund offers a competitive salary commensurate with experience combined with generous benefits, including health, dental, voluntary vision, life, and disability insurance; a 403b retirement plan; paid time off; a commuting subsidy; collegial environment.

United Hospital Fund is an Equal Opportunity Employer committed to cultivating a diverse and inclusive workplace. Applicants receive consideration for employment without regard to race, creed, color, ethnicity, national origin, religion, sex, sexual orientation, gender identity, gender expression, age, physical or mental ability, veteran status, military obligations, citizenship, and marital status. People of color, all faiths and abilities, women, immigrants, veterans, LGBTQIA2S+ people, and those with lived experiences in the communities we serve, are strongly encouraged to apply to join our team.