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.
