Provider Reporting Analyst II

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.

The Provider Reporting Analyst II independently manages routine provider data activities and performs moderate data analysis to ensure accuracy and reliability across PNOM systems. This role investigates data issues, identifies root causes, and partners with internal teams to resolve discrepancies. The Analyst II applies judgment within defined guidelines, contributes to process improvements, and supports operational readiness. This position demonstrates growing proficiency and accountability in provider data management.

Performs other duties as assigned.

• Ensure Provider Network Data Accuracy & Consistency
  • Monitor provider data across systems to identify errors or inconsistencies.
  • Perform intermediate analysis to determine root causes of data issues.
  • Resolve data discrepancies through research, correction, and coordination.
  • Maintain documentation supporting data integrity and audit readiness.
• Manage Routine Data Distribution & Interfaces
  • Execute timely provider data distributions to systems and vendors.
  • Validate incoming and outgoing data feeds against specifications.
  • Coordinate resolution of standard interface or file issues.
  • Confirm data updates support directory, claims, and operational accuracy.
• Analyze Data & Identify Trends
  • Conduct recurring and ad hoc analyses to support business needs.
  • Identify patterns, risks, or emerging data issues.
  • Summarize findings with clear insights and recommendations.
  • Share results with operational and technical partners.
• Contribute to Process Improvement Efforts
  • Suggest improvements to existing workflows and controls.
  • Identify opportunities to reduce manual effort or rework.
  • Test and support implementation of approved enhancements.
  • Update procedures to reflect process changes.
• Support Team Knowledge Sharing
  • Answer peer questions related to provider data processes.
  • Review work for completeness and adherence to standards.
  • Share lessons learned to improve team consistency.
  • Serve as a reliable resource within assigned subject areas.
• Other duties as assigned
  • Assist with weekly, monthly and quarterly reporting for the department.
  • Help support the monthly audit of provider data.
  • Create and monitor the provider directory accuracy process for all business segments throughout the year.
  • Collaborate with internal IT partners and external vendors.

• Bachelor's degree or equivalent experience in related field, plus
• 3+ years of related work experience in data mining and/or reporting beyond degree

• Healthcare/Health Insurance experience preferred

Demonstrated ability to learn and achieve proficiency within a variety of systems required

Intermediate to Advanced Excel and Access skills required

Basic understanding of SQL

Experience drafting, creating and maintaining reports for various business segments required

Familiarity with the following systems/applications preferred;
Symfact, Copis, AQT, Access, Service Now, and Toad

Understanding of Access Database queries, exports, table joins

Ability to flex in an ever changing environment

This position is an Office role, which requires an employee to work onsite at our Minnetonka, MN office, on average, 3 days per week.

The full salary grade for this position is $50,800 - $87,000. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $50,800 - $76,125. Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable…