Senior Consultant- Data Analyst

New York State Technology Enterprise Corporation (NYSTEC); City of Albany (NY); Sur place; USD 84 000 - 110 000; Plein temps

Résumé du poste

NYSTEC is seeking a senior data analyst/consultant to collaborate with cross-functional teams on Medicaid data quality and reporting initiatives. You will document data requirements, define source-to-target mappings, and develop SQL-based validation processes for high-priority T-MSIS measures.

You will analyze complex MDW data, apply statistical techniques, and ensure alignment with data quality objectives while supporting stakeholders with clear technical specifications.

Qualifications

• BA/BS in a relevant field with 5+ years of data analysis experience.
• Experience translating business requirements into technical specifications and data mapping logic.
• Strong SQL skills and experience with data warehousing concepts and data validation techniques.

Responsabilités

• Analyze and document business and data requirements to support high-priority T-MSIS data quality initiatives.
• Identify and map MDW data sources to T-MSIS data elements and quality measures.
• Develop and document business rules, data definitions, and data transformation processes to support accurate reporting and analysis.
• Write and refine SQL queries to support data mapping, analysis, and validation.
• Collaborate with stakeholders to gather requirements, address data discrepancies, and ensure data accuracy.
• Analyze and evaluate data to identify quality issues, inconsistencies, and opportunities for improvement.
• Maintain clear documentation of business requirements, data mappings, processes, and decisions.
• Apply statistical analysis to identify trends, anomalies, and outliers that support data quality improvements.
• Assist in prioritizing and refining requirements as project needs evolve.

Connaissances

Advanced SQL

Data analysis

Data mapping

Stakeholder communication

Data quality

Requirements gathering

Formation

Bachelor's degree in data science, computer science, statistics, mathematics, health informatics, information systems, economics

Outils

SQL

Description du poste

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 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 senior consultant- data analyst in the Data Services and Management practice area, you will collaborate with team members to support data quality and reporting initiatives by defining and documenting data requirements, business rules, and source-to-target mappings for high-priority Transformed Medicaid Statistical Information System (T-MSIS) data quality measures.

Serving as a data analyst, your day-to-day role as a NYSTEC consultant will combine business analysis and technical data expertise to analyze complex Medicaid Data Warehouse (MDW) data, perform statistical analysis, and develop SQL queries to support data mapping and validation. You will collaborate with business and technical stakeholders to ensure data requirements are accurate, clearly documented, and aligned with T-MSIS reporting and data quality objectives.

Key Responsibilities

• Analyze and document business and data requirements to support high-priority T-MSIS data quality initiatives.
• Identify and map Medicaid Data Warehouse (MDW) data sources to T-MSIS data elements and quality measures.
• Develop and document business rules, data definitions, and data transformation processes to support accurate reporting and analysis.
• Write and refine SQL queries to support data mapping, analysis, and validation.
• Collaborate with business stakeholders, technical teams, and subject matter experts to gather requirements, address data discrepancies, and ensure data accuracy.
• Analyze and evaluate data to identify quality issues, inconsistencies, and opportunities for improvement.
• Maintain clear documentation of business requirements, data mappings, processes, and key decisions.
• Apply statistical analysis techniques to identify trends, anomalies, and outliers that support data quality improvements.
• Assist in prioritizing and refining requirements as project needs evolve.

About You

Required Qualifications

• Demonstrated experience performing both business analyst (BA) and data analyst (DA) responsibilities, including requirements gathering, documentation, and technical data analysis.
• Advanced SQL skills, including experience writing and analyzing complex queries across relational data sources.
• Experience with data mapping, source-to-target analysis, data definitions, and business rule documentation.
• Experience analyzing large, complex datasets to identify relationships, discrepancies, and data quality issues.
• Ability to translate business requirements into detailed technical specifications and data mapping logic.
• Understanding of data warehousing concepts, relational databases, and data validation techniques.
• Advanced analytical, problem-solving, and organizational skills, with attention to detail.
• Experience applying statistical analysis techniques to evaluate data quality and support data validation efforts.
• Effective written and verbal communication skills, including the ability to collaborate with business and technical stakeholders.

Preferred/Desired Qualifications

• Experience working with Medicaid, healthcare, or other complex government data environments.
• Familiarity with the Transformed Medicaid Statistical Information System (T-MSIS), including T-MSIS file structures, data elements, and reporting requirements.
• Experience with Medicaid Data Warehouse (MDW) environments or similar enterprise data repositories.
• Knowledge of data quality measurement, monitoring, and reporting methodologies.
• Experience developing or validating SQL-based data transformation and mapping logic.
• Familiarity with CMS Medicaid data reporting requirements and data quality standards.
• Experience working on initiatives involving large-scale data mapping, requirements traceability, or data quality improvement.

Education and Experience

• A bachelor's degree in data science, computer science, statistics, mathematics, health informatics, information systems, economics and at least five years of related experience in data analysis, healthcare analytics, data querying, business intelligence, or a similar role.
• 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 [e-mail] 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.