Financial Planning & Value Analyst Internship

Wellmark Blue Cross and Blue Shield is offering an internship providing professional development and hands-on experience in the health insurance industry. The intern will support Financial Planning and Analysis and Enterprise Portfolio Planning and Value Realization through financial planning, data analytics, Lean Portfolio Management, process improvement, reporting, modeling, and stakeholder collaboration.

What you'll do:

• Support the FP&A team with updates to existing forecasts
• Extract data and prepare monthly reports for FP&A and EPPVR team use
• Build excel models that are automated and repeatable to save processing time throughout the FP&A and EPPVR team
• Evaluate EPPVR processes, recommend improvements, and document key procedures, roles, and resources
• Improve ADO data hygiene, quality, and completeness to support portfolio investment decisions
• Support special projects that help stakeholders integrate their work with the epic lifecycle
• Partner with stakeholders to identify the inputs and reporting needed to support their work
• Improve the Epic Lifecycle SharePoint site through a current-state assessment, user-needs summary, prioritized improvements, approved content and navigation updates, and maintenance guidance
• Build financial models for decision criteria to determine if an idea has a positive Net Present Value
• Validate prospective assessment Value Pillar reviews, update the applicable validation field, and document exceptions for follow-up

What they're looking for:

• Current student pursuing a Bachelor's or Master's degree in Business, Finance, Accounting, Data Analytics, or a related major
• Strong understanding of Excel and other Microsoft Office tools, with the ability to organize data and create clear, repeatable work products
• Ability to analyze processes and data, identify gaps, and document actionable findings and recommendations
• Excellent written and verbal communication skills, including the ability to create practical job aids, procedures, and presentation materials
• Demonstrated ability to take initiative, manage multiple tasks, and follow work through to completion
• Proven problem-solving, collaboration, and technical adaptation skills
• Ability to work independently, engage stakeholders, and clearly communicate results to team members and leaders
• Available to work 40 hours/week during the summer
• Prior internship or office experience, familiarity with Lean or Agile ways of working, SharePoint, or Azure DevOps, and 2+ years of college preferred, but all candidate applications will be considered

Benefits:

• Meaningful work that assists in your professional development and provides value to the team.
• Valuable experience within the health insurance industry and the opportunity to put skills and knowledge acquired in school into practice.
• Opportunity to learn from subject matter experts and leaders within the industry.
• Networking with fellow internship program participants.
• Practical, hands-on work experience.
• Hybrid schedule from the headquarters in Des Moines, Iowa.
• Opportunity to transition part-time in the fall of 2027.