Hybrid FP&A & Value Realization Internship

Wellmark-Blue-Cross-and-Blue-Shiel; Des Moines (IA); Hybrid; USD 21,000 - 30,000; Full time

Benefits offered by this job

Hybrid schedule

Job summary

Wellmark Blue Cross Blue Shield is offering a summer internship split between FP&A and Enterprise Portfolio Planning and Value Realization (EPPVR) to gain hands-on experience with lean portfolio management, data analytics, and financial planning.

You will analyze processes, build automated Excel models, support monthly reporting, and collaborate with stakeholders across teams. The program starts May 2027 with hybrid work from Des Moines, IA, and may transition to part-time in fall 2027.

Qualifications

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

Responsibilities

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

Skills

Data analysis

Communication

Problem solving

Education

Bachelor's or Master's in Business/Finance/Data Analytics

Tools

Excel

SharePoint

Azure DevOps

Job description

Wellmark Blue Cross Blue Shield is offering a summer internship split between FP&A and Enterprise Portfolio Planning and Value Realization (EPPVR) to gain hands-on experience with lean portfolio management, data analytics, and financial planning.

You will analyze processes, build automated Excel models, support monthly reporting, and collaborate with stakeholders across teams. The program starts May 2027 with hybrid work from Des Moines, IA, and may transition to part-time in fall 2027.