Senior Healthcare Data Analyst & SQL Specialist

NYSTEC; City of Albany (NY); On-site; USD 84,000 - 110,000; Full time

Job summary

NYSTEC is seeking a Senior Data Analyst to join the Data Services Management practice. You will work on a large-scale healthcare data project, using SQL to query, analyze, and validate data, and develop reusable datasets and reports.

The role focuses on identifying trends, gaps, and performance concerns, while collaborating with project teams to review query logic and provide guidance to peers. Strong Excel and data documentation skills are essential.

Qualifications

• Advanced SQL and complex query development across multiple tables.
• Experience with large relational databases or data warehouses.
• Healthcare data analysis experience to answer program questions.
• Ability to validate queries and outputs for accuracy and completeness.
• Advanced Excel skills and ability to produce analytic files and reports.
• Strong communication and documentation to explain data logic and findings.

Responsibilities

• Develop, execute, troubleshoot, and maintain complex SQL queries for Medicaid data.
• Translate program questions into data specifications and outputs.
• Compare data with service plans, create review universes, and analyze utilization.
• Identify trends, gaps, and potential compliance or performance concerns.
• Develop reusable queries, data extracts, datasets, and data dictionaries.
• Perform quality checks and peer reviews, communicating results clearly.

Skills

Advanced SQL

SQL Server

Healthcare analytics

Excel

Data validation

Communication

Education

Bachelor’s degree in data science or related

5 years data analytics experience

Tools

DBeaver

SQL Server

Python

Job description

NYSTEC is seeking a Senior Data Analyst to join the Data Services Management practice. You will work on a large-scale healthcare data project, using SQL to query, analyze, and validate data, and develop reusable datasets and reports.

The role focuses on identifying trends, gaps, and performance concerns, while collaborating with project teams to review query logic and provide guidance to peers. Strong Excel and data documentation skills are essential.