Finance Data Analyst II

Medica; Hopkins (MN); On-site; USD 57,000 - 85,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Paid time off

Job summary

Medica in Hopkins, MN seeks a Medicare Reporting Analyst to lead the analysis, validation, and delivery of Medicare employer and broker reporting. You will serve as a subject-matter expert for Medicare data, platforms, and business rules, ensuring high-quality, client-ready reporting.

The role requires 3+ years’ experience, SQL proficiency, and a strong Excel skill set. Office-based with on-site work 3 days/week near Minnetonka, MN or Madison, WI. Competitive compensation and benefits.

Qualifications

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

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.
• Perform complex analysis of healthcare data, including medical, pharmacy, eligibility, provider, and financial information.
• Serve as a subjectmatter 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 nontechnical stakeholders.

Skills

SQL

Excel

Education

Bachelor's degree or equivalent experience in related field

Tools

SAS

Job description

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 subjectmatter expert for Medicare reporting data, platforms, and business rules, ensuring highquality, clientready reporting.

Key Accountabilities

• 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 highcost claimant, utilization, financial, medical and pharmacy reports.
• Perform complex analysis of healthcare data, including medical, pharmacy, eligibility, provider, and financial information.
• Serve as a subjectmatter 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 nontechnical stakeholders.

Required Qualifications

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

Preferred Qualifications

• SAS
• Familiarity with reporting platforms and vendorsupported analytics tools.
• Experience working with health plans

This position is an Office role, which requires an employee to work onsite, on average, 3 days per week. We are open to candidates located near one of the following office locations: Minnetonka, MN, Madison, WI

The full salary grade for this position is $56,600 - $97,000. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $56,600 - $84,840. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position's scope and responsibility, internal pay equity and external market salary data. In addition to compensation, Medica offers a generous total rewards package that includes competitive medical, dental, vision, PTO, Holidays, paid volunteer time off, 401K contributions, caregiver services and many other benefits to support our employees.

The compensation and benefits information is provided as of the date of this posting. Medica's compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.

Internal Applicants: We're excited about your interest in growing your career at Medica! To be eligible to apply for internal opportunities, employees must have been in their current role for at least one year.

Eligibility to work in the US: Medica does not offer work visa sponsorship for this role. All candidates must be legally authorized to work in the United States at the time of application. Employment is contingent on verification of identity and eligibility to work in the United States.

We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.