Data Wrangler

Wellmark, Inc.; Iowa (LA); On-site; USD 55,000 - 75,000; Full time

Job summary

Wellmark Blue Cross Blue Shield in Iowa is seeking a data analyst to build and maintain complex data assets and provide reporting to analysts and scientists. You will transform raw data into usable formats, profile data quality, and develop automated reports and dashboards to surface key metrics.

Ideal candidates have a bachelor’s degree in a quantitative field and strong SQL, Excel, and data visualization skills, with ability to learn new sources and collaborate across teams.

Qualifications

• Bachelor’s degree in a quantitative discipline is required.
• Less than 1 year hands-on data reporting or analysis experience.
• Ability to learn new data sources and SQL quickly.
• Basic knowledge of relational databases and data quality.
• Detail oriented, self-motivated, strong communicator with analytical orientation.
• Proactive self-starter with time management and prioritization.

Responsibilities

• Wrangle data from diverse sources and build normalized, enriched data assets.
• Perform data profiling, quality assessments, and source consolidation.
• Develop automated reports and dashboards to surface key metrics.
• Gather dataset requirements from analytics stakeholders for downstream analysis.
• Acquire, transform, map, and load data into data models; document architectures.
• Create and maintain documentation for sourcing, analyzing, and presenting internal data.
• Other duties as assigned.

Skills

SQL

Excel

Data Analysis

Data Profiling

Data Quality

Communication

Education

Bachelor's degree in quantitative discipline

Master's Degree (preferred)

Tools

Power BI

Tableau

Python

Spark

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.

Responsible for building and maintaining complex data assets that allow team of analytics professionals to develop advanced business analytics that drive Wellmark’s strategic business decisions. Provide technical support and reporting to Analysts/Scientists, including transforming and mapping data from raw data form into another format with the intent of making it more usable and valuable, identifying efficiencies or automation opportunities and other data enabled improvement recommendations.

Required:

• Bachelor’s degree in quantitative discipline such as statistics, mathematics, finance, accounting, computer science, engineering or economics.
• Less than 1-year hands‑on experience or internship in a role pulling reports and analyzing data; experience with data discovery, profiling, cleansing, standardization and data quality management
• Ability to quickly learn new data sources and programming languages (e.g. SQL)
• Basic knowledge or experience with relational databases
• Detail oriented, self‑motivated, excellent communicator, strong analytical/technical orientation
• Natural curiosity, and ability to drive business decisions and solutions
• Proactive self‑starter with effective time management skills and the ability to organize and prioritize projects or tasks
• Proficient in Microsoft Excel with a strong emphasis in formulas, pivot tables and data visualizations

Preferred:

• Master's Degree
• Experience working with large data sets and spreadsheets
• Experience gathering and documenting business requirements
• Experience of cross functional activity in complex organizations with strong emphasis on influencing and collaboration
• Hands‑on data analysis of databases and files using SQL dialects and programming languages (e.g. Python, Scala, Spark etc.)
• Experience with business intelligence/reporting/analytics platforms such as MS Power BI and Tableau etc.
• Proven ability to mine and query data across structured and unstructured data sets

Job Responsibilities

a. Wrangle data from a wide variety of data sets and assemble into normalized and enriched data assets that enables new insights, solutions, and visualizations.

b. Perform and document data profiling, quality assessment, source consolidation, aggregation and other data manipulation efforts, to understand data formats, source systems, file sizes, etc.

c. Develop simple, dependable automated reports and dashboards to surface key metrics that deliver information that is digestible and visually appealing.

d. Gather data set requirements from business analytics stakeholders in order to support downstream analysis.

e. Acquire, transform, map, and load data into a variety of data models. Responsible for documenting assigned data asset and dashboard architectures.

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

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