Senior Consultant- Data Analyst

Senior Consultant- Data AnalystNYSTEC 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.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.Key ResponsibilitiesIndependently 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.About YouRequired QualificationsAdvanced 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 QualificationsDirect experience querying or analyzing data from the New York State Medicaid Data Warehouse or other New York State Medicaid data sources.Experience with Medicaid managed care, Managed Long Term Care, or healthcare service utilization analysis.Experience using Python to analyze data or automate recurring extracts, reports, validation activities, or analytical processesEducation and ExperienceA bachelor's degree in data science, computer science, statistics, mathematics, health informatics, information systems, economics or a related discipline and five years of related experience in data analysis, healthcare analytics, data querying, business intelligence, or a similar role.At least three years independently developing complex SQL queries and analyzing large, complex datasets, plus experience analyzing healthcare claims, encounter, or service utilization data.An equivalent combination of advanced education, training, and experience will be considered.The target base salary for this position is $84,497.00 to $109,846.00 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 View email address on click.appcast.io 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. NYSTEC