Skip to main content
NYSTEC logo

Consultant- Data Analyst

NYSTEC

Multiple U.S. locationsJob$73–96K/yrSeen 1w agoIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$73–96K/yr
Location
Multiple U.S. locations
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

The consultant–data analyst will support NYSTEC’s Social Adult Day Care Compliance Surveillance Program and its oversight of Managed Long Term Care plans. Reporting to the quality improvement lead, the role supports daily data operations through validation, performance measurement, and reporting. The consultant will investigate data-quality issues, reconcile information across sources, and help maintain databases, dashboards, and reporting tools.

Skills & qualifications

RequiredNice to have

Skills

Advanced Microsoft Excel, requiredVBA, requiredSQL, requiredRelational Data, requiredData Reconciliation, requiredData Matching, requiredBusiness Rules, requiredAnalytical Problem-Solving, requiredTroubleshooting, requiredDocumentation, requiredCommunication, requiredMicrosoft SQL Server, nice to haveDBeaver, nice to haveMedicaid Data Analysis, nice to haveHealthcare Data Analysis, nice to haveHealthcare Compliance, nice to haveQuality Improvement, nice to haveRegulatory Surveillance, nice to haveHTML, nice to havePower BI, nice to haveTableau, nice to havePython, nice to haveData Visualization, nice to haveDashboard Development, nice to haveData Automation, nice to have

Qualifications

Two Years Related Experience, requiredBachelor's Degree or Equivalent, required

Full job description

Pay or shift range: $73,476 USD to $95,518 USD

This is the target starting salary range for this position. When determining compensation, we analyze and carefully consider several factors, including skill set, experience, location, and job-related qualifications.

Description

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 [email protected] 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.

How this job compares

Set against the 4,541 open Data Analyst jobs on Olive Jobs, counted November 19, 2026.

Pay
  • This posting$73–96K/yr
  • New York median$88–125K/yr296 salary ranges
  • US median$85–130K/yr3,159 salary ranges

This range's midpoint, $84K, is 21% below the New York median midpoint ($107K) — in the lowest quarter of Data Analyst salary ranges in New York.

Openings
Olive Jobs lists 364 open Data Analyst jobs in New York and 4,541 across the US. 8% of them nationwide are listed as remote or flexible.
Hiring the most in New York
Experience
This posting asks for at least 2 years of experience; Data Analyst postings that state a minimum ask for 3 years at the median (3,567 postings).
Education
1,762 of the 4,541 open Data Analyst jobs (39%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 19, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.