Health Plan Developer II - BI Reporting

Health insurance that's with you, every step of the way.•Minnetonka, MN

2d•Hybrid

About The Position

Medica is a nonprofit health plan serving more than a million members across Minnesota, Nebraska, Wisconsin, Missouri, and beyond. The Health Plan Developer II evaluates, designs, codes, tests, optimizes, and modifies financial or operations systems solutions and reporting capabilities supporting multiple business lines and IT initiatives. The role develops and documents data definitions, business rules, and data-quality requirements; analyzes data for analytic solutions; and interprets results to identify operational impacts, trends, and opportunities. This position partners with internal business customers and project teams to develop reporting and analytic specifications, produce business performance reports and executive summaries, and research healthcare subjects such as claims, providers, pricing, benefits, government programs, and membership. The position is an office role requiring onsite work an average of three days per week. Candidates may be located near the Minnetonka, Minnesota, or Madison, Wisconsin, office.

Requirements

Bachelor's degree or equivalent experience in a related field.
Three years of work experience beyond the degree.
Advanced SQL, Power BI, and data-analysis skills.
Legally authorized to work in the United States at the time of application; employment is contingent on verification of identity and work eligibility.

Nice To Haves

Experience with cloud-based technologies such as Snowflake.
Healthcare insurance industry experience or interest.
Demonstrated initiative and curiosity when working with data.

Responsibilities

Evaluate, design, code, test, optimize, and modify financial or operations systems solutions and reporting capabilities.
Capture, develop, and document data definitions, business rules, and data-quality requirements.
Conduct data analysis in support of analytic solutions; interpret results and provide insights about operational impact, trends, and opportunities.
Partner with internal business customers to establish relationships and serve as a key internal resource.
Use Power BI, SQL, and other in-house tools to work with multiple data sources and environments and produce reports for 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 support decision-making.
Research claims, providers, pricing, benefits, government programs, and membership; conduct analysis, interpret data, perform data-quality checks, identify threats, and present information to internal customers.
Independently investigate ambiguous business and data requirements, identify data-driven solutions, and communicate recommendations to business partners.
Participate in team activities to identify problems and improve work processes and systems.
Perform other duties as assigned.