Data Integration Analyst

Job Description

This role will support the Portfolio - Exchange team in our technology division and the growth in useful data available to assist with business decision making.

You will consult with business and technology areas to understand business functions, processes, challenges, opportunities, and systems impacts.

We are looking for a Sherlock Holmes of sorts; you will receive alerts / emails with an issue, and you will need to dive in and research why the issue occurred and work with cross-functional internal teams to resolve the issue.

You should be a person who enjoys digging into data issues and solving the riddle. At times, you will need to assist with eliciting requirements and, when appropriate, write user stories.

In addition, you will support operational and analytic data needs within the team by handling complex data projects and ensuring the completion of data analysis and mapping activities.

Qualifications

Required :

• Bachelor’s 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 :

• Bachelor’s Degree
• Power BI Experience
• Prior experience working with CMS / Health Care
• Experience working within an agile team and / or assisting a team through an agile transformation.
• Experience using agile management tools such as Azure DevOps

Additional Information

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.

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