Full Job Description
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.
Application Details
Applicants can apply for the Senior Data Analyst position by visiting our career page https://uhfnyc.org/about/careers/
Required Documents:
• Resume
• Cover letter
• 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.
