Health Plan Developer II - BI Reporting

Job Description

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.

Evaluate, design, code, test, optimize and modify Medica's financial or operations systems solutions and reporting capabilities that support multiple lines of Businesses and IT initiatives. Capture, develop, and document data definitions, business rules, and data quality requirements. Conduct data analysis in support of a variety of analytic solutions. Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunities. Performs other duties as assigned.

Key Accountabilities

• Partner with internal business customers to establish and develop relationships, establishing credibility as a key internal resource.
• Use analytic tools such as Power BI and SQL, and other in-house tools to utilize multiple data sources and environments to produce reports to meet needs of business users.
• Develop analytical and reporting specifications for enterprise healthcare projects through participation in project teams or meetings with internal customers.
• Develop and maintain business performance reports for operational business units and produce executive analytic summaries to aid decision-making using various reporting and analytic tools.
• Research subjects surrounding claims, providers, pricing, benefits, government programs or membership, conduct analysis, interpret data, perform data quality checks, identify threats, and present information to internal customers.
• Ability to navigate ambiguous business and data requirements, independently investigate issues, identify appropriate data driven solutions, and communicate recommendations to business partners.
• Participate in team activities to identify problems and improve work processes and systems.

Required Qualifications

• Bachelor's degree or equivalent experience in related field
• 3 years of work experience beyond degree
• Advanced SQL, Power BI, data analysis skills 

  Skills and Abilities

• Experience with cloud-based technologies such as Snowflake strongly preferred.
• Healthcare insurance industry experience or interest.
• Demonstrated examples of taking initiative and being curious with data.

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, or Madison, WI.

The full salary grade for this position is $70,200 - $120,400. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $70,200 - $105,315. 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.

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.