Senior Consultant- Data Analyst

NYSTEC is a nonprofit technology consulting company advising agencies organizations institutions and businesses since 1996. Were 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 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.

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

• 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 bachelors 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 $84497.00 to $109846.00 per year. When determining compensation we analyze and carefully consider several factors including skill set experience location and job-related qualifications.

It is NYSTECs 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 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 .

Required Experience:

Senior IC