Data Engineer III

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

PRIMARY DUTIES AND RESPONSIBILITIES:

MWI Veterinary Supply Company - Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information. Recognize and resolve conflicts between data models, ensuring they are consistent with the enterprise model. Perform high level modeling of key program processes and key data entities, ensuring integration of the project logical data model into the enterprise conceptual data model and that physical models align with the logical data model. Review and approve logical data models, ensures consistent and stable delta processing for data loads, and work with the Delivery Management team to understand potential impacts to physical/virtual infrastructure and assist with remediation planning. Develop technical designs of complex data sourcing, transformation, and aggregation logic. Ensure data is clean, consistent, and synchronized across platforms and oversee the design and implementation of data cleansing procedures. Ensure consistent and stable delta processing for data loads and work with others to determine analytics data consumption alternatives and recommend optimal approach based on analytics requirements. Verify that data access mechanisms satisfy analytics consumption needs, as well as transfer knowledge of data access/consumption mechanisms to business stakeholders, data visualization specialists and/or data scientists. Conducts unit testing to ensure business analytics solutions meet user specifications. Research internal and external data sources for new data and better sources of data feeds. Lead the identification of areas affecting data integrity and coordinates corrective actions. Identify problematic areas and conduct research to determine the best way to correct data, identify, analyze, and interpret trends and patterns in complex datasets. Work with stakeholders to gather requirements on merging, de-duping, and cleansing rules. Support activities to prepare existing metadata for mapping and loading into metadata repository. #LI-DNI

EXPERIENCE AND EDUCATIONAL REQUIREMENTS:

Requires a Bachelor's degree or foreign equivalent in Data Science, Electronic Engineering, or a related quantitative field, along with five years of experience in a data processing position. Experience must include: Utilizing the Microsoft development stack, Azure DevOps, Logic Apps, SQL Studio, Azure Data Lake & Storage Explorer, Azure Service Bus, Visual Studio, Azure Data Factory, Control Framework, SSIS, SSAS, Power BI, and Azure Event Hub; extracting, transforming, and loading of production animal database structures from Accu-Trac, Pro Control, and Stocker1 systems into data product solutions; and utilizing Kafka, Python, SQL, and databricks to design, build, and manage Snowflake, Tableau, Azure Data Warehouse, and Synapse data product solutions. Telework permitted within commuting distance 2 days/week.

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

Full time

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 View phone number on click.appcast.io or email View email address on click.appcast.io. 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: MWI Veterinary Supply Company