Senior Data Analyst (SQL Expertise)

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 focuses on building robust, scalable SQL infrastructure that translates complex claims and HRSN data into actionable insights. Responsibilities include turning administrative data into clean, analysis-ready datasets that advance health equity for all New Yorkers.

Key Responsibilities

• Advanced SQL Development: Architect complex SQL queries and stored procedures for high-volume data cleaning, transformation, and aggregation; maintain the department’s primary codebase for efficiency with millions of records.
• Data Pipeline & ETL Optimization: Develop automated workflows to detect and address data quality issues; ensure Medicaid claims and administrative data are structured for rapid analysis.
• Technical Data Governance: Perform code reviews and implement version control (Git) and documentation standards; ensure reproducibility through advanced SQL programming techniques.
• 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 to translate backend data into front-end visualizations and narratives, bridging raw data and executive decision-making.

Required Qualifications

• Minimum of 4+ years of experience writing advanced SQL (complex joins, CTEs, window functions, query optimization) within cloud-based platforms.
• Proven track record managing and transforming datasets exceeding one million records.
• Deep understanding of health data (Medicaid claims, provider networks, or clinical data) and healthcare data quality nuances.
• Engineering mindset with a passion for writing clean, modular, and reusable code.
• Professional experience with Git/GitHub and creating thorough technical documentation.
• Ability to explain technical data architecture to non-technical policy experts.

Preferred Qualifications

• Bachelor’s degree in Data Science, Computer Science, Health Informatics, or a related quantitative field; additional education or certifications preferred.
• Ability to create advanced functions in R.
• Proficiency in Tableau or other data visualization and dashboard tools.
• Experience working with HRSN (Health-Related Social Needs) or Census data.

Pay

$95,000 – $110,000

Benefits

• Health, dental, voluntary vision, life, and disability insurance
• 403b retirement plan
• Paid time off
• Commuting subsidy
• Collegial environment