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. Key Accountabilities 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. Qualifications Bachelor's degree or equivalent experience in related field, plus 3+ years of related work experience in data mining and/or reporting beyond degree Preferred Qualifications 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 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. 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. #J-18808-Ljbffr Medica