Cencora
Data Engineer III
Cencora, Orange, California, United States, 92613
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!What you will be doing
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.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.Research 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.What your background should look like
Requires Bachelor’s Degree in Computer Science, Business Administration or a related field; requires 5+ years of responsible experience in developing business solutions.The experience should be with requirements gathering, SQL, Data Integration tools such as Informatica Powercenter, Microsoft SSIS, Azure ADF and Data Warehousing techniques.5+ years of experience developing BI/DW solutions in Informatica Powercenter or similar tool like IICS, Microsoft ADF, Apache Spark, Talend, but not limited to architecture design/development with the ability to resolve issues quickly and efficiently.5+ years of using Structured Query Language (SQL).Knowledge and exposures to Azure SQL DataWarehouse, Databricks or other cloud or on premises MPP data warehousing systems (MS APS, Teradata, Snowflake).Experience in using and tuning relational databases (MS SQL Server, Oracle, MySql).Experience with Lambda and Kappa architecture implementations is a plus.Experience with Data Lake implementations and design patterns is a plus.Knowledge of Test Driven Development, Continuous Integration, Agile/Scrum.Experience with code versioning tools and a command of configuration management concepts and tools.Demonstrated ability to quickly learn and adapt to new technologies and coding techniques.Experience designing, developing and testing applications using proven or emerging technologies, in a variety of technologies and environments.Knowledge in cloud resource provisioning and management on Azure and/or AWS is a plus.Familiar with Streaming and with streaming concepts and patterns is a plus.Scientific computing experience (R, Matlab, Python, etc.) is a plus. Motivated quick learner presenting a positive energetic and professional image able to work in a fast-paced, collaborative, and project-oriented environment.Strong interpersonal and analytical skills including the ability to communicate effectively both verbally and in writing.Good knowledge of Microsoft Word, Excel, Power Point and Outlook.Some prior exposure to pharmaceutical distribution/health care services industry desired.Ability to lead other Data Engineers on small projects initiatives.Ensures that data is clean, consistent, and synchronized across platforms as needed.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.Ensures that physical models align with the logical data model.Reviews and approves the logical data models.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/amerisourcebergenSchedule
Full timeSalary Range*
$95,800 - 147,620This 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 State-specific locations may be up to 10% lower than the minimum salary range, and 12% higher than the maximum salary range.Affiliated Companies:
AmerisourceBergen Services CorporationEqual 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 hrsc@amerisourcebergen.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned.
#J-18808-Ljbffr
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.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.Research 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.What your background should look like
Requires Bachelor’s Degree in Computer Science, Business Administration or a related field; requires 5+ years of responsible experience in developing business solutions.The experience should be with requirements gathering, SQL, Data Integration tools such as Informatica Powercenter, Microsoft SSIS, Azure ADF and Data Warehousing techniques.5+ years of experience developing BI/DW solutions in Informatica Powercenter or similar tool like IICS, Microsoft ADF, Apache Spark, Talend, but not limited to architecture design/development with the ability to resolve issues quickly and efficiently.5+ years of using Structured Query Language (SQL).Knowledge and exposures to Azure SQL DataWarehouse, Databricks or other cloud or on premises MPP data warehousing systems (MS APS, Teradata, Snowflake).Experience in using and tuning relational databases (MS SQL Server, Oracle, MySql).Experience with Lambda and Kappa architecture implementations is a plus.Experience with Data Lake implementations and design patterns is a plus.Knowledge of Test Driven Development, Continuous Integration, Agile/Scrum.Experience with code versioning tools and a command of configuration management concepts and tools.Demonstrated ability to quickly learn and adapt to new technologies and coding techniques.Experience designing, developing and testing applications using proven or emerging technologies, in a variety of technologies and environments.Knowledge in cloud resource provisioning and management on Azure and/or AWS is a plus.Familiar with Streaming and with streaming concepts and patterns is a plus.Scientific computing experience (R, Matlab, Python, etc.) is a plus. Motivated quick learner presenting a positive energetic and professional image able to work in a fast-paced, collaborative, and project-oriented environment.Strong interpersonal and analytical skills including the ability to communicate effectively both verbally and in writing.Good knowledge of Microsoft Word, Excel, Power Point and Outlook.Some prior exposure to pharmaceutical distribution/health care services industry desired.Ability to lead other Data Engineers on small projects initiatives.Ensures that data is clean, consistent, and synchronized across platforms as needed.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.Ensures that physical models align with the logical data model.Reviews and approves the logical data models.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/amerisourcebergenSchedule
Full timeSalary Range*
$95,800 - 147,620This 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 State-specific locations may be up to 10% lower than the minimum salary range, and 12% higher than the maximum salary range.Affiliated Companies:
AmerisourceBergen Services CorporationEqual 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 hrsc@amerisourcebergen.com. We will make accommodation determinations on a request-by-request basis. Messages and emails regarding anything other than accommodations requests will not be returned.
#J-18808-Ljbffr