Data Engineer III

Job Summary At Cencora, we are looking for a Data Scientist/Engineer to work with MWI Veterinary Supply Company. The role involves transforming raw data into actionable insights and ensuring data integrity across platforms. Primary Responsibilities Develop and implement techniques or analytics applications to transform raw data into meaningful information. Recognize and resolve conflicts between data models, ensuring consistency 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, ensure 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, and transfer knowledge of data access/consumption mechanisms to business stakeholders, data visualization specialists and/or data scientists. Conduct 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 coordinate corrective actions. Identify problematic areas and conduct research to determine the best ways to correct data, and analyze and interpret trends and patterns in complex datasets. Work with stakeholders to gather requirements on merging, de-duplication, and cleansing rules. Support activities to prepare existing metadata for mapping and loading into metadata repository. Experience & Education Bachelor’s degree or foreign equivalent in Data Science, Electronic Engineering, or a related quantitative field. At least five years of experience in a data processing position. Experience utilizing the Microsoft development stack, Azure DevOps, Logic Apps, SQL Server, Azure Data Lake & Storage Explorer, Azure Service Bus, Visual Studio, Azure Data Factory, Control Framework, SSIS, SSAS, Power BI, Azure Event Hub, Kafka, Python, SQL, and Databricks. Experience extracting, transforming, and loading production animal database structures from Accu-Trac, Pro Control, and Stocker1 systems into data product solutions. Experience designing, building, and managing Snowflake, Tableau, Azure Data Warehouse, and Synapse data product solutions. Telework Telework permitted within commuting distance for up to 2 days per week. Benefits Compensation, medical, dental, and vision care, backup dependent care, adoption assistance, infertility coverage, family building support, behavioral health solutions, paid parental leave, paid caregiver leave, and professional development opportunities. Visit for details. 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. Harassment is prohibited. All matters related to recruiting, training, compensation, benefits, promotions and transfers comply with equal opportunity principles. Cencora provides reasonable accommodations for individuals with disabilities during the employment process. For accommodation requests, call View phone number on click.appcast.io or email View email address on click.appcast.io. #J-18808-Ljbffr