AmerisourceBergen Logo

AmerisourceBergen

Engineer - Data Engineer III (remote)

Posted 9 Days Ago
Remote
Mid level
Remote
Mid level
The Data Engineer III at Cencora will focus on transforming information into knowledge to support business processes. Responsibilities include developing data models, leading projects, collaborating with stakeholders on analytics requirements, and ensuring the successful integration of data models into enterprise frameworks.
The summary above was generated by AI

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

Top Skills

Data Warehousing

Similar Jobs

4 Days Ago
4 Locations
Remote
4,500 Employees
Senior level
4,500 Employees
Senior level
Fintech • Mobile • Software • Financial Services
The Senior Manager will lead the Banking Core team through the entire product lifecycle, collaborating with cross-functional teams to transform the legacy banking platform and innovate banking services. This role emphasizes team growth, accountability, and fostering a culture of continuous improvement within a fast-paced environment.
Be an Early Applicant
6 Days Ago
PA
Remote
45 Employees
Senior level
45 Employees
Senior level
Cloud • Mobile • Software • Design
As a Full Stack Developer, you will design and implement custom software solutions for various systems while collaborating with Agile teams. Your role involves ensuring the successful delivery of software through agile practices and addressing technical challenges.
Be an Early Applicant
20 Days Ago
2 Locations
Remote
573 Employees
Senior level
573 Employees
Senior level
Security • Cybersecurity
The Software Engineer will design and develop high-quality software for A-SCEND, mentor junior engineers, and collaborate with cross-functional teams to deliver features, focusing on performance, security, and technical solutions for complex issues.

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account