Analytics Consultant at Wellmark in Des Moines, IA

Job Summary

Be an integral part of our company-wide continued goal of Making Health Care Better by partnering with stakeholders to solve complex-business problems with with available all available information.

Through collaborative partnerships with key business stakeholders, you will proactively solve business problems using the analytics lifecycle across domains. You will serve as a business consultant for high-profile data presentations and data analysis. In addition, you will perform data manipulation and data set preparation for business analysis and outcomes, and summarize data in a logical and understandable format. You will also collaborate with crossfunctional partners to drive successful data-enabled improvement recommendations from definition through completion, providing solutions and identifying risks.

Qualifications

Required:

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 - OR
• 6 years of direct and applicable work experience

With specific experience in the following:

• 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, reporting, and analytics 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 oral 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 analysis, 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

JOB ACCOUNTABILITIES

a. Demonstrating strong business knowledge, identify complex business problems through discovery sessions and stakeholder interactions. Understand the project objectives and gather requirements to build a preliminary plan.

b. Research and gather appropriate data from various sources. Source, extract, assemble, collate, and consolidate data into reusable data assets using complex joins.

c. Profile and prepare data for analysis, including the creation of derived elements and macros for processing efficiencies.

d. Build, execute and automate models to analyze business outcomes, using tables, graphs, and charts, as well as algorithms, forecasts and trends.

e. Interpret results, identify key findings to quantify business value.

f. Develop narratives to summarize and convey findings to stakeholders. Make recommendations based on findings.

g. Be a go-to person for analysis while being adept at quickly assessing the needs of multiple business partners with, at times, ambiguous requirements.

h. Manage multiple projects simultaneously and support corporate process improvement initiatives, meeting aggressive timeframes.Participate in crossfunctional projects to optimally support the business.

i. Provide peer review and coaching within team and across other business areas.

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

k. Other duties as assigned.