Senior Consultant- Data Analyst

New_Nystec • Albany, NY

1d

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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.

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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior