← Back to jobsJob ID col-cmwf2eqdp00na89hq2cr5wylh

New York State Technology Enterprise Corporation (NYSTEC)Posted 9 days ago

Consultant- Data Analyst

Full-time
Hybrid
2+ years
$73K – $96K/yr
Posted 9 days ago

NYSTEC is hiring a Consultant–Data Analyst to support a Social Adult Day Care Compliance Surveillance Program and its oversight of Managed Long Term Care plans. The role supports daily data operations through validation, performance measurement, reporting, database and dashboard maintenance, and process improvement.

Non Profit

ConsultingIT ConsultingData ConsultantOPT / sponsorship mentioned
Posted
9 days ago
Source
nystec.rec.pro.ukg.net
Sector
Consulting

Opens the employer's application page in a new tab

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

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
  • 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
  • Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future

Preferred

  • 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

Required skills

DBeaverData Matching and ReconciliationHTMLMicrosoft ExcelMicrosoft SQL ServerPower BIPythonRelational DatabasesSQLTableauVBA

Full job description

NYSTEC is hiring a Consultant–Data Analyst to support a Social Adult Day Care Compliance Surveillance Program and its oversight of Managed Long Term Care plans. The role supports daily data operations through validation, performance measurement, reporting, database and dashboard maintenance, and process improvement.

Non Profit

  • Information Technology
  • Charity
  • & 2 connections

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

Preferred

  • 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

Benefits

  • Hybrid work arrangement

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
  • 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
  • Applicants must be authorized to work in the United States without the need for visa sponsorship now or in the future
  • 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
  • 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.

Required skills

  • DBeaver, Data Matching and Reconciliation, HTML, Medicaid Claims and Healthcare Data Analytics, Microsoft Excel, Microsoft SQL Server, NYS Medicaid Data Warehouse (MDW), Power BI, Python, Relational Databases, SQL, Tableau, VBA

Experience

  • 2+ years

Company

  • Government technology consulting and advisory services.
  • Rome, New York, USA
  • https://www.nystec.com

Job details

Employment type

Full-time

Seniority level

2+ years

Sector · Sub-sector

Consulting · IT Consulting

Date posted

Nov 11, 2026

Work mode

Hybrid

Job source

nystec.rec.pro.ukg.net

Company

New York State Technology Enterprise Corporation (NYSTEC)

Consulting

Government technology consulting and advisory services.

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Consultant jobs in Albany

ZS

1w ago

Real-World Data (RWD) Consultant

Full-timeHybridNew York, NYCompetitive

Responsibilities Leverage quantitative skills to derive answers to clients' ongoing business analytics and reporting questions Work collaboratively with clients to ascertain the client’s specific business information needs Execute a specific plan for…

Why similarSame roleTableauNew York

Excella

1w ago

Senior Consultant Data Scientist

Full-timeRemoteUnited States$111K – $165K/yr

Excella is hiring a Senior Consultant Data Scientist to deliver analytics solutions for client projects using statistical, machine learning, and data visualization techniques.

Why similarSame rolePythonRemote

Optum

1w ago

Health Data Analytics Consultant

Full-timeRemoteUnited States$92K – $164K/yr

Optum Serve Consulting/The Lewin Group is a health care and human services consulting and policy analysis firm.

Why similarSame rolePythonRemote

Get new Data Consultant jobs in Albany by email

Create job alert

Consultant- Data Analyst

New York State Technology Enterprise Corporation (NYSTEC) · $73K – $96K/yr

Apply on company site