Internship Advanced Excel Jobs in Iowa (NOW HIRING)

Company Description

Why Wellmark: We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we’ve built our reputation on over 80 years’ worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors–our members. If you’re passionate about joining an organization working hard to put its members first, to provide best-in-class service, and one that is committed to sustainability and innovation, consider applying today! 

Learn more about our unique benefit offerings here. 

Job Description

Use your strengths at Wellmark as a Clinical Pharmacy Analyst!   

We’re growing our Pharmacy team and are excited to introduce this newly created opportunity for someone who thrives in blending clinical insights with data-driven storytelling. 

In this role, you’ll put your foundational clinical pharmacy knowledge and analytical skills to work evaluating pharmacy solutions that impact healthcare delivery. You’ll gather, validate, and interpret clinical and economic evidence in a highly collaborative, matrixed environment, helping translate complex data into clear, meaningful insights. You’ll contribute to established analyses and models that quantify expected benefits, costs, and risks to ultimately help optimize healthcare resources. More importantly, you won’t just crunch numbers, you’ll transform them into concise, actionable recommendations that clearly communicate financial impact, member and provider experience, and health outcomes to decision makers. 

Collaboration is central to this role. You’ll partner closely with Business Analytics, Actuarial, and Health Services teams to ensure strong solution performance measurement, high data integrity, and consistent documentation. You’ll also support formulary maintenance activities, conduct literature reviews (HEOR/CER), and help develop compelling presentations that bring findings to life. Along the way, you’ll continue building your expertise in pharmacoeconomic methods and sharpen your consultative communication skills—growing as both a technical expert and strategic partner. Critical thinking, curiosity, and an inquisitive mindset are essential as they fuel continuous learning and innovation within our Pharmacy function.  

If you’re energized by meaningful analysis, cross-functional teamwork, and making health care better, we’d love to meet you! 

Hybrid environment: This position will work a hybrid schedule of at least 3 days (Tuesday, Wednesday, Thursday) in Wellmark's Des Moines office, with 2 days (Monday, Friday) remote option.  

Qualifications

Preferred Qualifications - Great to have:

• Direct and applicable experience in data analytics or related field that includes experience with data tools (i.e. SAS, SQL, Excel, etc.).
• Strong clinical literature review and analytical writing skills.
• PharmD.
• If PharmD, active and unrestricted Pharmacy license in Iowa or South Dakota (individual must be licensed in the state in which they reside) is required within 6 months from date of hire.
• Proficiency in HRORF preferred.

Required Qualifications - Must have:

• Bachelor’s degree in pharmacy or related clinical discipline.
• 4+ years of clinical pharmacy experience in health plan, PBM, or related industry which includes ability to conduct pharmacoeconomic reviews. Experience may include relevant internship(s) and pharmacy-based health system roles such as medication use evaluation and pharmacy quality improvement roles.
• Proven ability to organize and analyze clinical data, develop predictive models to drive business decisions, interpret the model results, turn data into actionable insights, and effectively communicate model results.
• Proficient in Microsoft Office & advanced Excel skills – e.g. pivot tables, trend analysis, and formulas. Technical aptitude to learn new data management and analysis tools or methodologies quickly.
• Excellent analytical skills, data management capabilities, and strong attention to detail. Ability to review data and provide measurable outcomes and trend measures to support and influence business decisions. Possesses natural curiosity and able to influence business decisions and devise solutions.
• Strong written and verbal communication skills with the ability to accurately and effectively summarize clinical literature.
• Effective organization and prioritization skills. Ability to manage multiple projects simultaneously and consistently meet deadlines while also adapting to changing priorities and business needs.
• Strong interpersonal skills to quickly build rapport, credibility and collaborative partnerships with peers, leaders and stakeholders.

Additional Information

What you will do as a Clinical Pharmacy Analyst:

a. Support the evaluation of pharmacy solutions by collecting, validating, and organizing clinical and economic data.
b. Participate in opportunity sizing analyses and contribute to the preparation of data-driven recommendations for pharmacy initiatives.
c. Conduct literature reviews and summarize findings from clinical trials, cost of care studies, and health economic evaluations, focusing on data quality and relevance.
d. Participate in the creation and maintenance of pharmacy value stories, articulating return on investment (ROI), health outcomes, member, and provider impact.
e. Perform data entry, modeling, and reporting to support formulary decisions and ongoing formulary maintenance activities.
f. Develop and maintain tools and templates for tracking outcomes and value associated with clinical pharmacy interventions.
g. Contribute to cost-effectiveness, cost-utility, and budget impact analyses by preparing data sets and supporting calculations.
h. Compile and organize Health Economics Outcomes Research (HEOR) and Comparative Effectiveness Research (CER) materials for presentations and decision-making.
i. Maintain positive working relationships with internal teams and external partners, supporting collaborative pharmacoeconomic evaluations.
j. Continuously develop skills in evolving data analytics, clinical pharmacy, and consultative communication through active participation in team projects and training.
k. Other duties as assigned.

An Equal Opportunity Employer

The policy of Wellmark Blue Cross Blue Shield is to recruit, hire, train and promote individuals in all job classifications without regard to race, color, religion, sex, national origin, age, veteran status, disability, sexual orientation, gender identity or any other characteristic protected by law.

Applicants requiring a reasonable accommodation due to a disability at any stage of the employment application process should contact us at careers@wellmark.com

Please inform us if you meet the definition of a "Covered DoD official".

At this time, Wellmark is not considering applicants for this position that require any type of immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States. This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc. For additional information around work authorization needs please refer to the following resources:Nonimmigrant Workers and Green Card for Employment-Based Immigrants 

Wellmark supports and expects the responsible use of AI for our workforce! We welcome the responsible use of these tools by job seekers as well and are interested in learning from you; you will have an opportunity in the application process to share which tools you used and how you applied them.