Provider Reporting Analyst II

Medica•Minnetonka, MN

3h•$50,800 - $87,000•Hybrid

About The Position

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.

Requirements

Bachelor's degree or equivalent experience in related field, plus 3+ years of related work experience in data mining and/or reporting beyond degree
Intermediate to Advanced Excel and Access skills required
Basic understanding of SQL
Experience drafting, creating and maintaining reports for various business segments required
Understanding of Access Database queries, exports, table joins
Ability to flex in an ever changing environment
Team work

Nice To Haves

Healthcare/Health Insurance experience preferred
Demonstrated ability to learn and achieve proficiency within a variety of systems required
Familiarity with the following systems/applications preferred; Symfact, Copis, AQT, Access, Service Now, and Toad

Responsibilities

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.