MDM Data Engineer and Analyst
Quincy, MA

Job Description

Ready to help us transform healthcare? Bring your true colors to blue.

We have a unique opportunity for an experienced and talented MDM Data Analyst, to support new MDM solution here at Blue Cross Blue Shield of Massachusetts. This new role, as part of Digital & Analytics delivery organization within Enterprise Technology division, will support the development of solutions for master data management, follow industry standard best practices and applying new and innovative business utilization of master data in enabling data governance and analytics. In this role, you will play a key role in analyzing the data, identifying patterns, documenting the data requirements, identification of correct data sources, publishing the quality of data in addition to serving as the "go to" person for data needs.This role requires a proven functional and technical skill set that has been demonstrated in the data solutions such as MDM, Data warehouse and Analytics environment. This role will also evangelize the value of data in supporting known and potential data needs associated with various business functions of BCBSMA.

Responsibilities:

* Develop, review and maintain functional artifacts, including high level requirements, functional design, success criteria, and data profiles.
* Develop use cases and business cases for new initiatives related to MDM and master data.
* Develop systems data flow for existing and new systems
* Develop entity level data flow for existing and new entities across various systems
* Develop source to target data mappings for incoming and outgoing data between and within systems
* Document transformation rules applicable for master data management
* Publish supporting documentation of MDM solution(s) for augmenting data governance rules.
* Partner with business leads, project manager, application developers, data engineers, data scientists, and other technical team in addressing project needs timely
* Create and deliver user documentation as necessary to ensure proper use of changed and newly implemented efforts
* Maintain, monitor, and verify the accuracy of the master data in the applicable systems
* Identify and execute continuous improvement opportunities within the data management processes in the applicable systems

Education and Experience:

* Under graduate degree in mathematics, science, computer engineering or related field preferred.
* 5+ years of overall experience in IT with strong understanding of Master Data Management (MDM), Data Quality, Data Governance and BI concepts.
* 3+ years of hands-on experience in writing complex queries for relational databases.
* 2+ years of hands-on experience in writing complex queries for big data technologies.
* Experience in query tools like WinSQL, TOAD, SQL Developer or similar tools
* Must have hands-on experience with - data profiling , data mappings, data validation , hierarchy management, match and merge rules and supporting data stewards
* Prior MDM work experience in few of subject areas like Customer/Member, Product, Account/Employer and Product is a plus
* Knowledge of MDM integrations with business application using Batch process, API/Services Framework and message queues
* Knowledge of tools/services for address cleansing, phone number validation and email validation, is a plus.

LocationBoston, QuincyTime TypeFull time