Medicare Reporting Data Analyst II

Ultipro; Minnetonka (MN); Hybrid; USD 57,000 - 97,000; Full time

Job summary

Medica in Minnetonka, MN is seeking a skilled Analyst to lead the analysis, validation, and delivery of Medicare employer and broker reporting. This role acts as a subject‑matter expert for Medicare reporting data, platforms, and business rules to ensure high‑quality, client‑ready insights.

You will own complex Medicare reports and data feeds, perform in-depth healthcare data analyses, validate data accuracy, and collaborate with business, IT, and vendor teams to modernize reporting solutions.

Qualifications

• Bachelor's degree or equivalent experience in related field.
• 3+ years of work experience beyond degree.
• Experience coding with SQL.
• Excel

Responsibilities

• Lead the development, maintenance, and delivery of Medicare reporting for employers, brokers, and internal stakeholders.
• Own complex recurring and ad hoc Medicare reports and data feeds, including high-cost claimant, utilization, financial, medical and pharmacy reports.
• Perform complex analysis of healthcare data, including medical, pharmacy, eligibility, provider, and financial information.
• Serve as a subject-matter expert for Medicare reporting platforms (e.g., enrollment & claims systems and dashboards).
• Ensure data accuracy, consistency, and timeliness through robust validation, reconciliation, and quality controls.
• Investigate and resolve complex data issues impacting client deliverables or financial reporting.
• Partner with business, IT, and vendor teams to design, enhance, and modernize Medicare reporting solutions.
• Lead process improvements and automation efforts to increase efficiency and reduce operational risk.
• Develop and maintain documentation for report logic, data definitions, assumptions, and dependencies.
• Mentor and provide technical guidance to other analysts, setting standards for quality and best practices.
• Communicate analytical findings clearly to both technical and non‑technical stakeholders.

Skills

SQL

Excel

Education

Bachelor's degree or equivalent experience

Tools

SAS

Job description

Medica in Minnetonka, MN is seeking a skilled Analyst to lead the analysis, validation, and delivery of Medicare employer and broker reporting. This role acts as a subject‑matter expert for Medicare reporting data, platforms, and business rules to ensure high‑quality, client‑ready insights.

You will own complex Medicare reports and data feeds, perform in-depth healthcare data analyses, validate data accuracy, and collaborate with business, IT, and vendor teams to modernize reporting solutions.