Data Integration Analyst

This role sits within a product team and partners closely with business stakeholders and product management to identify opportunities where analytics process improvement consulting and automation can meaningfully improve how work gets done. The individual will lead impactful and sometimes ambiguous initiatives that require curiosity process and technical understanding to translate business needs into practical scalable solutions. This role blends analytics consulting business systems analysis and process improvement to help teams do more with less through thoughtful design and implementation. It is hands on end to end work partnering to make a big difference. 

Turns complexity into simplicity for the business designing practical userfriendly solutions that reduce manual effort and make it easier for teams to focus on highervalue work

Acts as a trusted thought partner consistently seeking to understand the why behind business processes and helping stakeholders reimagine how work could be done more efficiently through analytics automation or better design

Delivers tangible progress quickly favoring rightsized fitforpurpose solutions over heavy process while still ensuring outcomes are reliable scalable and valuable

Connects process data and technology spotting opportunities where small technical or analytical improvements can unlock disproportionate business benefit

Helps ideas become reality supporting the journey from discovery through delivery so that improvements dont stall and solutions get adopted in practice and not just designed on paper.

Qualifications :

Required:

• Bachelors Degree in a quantitative discipline such as computer science engineering statistics mathematics economics or direct and applicable work experience.
• Minimum 2 years experience with various data techniques such as: gap analysis data profiling and source to target mapping for both structured and unstructured data sources (ETL Widgets JSON etc.). 
• SQL skills including knowledge of joining multiple data sources; hands on experience with advanced SQL functions such as: creating sub queries joining grouping and filtering to analyze data sources.
• Strong analytical skills with the ability to read and understand data models and give input to data modeling based on data analysis results.
• Strong communication skills (both written and verbal) to express complex technical concepts effectively and ability to influence others.
• Microsoft Office Suite; including the use of spreadsheets presentation and word processing software.
• Ability to work independently or in a team.

Preferred:

• 3 years experience in internal or external consulting role solving business problems
• Managed Pharmacy or Health Care Insurance experience
• Experience with SAP Products including Business Objects
• Experience with Power Automate Copilot Studio and PowerBI
• Six Sigma or Process Excellence certification
• Masters degree

Additional Information :

Job Responsibilities 

a. Analyze new and existing structured and unstructured data sources. Use data mining techniques to review data for anomalies and gaps in data patterns and correlations and transform data into actionable and meaningful solutions for the business.

b. Work with Information Product/Platform teams to understand data requirements. Research data related questions effectively communicate risks and issues and provide recommendations on the best ways to integrate new data with existing data.

c. Collate data analysis in a meaningful way and present findings to peers project core team Information Product/Platform teams and Stakeholders.

d. Document and/or oversee the documentation of data transformation logic data mappings and query logic to support complex data integrations.

e. Complete source to target documentation in the data design document. Ensure mappings can be easily understood by others including IT Solutions Developers or other technical stakeholders.

f. Collaborate with the Sr Data Integration Analyst to further understand the project level data flow data requirements and analytic reporting needs.

g. Collaborate with the data modeler to understand the data models and to identify and lead resolution of gaps in the data model to meet the needs of Information Products.

h. Query and analyze the data to acquire essential business information to drive out quality transformation logic and mappings that meet the data requirements.

i. Communicate and collaborate effectively with data governance analysts to enable data governance stewardship and data quality management processes throughout analysis and mapping deliverables.

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

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. 

Remote Work :

No

Employment Type :

Full-time