BI Reporting Analyst - Power BI for Health Plans (Onsite)

Medica; Madison (WI); On-site; USD 70,000 - 120,000; Full time

Job summary

Medica is a nonprofit health plan serving Wisconsin and surrounding states. We seek a data analyst to evaluate, design, code, test, and optimize financial and operations systems, capture data definitions, business rules, and data quality requirements, and deliver insights to drive decisions using Power BI and SQL.

This office-based role requires a Bachelor's degree and 3+ years of experience, with cloud experience (Snowflake) preferred. On-site 3 days/week in Madison, WI or Minnetonka, MN.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 3+ years of work experience beyond degree.
• Advanced SQL, Power BI, and data analysis skills.
• Experience with cloud-based technologies such as Snowflake preferred.

Responsibilities

• Partner with internal business customers to establish and develop relationships, establishing credibility as a key internal resource.
• Use analytical tools such as Power BI and SQL to produce reports meeting business needs.
• Develop analytical and reporting specifications for enterprise projects through participation in teams with internal customers.
• Develop and maintain business performance reports for operational units and produce executive analytic summaries.
• Research subjects surrounding claims, providers, pricing, benefits, government programs or membership and present information to internal customers.
• Navigate ambiguous data requirements and communicate data-driven solutions to business partners.
• Participate in team activities to identify problems and improve processes and systems.

Skills

SQL

Power BI

Data analysis

3 years experience

Education

Bachelor's degree or equivalent experience in related field

Tools

Snowflake

Job description

Medica is a nonprofit health plan serving Wisconsin and surrounding states. We seek a data analyst to evaluate, design, code, test, and optimize financial and operations systems, capture data definitions, business rules, and data quality requirements, and deliver insights to drive decisions using Power BI and SQL.

This office-based role requires a Bachelor's degree and 3+ years of experience, with cloud experience (Snowflake) preferred. On-site 3 days/week in Madison, WI or Minnetonka, MN.