Data Science Consultant

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

Job summary

Wellmark Blue Cross Blue Shield seeks a data analytics professional to partner with stakeholders, perform analytics across domains, and prepare data for business insights. You will serve as a consultant for high-profile data presentations and solutions, using SQL, BI tools, and modeling techniques.

The role emphasizes data manipulation, complex joins, and collaboration to drive data-enabled improvements from definition through completion, with a strong emphasis on communication and time

Qualifications

• Master’s degree in quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering, or economics.
• Bachelor’s degree in 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.
• Master’s degree preferred.
• Prior experience with data manipulation, hypothesis testing, root cause diagnosis, forecasting or modeling preferred.
• Experience developing project roadmaps and timelines preferred.
• Strong consultation and presentation skills preferred.
• Mentorship and coaching experience preferred.
• Experience with SAP products including Business Objects preferred.
• Thorough understanding of data warehousing preferred.
• HROR knowledge highly preferred.

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.

Skills

MS Power BI

Tableau

Large data sets

Complex data joins

Communication skills

Time management

Analytical mindset

Education

Master’s degree in quantitative discipline

Bachelor’s degree in quantitative discipline + 2 years experience

Tools

Power BI

Tableau

SAP Business Objects

Job 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!

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.

Want to know more? You can learn about life at Wellmark here.

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.

Qualifications

• For consideration, you must meet one of the following educational/technical requirements:
• Master’s degree in quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering, or economics - OR
• Bachelor’s degree in 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

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.

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 [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: 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.