Cencora

Promotes the principles of data resource management and data sharing, reuse of databases and single source data strategy. 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. Knowledge and exposures to Azure SQL DataWarehouse, Databricks or other cloud or on premises MPP data warehousing systems (MS APS, Teradata, Snowflake). 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.

data engineer

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/amerisourcebergen Schedule Full time Salary Range* $95,800 - 147,620 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 State-specific locations may be up to 10% lower than the minimum salary range, and 12% higher than the maximum salary range. Affiliated Companies: Affiliated Companies: AmerisourceBergen Services Corporation 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 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

START NEW SEARCH