Health Plan Developer III

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.

Medica's Enterprise Analytics department is looking for a talented and enthusiastic individual to join our team as a senior business intelligence developer.

The ideal candidate will have significant health insurance experience, strong business intelligence expertise, and excellent communication abilities. You will work directly with our stakeholders to understand requirements for dashboards, reports and analyses.

You should have direct experience with either Power BI or the Qlik Sense BI platform or be willing and able to become proficient quickly. This is a senior level position that will take on complex responsibilities with minimal supervision and will serve as a resource to others on the team. Performs other duties as assigned.

Key Accountabilities

• Build excellent relationships with customers of our team as you work to understand requirements and design solutions for needed dashboards, reports and analyses
• Develop a deep understanding of Medica's data warehouse and other data sources
• Design and develop new dashboards and reporting applications from end to end (data loading/modeling, reports, and visualizations)
• Maintain and update existing dashboards
• Assist in team project planning / project-managemen

Required Qualifications

• Bachelor's degree or equivalent experience in computer science, mathematics, information systems, software engineering, or related field
• 5+ years of work experience beyond degree

Preferred Qualifications

• Substantial work with BI tools and data visualization/reporting
• Experience with health insurance data and analytics
• Advanced proficiency writing SQL
• Understanding of data warehouse concepts (star schemas, joins, indexes, etc.)
• Strong communication skills and experience working with a team
• The ability to work both collaboratively and independently
• 
  

  Experience with Snowflake data warehouse

  
  
• 
  

  Experience with SAS

  
  
• 
  

  Experience with Oracle Analytics or Oracle Business Intelligence

  
  
• 
  

  Experience using Git for version control and collaborating using tools like GitHub, GitLab

  
  

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 $102,100 - $175,100. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $102,100 - $145,900. 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