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

403(b) retirement plan

Paid time off

Commuting subsidy

Job summary

United Hospital Fund in New York is seeking a Senior Data Analyst with SQL expertise to architect and deliver data transformations for our Medicaid initiatives. You will build scalable SQL infrastructure to convert complex claims and HRSN data into actionable insights, turning messy administrative data into clean datasets for health equity.

The role emphasizes high-volume data handling, data governance, collaboration with stakeholders, and translating backend data into informative visualizations

Qualifications

• 4+ years of experience writing advanced SQL (joins, CTEs, window functions) on cloud platforms.
• Experience transforming datasets exceeding one million records.
• Deep understanding of health data (Medicaid claims, provider networks, clinical data).
• Engineering mindset with clean, modular, reusable code.
• Experience with Git/GitHub and technical documentation.
• Ability to explain technical data architecture to policy experts.

Responsibilities

• Architect complex SQL queries and stored procedures for data cleaning and transformation.
• Develop automated ETL workflows to ensure data readiness.
• Perform code reviews and maintain version control and documentation.
• Write SQL to calculate quality improvement metrics and equity outcomes.
• Collaborate with stakeholders to translate backend data into visualizations.

Skills

SQL proficiency

Data transformation

Healthcare data

Engineering mindset

Git/GitHub

Communication

Education

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

Master’s degree preferred

Tools

GitHub

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

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