Engineer - Data Engineer III (remote)

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
SUMMARY:
Individuals in this role understand how information is turned into knowledge and how this knowledge supports and enables key business processes. They must have a solid understanding of logical data warehousing design principles and data access requirements for business analytics and exploration. Also required are analytical skills, the ability to establish and maintain effective working relationships with team members, as well as an innate curiosity around wanting to understand business processes, business strategy and strategic business initiatives to help drive incremental business value from enterprise data assets.
PRIMARY DUTIES AND RESPONSIBILITIES:

• Works on complex, major or highly visible tasks and projects as a project team member, sometimes as a project lead.
• Works on projects that may span a broad range of technologies.
• Expertise in multiple technical environments and possesses business knowledge that spans one or more business areas.
• Participates in project planning processes.
• Identifies project tasks and leads or assists with project timeline estimations.
• Works with other team members and business stakeholders to drive development of business analytics requirements.
• Leverages understanding of business data domain and detailed knowledge of underlying data sources.
• Translates business analytics needs into semantic data access requirements.
• Creates a framework for representing the data elements including the entities, relationships and attributes.
• Recognizes and resolves conflicts between models, ensuring that data models are consistent with the enterprise model (e.g. entity names, relationships and definitions).
• Supports the effort for high level modeling of key program processes and key data entities.
• Ensures integration of the project logical data model into the enterprise conceptual data model.
• Ensures that physical models align with the logical data model.
• Reviews and approves the logical data models.
• Ensures consistent and stable delta processing for data loads
• Works with Delivery Management team to understand potential impacts to physical/virtual infrastructure and assists with remediation planning
• Develops technical design of complex 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.
• Ensures consistent and stable delta processing for data loads.
• Works with others 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.
• Defines, documents, and maintains all data definitions, data sources, business meaning and usage of information.
• Researches internal and external data sources for new data and better sources of data feeds.
• Identifies and validates opportunities to share/reuse existing data/information.
• Promotes the principles of data resource management and data sharing, reuse of databases and single source data strategy.
• Consulted in requests for specialized master data.
• Leverages master data as needed by business processes.
• Supports activities to prepare existing metadata for mapping and loading into metadata repository.
• Consults Delivery Management team on batch/bulk data load scheduling to optimize performance
• Works with stakeholders to gather requirements on merging, de-duping, cleansing rules.
• Ensures that data is clean, consistent, and synchronized across platforms.
• Oversees the design and implementation of data cleansing procedures.
• Leads the identification of areas affecting data integrity and coordinates corrective actions
• Develops solutions and recommendations for improving data integrity issues.
• Analyzes data issues and works with development teams for problem resolutions.
• 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 provide technical direction and oversee testing of business analytics solutions.
• May provide technical leadership for the definition and development of test plans and system documentation.
• Conducts unit testing to ensure business analytics solutions meet user specifications.
• Assigned performance tickets and may proactively analyze existing data platform to identify weaknesses and develop opportunities for improvements, upgrades or replacement.
• Provides technical leadership, coaching and mentoring to team members.
• Provides technical guidance or system process expertise.
• Develops reports and presentations for senior management, as needed.

EXPERIENCE AND EDUCATIONAL REQUIREMENTS:

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

MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

• Five (5) to ten (10) years of experience in technologies relevant to data/information management, such as SQL, RDBMS, Data Lake/Hadoop, MDM, Metadata, Data Quality, etc.
• Has a broad level of understanding surrounding information systems and application architecture standards.
• Experience in leading small project teams and streams.
• Demonstrated ability to analyze and interpret complex problems or processes that span multiple business areas, identify and understand requirements, and develop alternate solutions.
• Experience designing, developing and testing applications using proven or emerging technologies in a variety of technologies and environments.

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
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: AmerisourceBergen Services Corporation