Strategic Analytics 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

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