Data Analyst - TMSIS

MPHI is a Michigan\-based and nationally engaged, non\-profit public health institute. We are a team of teams, process and content experts, dedicated to building *A world where tomorrow is healthier than today!* **Title:** Data Analyst \- TMSIS $53,768\.00 \- $90,958\.40 / Posted Thru: 7\-1\-2026 **Location:** Remote/Virtual – Must work and live in the State of Michigan **Purpose:**Work within the Financing, Analytics, and Data Governance Division and Health Services Administration (HSA) to assist staff with functions and tasks related to the continuing development and operation of the **T**ransitional **M**edicaid **S**tatistical **I**nformation **S**ystem (TMSIS) report program with the Centers for Medicare and Medicaid Services (CMS). **Duties****and Responsibilities:** =================================== * Utilize the CHAMPS Data Warehouse and other relational database products to perform investigative studies and remedial solutions to TMSIS\-processed data as provided by CMS in the monthly Data Quality Tracking Report. * Analyze data in the current TMSIS file layout version and identify data mapping improvements and accuracy solutions. This includes obtaining CMS required data not currently accessible in the CHAMPS Data Warehouse. * Produce extracts using T\-MSIS submissions and the CHAMPS Data Warehouse to respond to ad hoc requests from internal and external stakeholders. * Help in the preparation of responses to questions from CMS/Mathematica as required. * Meet with CMS and affiliated contractors to provide updates on data quality assessments and other TMSIS priorities. * Perform investigative analysis on the TMSIS Analytic Files (TAF) outputs including, but not limited to, the Per Capita Expenditure Report and the Behavioral Health Conditions reports. * Assist in preparing Source\-To\-Target (S2T) revisions as required from changes or additions to TMSIS reporting requirements. * Create quality assurance queries based on CMS data validation rules to analyze and identify errors prior to monthly submissions. * Always represent the best interest of MPHI and MDHHS. * All other duties as assigned. **Qualifications/Requirements:** ================================ **Education:** Bachelor’s Degree, business, data, or IT fields preferred. **Experience:** Prior experience in health care\-related field preferred. **Important****Skills****and Characteristics:*** Knowledge of various relational databases and software applications and products such as Teradata SQL Assistant, BI Query, Azure DevOps, and Microsoft Office applications. * Effective oral and written communication skills including business and technical documentation. * Curiosity and problem\-solving skills. * Ability to perform within a multi\-person workgroup setting. * Ambitious, self\-directed, and self\-motivated. **Work Environment and Physical Requirements:** Job may require moderate physical effort including lifting materials and equipment o