About the Role: As a consultant - data analyst in NYSTEC's Data Services Management practice area, you will collaborate with team members to support a Social Adult Day Care (SADC) Compliance Surveillance Program and its oversight of Managed Long Term Care (MLTC) plans. Reporting to the quality improvement (QI) lead, you will support daily data operations, including data validation, performance measurement, and reporting to ensure accurate and efficient program operations.
Serving as a data analyst, your day-to-day role as a NYSTEC consultant will include applying business rules, reconciling data across sources, independently investigating data-quality issues, and identifying practical ways to improve recurring processes. This role will also support the development and maintenance of databases, dashboards, and reporting tools while collaborating with cross-functional teams to deliver accurate insights and improve program operations.
Key Responsibilities
- Process, validate, and analyze structured data submissions using established business rules; run, troubleshoot, and improve Excel/VBA workflows and calculate performance measures and analytical outputs.
- Independently investigate missing, inconsistent, duplicate, or inaccurate data; identify root causes, resolve processing issues, and perform quality checks to ensure reliable outputs.
- Produce recurring and ad hoc findings reports and analytical deliverables; support automated reporting and document-generation processes using Microsoft Excel and Word and communicate key findings clearly.
- Develop and troubleshoot SQL queries to retrieve, update, reconcile, and analyze relational data; support database maintenance, integrity, and repeatable data-processing activities.
- Match and reconcile records across sources using identifiers, names, and addresses, including exact and fuzzy matching; analyze discrepancies, trends, outliers, and potential compliance or performance concerns.
- Develop, maintain, test, and enhance databases, HTML-based dashboards, user interfaces, and reporting tools; identify automation and process-improvement opportunities and document business rules, data logic, and procedures.
About you: Required Qualifications - Advanced Microsoft Excel skills, including experience working with large datasets, formulas, lookups, data validation, data cleansing, pivot tables, and analytical or reporting workbooks.
- Experience developing, maintaining, or troubleshooting VBA macros and Excel-based automated processes.
- Proficiency in writing, modifying, and troubleshooting SQL queries involving multiple tables, joins, filters, aggregations, and common data operations.
- Experience working with relational data and reconciling and validating information from multiple sources, with an understanding of relationships among records, tables, and identifiers.
- Proficiency with data matching and reconciliation, including the use of exact and fuzzy-matching techniques, and the ability to apply established business rules or calculation logic consistently.
- Advanced analytical, independent problem-solving, troubleshooting, documentation, and communication skills; ability to explain findings and collaborate effectively with program and technical teams.
Preferred/Desired Qualifications
- Direct experience querying or analyzing data from the NYS Medicaid Data Warehouse (MDW) or other NYS Medicaid data sources.
- Experience developing more advanced SQL queries against large relational databases or enterprise data warehouses using Microsoft SQL Server, DBeaver, or comparable tools.
- Experience analyzing Medicaid claims, encounter, service utilization, or other healthcare data, or experience supporting Medicaid managed care, MLTC, healthcare compliance, quality improvement, or regulatory surveillance activities.
- Experience developing or enhancing dashboards, data visualizations, or web-based reporting tools using HTML, Power BI, Tableau, or comparable technologies.
- Experience using Python or other scripting tools to automate data processing, validation, or reporting, or to improve data-quality controls and workflow efficiency.
Education and Experience
- A bachelors degree in data science, computer science, statistics, mathematics, health informatics, information systems, economics, or a related discipline and two years of related experience in data analysis, data management, business intelligence, healthcare analytics, or a similar role.
- An equivalent combination of advanced education, training, and experience will be considered.
The target base salary for this position is $73,476 - $95,518 per year. When determining compensation, we analyze and carefully consider several factors, including skill set, experience, location, and job-related qualifications.
Learn more about NYSTEC by visiting www.nystec.com.
