Data Mapping Specialist II

Cencora Limited

235d • $86,500 - $123,860 • Remote

About The Position

Individuals within the Data Mapping Specialist II role will be responsible for the alignment and dissemination of healthcare informatics data in a uniform manner. The person(s) in this role will be trained on and responsible for assisting in the data acquisition process, specifically in performing mapping of data systems into the appropriate proprietary Canonical Data Model (CDM) to ensure the data is pulled into the model accurately and the data is available for its intended use. This role will work closely with data engineers to keep data systems moving through the onboarding process providing mapping, ensuring the data is reviewed appropriately by the procurement team and coordinate back with engineering to ensure data flows continuously through the engineering lifecycle. Individual(s) must be able to collaborate and communicate efficiently throughout the process.

Requirements

• Bachelor's degree in Programming/Systems or Computer Science or other related field. Or equivalent work experience.
• 3-7 years of experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake/Hadoop, MDM, Metadata, Data Quality, etc.

Responsibilities

• Works on moderately to complex tasks in support of one or more projects as a project team member, or independently on small projects.
• Increased skill in multiple technical environments and possesses knowledge of a specific business area.
• May participate in project planning processes.
• May identify project tasks and assists with project task effort estimations.
• Works with business analytics team members to develop business requirements.
• Leverages knowledge of underlying data sources and builds up specific business data domain expertise.
• Helps translate business analytics needs into semantic data access requirements.
• Translates business requirements into conceptual, logical and physical data model.
• Develops and maintains an integrated logical and physical data model.
• Assists in creating a framework for representing the data elements including the entities, relationships and attributes.
• Works with Delivery Management team to understand potential impacts to physical/virtual infrastructure and assists in remediation plans as needed.
• Recognizes and resolves conflicts between models, ensuring that data models are consistent with the enterprise model (e.g. entity names, relationships and definitions).
• Works closely with other IT groups to use the data models and/or HDFS data assets throughout the whole life cycle.
• Develops technical design of data sourcing, transformation and aggregation logic.
• Works with Information Delivery team to determine data sourcing options and recommend implementation approach.
• Leverages enterprise standard tools and platforms to develop data transformation and aggregation logic, typically working with and/or leading a small team.
• Works with business stakeholders, data visualization specialists and/or data scientists to determine analytics data consumption alternatives and recommend optimal approach based on analytics requirements.
• Verifies that data access mechanisms satisfy analytics consumption needs (may include testing various approaches).
• Transfers knowledge of data access/consumption mechanisms to business stakeholders, data visualization specialists and/or data scientists.
• Collects, analyzes and summarizes data to support business decisions.
• Identifies patterns and trends regarding data quality.
• Helps to maintain the data dictionary.
• Ensures that the information is named properly and defined consistently across the organization.
• Provides data that is congruent and reliable and is easily accessible by the user.
• Identifies opportunities for reuse of data across the enterprise.
• Validates data sources.
• Manages the flow of information between departments.
• Leverages master data as needed by business processes.
• Consults Delivery Management team on batch/bulk data load scheduling to optimize performance.
• Works with data stewards to gather requirements on merging, de-duping, cleansing rules.
• Ensures and maintains a high level of data integrity by using tools to monitor and mass update data changes.
• Develops data profiling and preventative procedures to improve data quality.
• Monitors and resolves daily exception reports.
• Analyzes data inaccuracies and recommends process improvements or system changes to enhance overall quality of the data.
• Communicates data integrity accuracy to the business, and escalates/communicates issues when necessary.
• Identifies opportunities and supports the development of automated solutions to enhance the quality of enterprise data.
• Analyzes data issues and works with development teams for problem resolutions.
• Monitors data dictionary statistics, analyze reports of data duplicates or other errors to provide ongoing appropriate data reports.
• Identifies problematic areas and conducts research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
• May define test plans and system documentation to monitor testing for the implementation of business analytics solution enhancements, modifications and new releases.
• Conducts unit testing to ensure business analytics solutions meet user specifications.
• May participate in integration testing.
• Interfaces with testing teams to incorporate plans into the testing process.
• May analyze existing data platform to identify weaknesses and develop opportunities for improvements, when assigned.
• Provides technical coaching and mentoring to less-experienced team members.

Benefits

• Medical, dental, and vision care
• Backup dependent care
• Adoption assistance
• Infertility coverage
• Family building support
• Behavioral health solutions
• Paid parental leave
• Paid caregiver leave
• Training programs
• Professional development resources
• Opportunities to participate in mentorship programs
• Employee resource groups
• Volunteer activities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Merchant Wholesalers, Nondurable Goods
• Education Level: Bachelor's degree