Senior Consultant- Data Analyst

• Pay or shift range: $84,497 USD to $109,846 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.

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  NYSTEC, we know that we succeed when individuals and teams flourish personally and professionally, so our benefits and perks support that mindset.

As a senior consultant- data analyst in the Data Services Management practice area, you will collaborate with team members to support a large-scale healthcare data project focused on quality improvement, oversight, and performance monitoring. This role will use SQL to query, analyze, and validate complex healthcare data; develop reusable datasets and reporting outputs; and identify trends, gaps, outliers, and potential performance concerns.

Serving as a data analyst, your day-to-day role as a NYSTEC consultant will include serving as a senior data resource, collaborating with project teams to review query logic, troubleshoot complex data questions, maintain analytical quality, and provide technical guidance to other analysts as needed.

• Independently develop, execute, troubleshoot, and maintain complex SQL queries to extract encounter and other Medicaid data from the Medicaid Data Warehouse using Microsoft SQL Server and query tools such as DBeaver.
• Collaborate with the quality improvement specialist to translate program questions, requirements, and business rules into data specifications, query logic, analytical methods, and repeatable outputs.
• Compare encounter data with person-centered service plan and case review information; create review universes and samples; and analyze utilization by member, service, provider, plan, and time period.
• Identify trends, outliers, gaps, and potential compliance or performance concerns, and support broader or ad hoc MLTC surveillance and oversight activities.
• Develop and maintain reusable queries, validated data extracts, analytical files, recurring reporting datasets, data dictionaries, and technical documentation describing data sources, logic, assumptions, and limitations.
• Perform quality checks and peer reviews to confirm that queries and outputs are accurate, complete, and responsive to the request, and clearly communicate results and technical considerations to project team members.

Required Qualifications

• Advanced SQL proficiency, including experience independently developing and troubleshooting complex queries involving multiple tables, joins, aggregations, transformations, and business rules.
• Experience querying large relational databases or enterprise data warehouses in Microsoft SQL Server or a comparable environment using tools such as DBeaver.
• Experience analyzing healthcare claims, encounter, service utilization, or comparable healthcare data to answer complex program or operational questions.
• Experience validating query logic and analytical outputs for accuracy, completeness, consistency, and alignment with defined requirements.
• Advanced Microsoft Excel skills and experience developing analytical files, recurring extracts, reporting datasets, tables, and other data outputs.
• Strong analytical, critical-thinking, problem-solving, documentation, and communication skills, with the ability to collaborate with business and technical team members and explain data logic, findings, assumptions, and limitations.

Preferred/Desired Qualifications

• Direct experience querying or analyzing data…