Data Mapping Specialist II

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!
Job Details
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.
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 analyzes existing data platform to identify weaknesses and develop opportunities for improvements, when assigned.
• Provides technical coaching and mentoring to less-experienced team members.

Education and Work Experience

• Bachelor's degree in Programming/Systems or Computer Science or other related field. Or equivalent work experience.

Skills and Knowledge

• 3-7 years of experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake/Hadoop, MDM, Metadata, Data Quality, etc.

What Cencora offers
We provide compensation, benefits, and resources that enable a highly inclusive culture and support our team members' ability to live with purpose every day. In addition to traditional offerings like medical, dental, and vision care, we also provide a comprehensive suite of benefits that focus on the physical, emotional, financial, and social aspects of wellness. This encompasses support for working families, which may include backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, and paid caregiver leave. To encourage your personal growth, we also offer a variety of training programs, professional development resources, and opportunities to participate in mentorship programs, employee resource groups, volunteer activities, and much more. For details, visit https://www.virtualfairhub.com/cencora
Full time
Salary Range*
$86,500 - 123,860
*This Salary Range reflects a National Average for this job. The actual range may vary based on your locale. Ranges in Colorado/California/Washington/New York/Hawaii/Vermont/Minnesota/Massachusetts/Illinois State-specific locations may be up to 10% lower than the minimum salary range, and 12% higher than the maximum salary range.
Equal Employment Opportunity
Cencora is committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, age, disability, veteran status or membership in any other class protected by federal, state or local law.
The company's continued success depends on the full and effective utilization of qualified individuals. Therefore, harassment is prohibited and all matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles and are non-discriminatory.
Cencora is committed to providing reasonable accommodations to individuals with disabilities during the employment process which are consistent with legal requirements. If you wish to request an accommodation while seeking employment, please call 888.692.2272 or email [email protected]. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned
Affiliated Companies:
Affiliated Companies: IntrinsiQ Specialty Solutions, Inc