Medicaid Reimbursement Data Analyst

Myers and Stauffer; Kansas City (MO); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

Health insurance

Paid holidays

Parental leave

401K

Job summary

Myers and Stauffer is seeking a Staff Analyst (entry level to a few years of experience) to analyze Medicaid provider claims and payments, support reimbursement system design, and contribute to the efficient operation of state Medicaid programs. You will work with SQL, Alteryx, and PowerBI to generate actionable insights and prepare detailed reports.

You will receive training and mentorship in Medicaid reimbursement concepts while building and validating data extraction logic and ensuring data

Qualifications

• Bachelor's degree in accounting, finance, health policy, health care administration, health information, criminal justice or related field.
• Experience with SQL and large-dataset analysis.
• Interest in Medicaid concepts such as DRG, ACR, UPL, DSH, GME, and directed payments.

Responsibilities

• Use SQL, Alteryx, PowerBI, or similar tools to analyze large datasets and develop actionable recommendations.
• Prepare, interpret, and distribute analytical reports and written summaries.
• Build SQL queries, build data extraction logic, and validate data used in reimbursement calculations.
• Conduct research to determine billing and reimbursement compliance with Medicaid or other government regulations.
• Assist in designing and maintaining Medicaid payment methodologies for hospitals, physicians, and other healthcare providers.
• Review Federal and State policies, regulations, and statutory language and apply them to analytical work.
• Participate in evaluating client-identified issues or problems and contribute to development of solutions.
• Work iteratively by incorporating team feedback, validating assumptions, and refining analyses.
• Maintain accurate, organized electronic documentation.
• Maintain strict confidentiality and security of protected health information.
• Receive structured training and hands-on mentorship in Medicaid reimbursement concepts.
• Assist in developing and documenting Medicaid reimbursement models (e.g., hospital DRG/EAPG/APC, outpatient fee schedules, ACR-based methodologies, UPL demonstrations).
• Support analysis of large Medicaid claims datasets and Medicare/Medicaid cost reports to calculate rates and evaluate fiscal impacts.
• Help review and contribute to State Plan Amendments (SPAs), CMS RAIs, and related regulatory submissions.
• Participate in preparing technical documentation, methodology descriptions, and client deliverables.
• Participate in structured problem-solving sessions to diagnose data issues, interpret policy requirements, and refine analytic approaches.
• Perform additional responsibilities as assigned

Skills

SQL

Alteryx

PowerBI

Data analysis

Healthcare data

Policy interpretation

Education

Bachelor's degree

Job description

Myers and Stauffer is seeking a Staff Analyst (entry level to a few years of experience) to analyze Medicaid provider claims and payments, support reimbursement system design, and contribute to the efficient operation of state Medicaid programs. You will work with SQL, Alteryx, and PowerBI to generate actionable insights and prepare detailed reports.

You will receive training and mentorship in Medicaid reimbursement concepts while building and validating data extraction logic and ensuring data