Health Plan Developer II - Enterprise Data Reporting

Medica Services Company LLC; Minnetonka (MN); On-site; USD 70,000 - 105,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

PTO

Holidays

Paid volunteer time off

401K contributions

Caregiver services

Job summary

Medica is seeking a Health Plan Developer II for Enterprise Data Reporting in Minnetonka, MN. The role is office-based with a 3-day onsite requirement, located in Minnetonka or Madison.

You will design, code, test, and optimize data reporting solutions across multiple business lines and IT initiatives, with exposure to Power BI and SQL in a healthcare context. The position requires a Bachelor's degree and 3+ years of experience, with proficiency in Power BI and SQL.

Qualifications

• Bachelor's degree or equivalent in related field.
• 3 years of work experience beyond degree.
• Proficient user of Power BI and SQL.

Responsibilities

• 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.

Skills

Power BI

SQL

Snowflake

Education

Bachelor's degree or equivalent in related field

Job description

If you are a job seeker with a disability and require a reasonable accommodation to apply for one of our jobs, you will find the contact information to request the appropriate accommodation by visiting the following our Accessibility Accomodation for Applicants page.

Health Plan Developer II - Enterprise Data Reporting

Locations

Showing 1 location Minnetonka, MN | CORP Minnetonka, MN 55305, USA

+3 more locations

• Hybrid
• Finance
• Full-Time

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
• Proficient user of Power BI and SQL

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.

Benefits

• 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.