Finance Data Analyst II

Medica • Minnetonka, MN

2d • Hybrid

About The Position

Medica is a nonprofit health plan with more than a million members that serves communities in Minnesota, Nebraska, Wisconsin, Missouri, and beyond. We deliver personalized health care experiences and partner closely with providers to ensure members are genuinely cared for. We're a team that owns our work with accountability, makes data-driven decisions, embraces continuous learning, and celebrates collaboration — because success is a team sport. It's our mission to be there in the moments that matter most for our members and employees. Join us in creating a community of connected care, where coordinated, quality service is the norm and every member feels valued. This position is responsible for leading the analysis, validation, and delivery of Medicare employer and broker reporting. This role serves as a subject‑matter expert for Medicare reporting data, platforms, and business rules, ensuring high‑quality, client‑ready reporting.

Requirements

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

Nice To Haves

• SAS
• Familiarity with reporting platforms and vendor‑supported analytics tools.
• Experience working with health plans

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.

Benefits

• competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level