Data Science Consultant - Pharmacy

Wellmark Blue Cross and Blue Shield; Des Moines (IA); On-site; USD 90,000 - 120,000; Full time

Job summary

Wellmark Blue Cross Blue Shield in Des Moines, IA seeks a data analytics consultant to guide business decisions through the full analytics lifecycle. You will partner with stakeholders, prepare data, build models, and present findings with clear narratives.

The role emphasizes SQL data handling, dashboards in Power BI and Tableau, and mentoring teammates while delivering timely, high‑quality analyses.

Qualifications

• For consideration, advanced degree or equivalent experience with SQL and analytics tools.
• Experience with BI platforms (Power BI, Tableau) and large datasets.
• Strong analytical, data manipulation, and data presentation skills.
• Effective verbal and written communication, and time management.

Responsibilities

• Identify complex business problems through stakeholder sessions and build a plan.
• Source and consolidate data from multiple sources into reusable assets.
• Prepare data and create derived elements for processing efficiency.
• Build, run, and automate models to analyze outcomes with visuals and forecasts.
• Interpret results and quantify business value in presentations.
• Develop narratives and make data-driven recommendations to stakeholders.
• Coach peers and manage multiple projects with cross-functional teams.
• Document sourcing, analysis, and reporting procedures for data integrity.

Skills

SQL

Statistical programming

Data visualization

Communication skills

Time management

Attention to detail

Education

Master’s degree in quantitative discipline

Bachelor’s degree in quantitative discipline + 2 years experience

Tools

Power BI

Tableau

SAP

SAP Business Objects

Data warehousing

Job description

Job Description

Through collaborative partnerships with key business stakeholders, proactively solves business problems using the analytics lifecycle across domains. Serves as a business consultant for high profile data presentations and data analysis. Performs data manipulation and dataset preparation for business analysis and outcomes and summarizes data in a logical and understandable format. Collaborates with cross-functional partners to drive successful data enabled improvement recommendations from definition through completion, providing solutions and identifying risks.

Job Responsibilities

• Demonstrate strong business knowledge by identifying complex business problems through discovery sessions and stakeholder interactions. Understand the project objectives and gather requirements to build a preliminary plan.
• Research and gather appropriate data from various sources. Source, extract, assemble, collate, and consolidate data into reusable data assets using complex joins.
• Profile and prepare data for analysis, including the creation of derived elements and macros for processing efficiencies.
• Build, execute, and automate models to analyze business outcomes using tables, graphs, and charts, as well as algorithms, forecasts and trends.
• Interpret results and identify key findings to quantify business value.
• Develop narratives to summarize and convey findings to stakeholders. Make recommendations based on findings.
• Be a “go to” person for analysis while being adept at quickly assessing the needs of multiple business partners with, at times, ambiguous requirements.
• Manage multiple projects simultaneously and support corporate process improvement initiatives, meeting aggressive timeframes. Participate in cross‑functional projects to optimally support the business.
• Provide peer review and coaching within team and across other business areas.
• Create, update, and maintain documentation and procedures for sourcing, analyzing, and preparing internal reporting and presentations. Ensure the highest quality and integrity of data sources.
• Other duties as assigned.

Qualifications

Required:

• For consideration, you must meet one of the following educational/technical requirements:
  • Master’s degree in a quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering, or economics.
  • Bachelor’s degree in a quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering or economics and 2 years equivalent work experience with specific experience in the analysis of databases and files using SQL dialects and statistical programming languages with specific experience utilizing data collection, advanced formulas, advanced joins, analysis, statistics, and data presentation.
• Experience with business intelligence and analysis platforms such as MS Power BI and Tableau.
• Demonstrated experience in working with large data sets and spreadsheets.
• Proficiency with complex data joins.
• Naturally curious with ability to drive business decisions and solutions.
• Effective communication skills, both verbal and written, with the ability to present complex information.
• Proactive, self‑starter with demonstrated ability to manage priorities through effective time management skills.
• Detail oriented, including a strong analytical/technical orientation.

Preferred:

• Master’s degree.
• Prior experience with data manipulation, hypothesis testing, root cause diagnosis, forecasting or modeling.
• Experience developing project roadmaps and timelines.
• Strong consultation and presentation skills.
• Have a passion for mentorship and coaching.
• Experience with SAP products including Business Objects.
• Thorough understanding of data warehousing.
• Proficiency in HROR highly preferred.

Equal Opportunity Statement

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 [e-mail].

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, F‑1 OPT, F‑1 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.

AI Statement

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.