Health Plan Developer II - Enterprise Data Reporting

Medica•St. Louis, MO

12h•$70,200 - $105,315•Hybrid

About The Position

Medica is seeking a Health Plan Developer II to evaluate, design, code, test, optimize, and modify financial or operational systems solutions and reporting capabilities supporting multiple lines of business and IT initiatives. The role captures, develops, and documents data definitions, business rules, and data quality requirements; conducts data analysis for a variety of analytic solutions; and interprets results to identify operational impacts, trends, and opportunities. Other duties may be assigned. The position partners with internal business customers and project teams to develop enterprise healthcare reporting and analytic solutions. It uses Power BI, SQL, and other in-house tools to draw on multiple data sources and environments, deliver business and executive reports, and support decision-making. The role also investigates topics such as claims, providers, pricing, benefits, government programs, and membership, performs data quality checks, identifies threats, and communicates findings and recommendations. This 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. Medica does not offer work visa sponsorship; candidates must be authorized to work in the United States at the time of application.

Requirements

Bachelor's degree or equivalent experience in a related field.
Three years of work experience beyond degree.
Proficient user of Power BI and SQL.
Ability to work onsite an average of three days per week.
Must be legally authorized to work in the United States at the time of application; visa sponsorship is not offered.

Nice To Haves

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

Responsibilities

Evaluate, design, code, test, optimize, and modify financial or operational systems solutions and reporting capabilities.
Capture, develop, and document data definitions, business rules, and data quality requirements.
Conduct data analysis, interpret results, and provide insights on operational impact, trends, and opportunities.
Partner with internal business customers to develop relationships and establish credibility as a key internal resource.
Use Power BI, SQL, and other in-house tools to combine multiple data sources and environments and produce reports for business users.
Develop analytical and reporting specifications for enterprise healthcare projects through 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, or membership; conduct analysis, interpret data, perform data quality checks, identify threats, and present information to internal customers.
Navigate ambiguous business and data requirements, investigate issues independently, 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.