About Us:
NYSTEC is a nonprofit technology consulting company, advising agencies, organizations, institutions, and businesses since 1996. We’re independent and vendor-neutral, so we have our clients’ best interests at heart. At NYSTEC, we know that we succeed when individuals and teams flourish personally and professionally, so our benefits and perks support that mindset.
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.
It is NYSTEC's policy to provide equal employment opportunity (EEO) to all individuals, regardless of actual or perceived race, color, creed, religion, sex, or gender (including pregnancy, childbirth, and related medical conditions), gender identity or gender expression (including transgender status), age, national origin, ancestry, citizenship status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, military service and veteran status, sexual orientation, marital status, or any other characteristic protected by local, state, or federal laws and ordinances. NYSTEC is strongly committed to this policy and believes in the concept and spirit of the law.
Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please contact recruitment@nystec.com if you require a reasonable accommodation to apply for or to perform this job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.
Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future.
Learn more about NYSTEC by visiting www.nystec.com.