ETL Customer Analytics Consultant #1356

DUTIES: Wellmark of South Dakota Inc. seeks a ETL Customer Analytics Consultant based out of our office at 1331 Grand Avenue, Des Moines, IA 50309. This is a hybrid position whereby the employee will work both from home and from the aforementioned office address. Hence, the employee must live within a reasonable commuting distance of the aforementioned office address.

Develop and maintain ETL (Extract, Transform, Load) data pipelines to ensure efficient data processing and integration from various sources. Analyze trends in account data to identify opportunities for market penetration growth and improve business strategies. Assess and process data relevant to market penetration growth, including price transparency Machine-Readable Files (MRFs) from health insurers. Collaborate with business stakeholders to understand their needs and translate them into actionable data insights. Utilize Microsoft Power BI, SAS, Python, and SQL to create comprehensive data analyses and visualizations. Ensure data integrity and quality by implementing best practices for data collection, storage, and processing. Provide technical support and guidance on ETL processes, data analysis, and business intelligence tools. Develop and implement automated solutions for Schedule A reporting requirements. Communicate complex data insights and technical information effectively to non-technical stakeholders. Proactively identify potential risks in data management and propose effective solutions. Other duties as assigned.

Bachelor’s degree in Computer Science, Business Analytics, or related;

24 months of experience in job offered or related;

Experience must include: Two (2) years of experience with health care insurance, specifically in creating data engineering pipelines; two (2) years of experience with Microsoft Power BI, SAS, Python, and SQL; experience with automating Schedule A reporting; two (2) years of experience with analyzing and processing price transparency Machine-Readable Files (MRFs) from health insurers; experience with data visualization and formula creation; and experience with business intelligence or analysis platforms;

AWS Cloud Practitioner Certification required.

OTHER: Employer: Wellmark of South Dakota Inc. Job Site: 1331 Grand Avenue, Des Moines, IA 50309. 40 hours per week.

All your information will be kept confidential according to EEO guidelines.

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 [email protected]

Please inform us if you meet the definition of a "Covered DoD official".