Data Engineer II - Data Engineering

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

The Data Engineer II is primarily responsible for ensuring the provision of accurate and pertinent data in support of the Legal and Compliance departments. This role involves the extraction and analysis of data from multiple databases/platforms while leveraging skills such as proficiency in SQL & SAP Business Objects as well as knowledge on Wholesale Distribution Customer Sales and Payments and Plant Receipts and Returns. The Data Engineer II plays a pivotal role in conceptualizing, designing, and developing analytics models and related team procedures to address intricate business challenges and uncover insights for internal and external stakeholders. They facilitate a seamless user experience by furnishing easily accessible, synchronized, and reliable data. Additionally, the Data Engineer II conducts root-cause analyses and implements necessary corrective measures in response to data-related system issues. The Data Engineer II guides team members in using precise data validations and quality control methods to maintain data integrity and compliance.

Primary Duties And Responsibilities

• Facilitates implementation of enhancements or changes to existing business analytics solutions, by helping translate business needs into semantic data access requirements
• Performs data mining exercises with vast data sets to find opportunities to grow sales, margin and market share via tele sales call campaigns, analyzes all pricing activities including discounts, allowances, programs, and contract price and develop recommendations to improve profitability and mix
• Validates data sources, data quality, data transformation and data aggregation
• Analyzes data inaccuracies, identifies opportunities and supports the development of automated solutions to enhance overall quality of the enterprise data
• Works with data stewards to gather requirements on merging, de-duping, cleansing rules
• Ensures and maintains a high level of data integrity by using tools to monitor and mass update data changes
• Ensures that the information is named properly and defined consistently across the organization
• Identifies opportunities for reuse of data across the enterprise
• Monitors data dictionary statistics, analyzes reports of data duplicates or other errors to provide ongoing appropriate data reports
• Collaborates with different teams like Inside Sales, Finance and Sourcing in the development and preparation of performance forecasts, projections, and plans based upon numerous variables and data assumptions
• Identifies problematic areas and conducts research to determine the best course of action to correct the data, identifies, analyzes and interprets trends and patterns in complex datasets
• Performs quantification and impact analysis of existing or proposed operational policies, procedures and governance frameworks
• Assists in the coaching and training of business analytics solution users to enhance business decision-making capability
• Analyzes results of system audits to determine and report variations or problem areas, keen attention to detail including an ability to identify data anomalies
• Works cross-functionally with different departments to assess, define, and develop report deliverables
• Accurately codes variables from original information or data and completes statistical analyses as required
  
  

Experience

• 4+ years of directly related experience in healthcare data analytics or data engineering.
  
  

Essential Skills

• Proficient in SAP and experienced with BusinessObjects.
• Extensive background in Business Intelligence and SQL.
• Strong understanding of the complete distribution process, including purchases, sales, and payments.
• Previous mentoring experience.
• Knowledge of supplier rebates and chargebacks to wholesalers.
• Familiar with the end-to-end wholesale supply chain, including purchasing inventory and sales to customers.
  
  

Desired Skills

• Background in pharmaceutical wholesale.
• Familiarity with Microsoft Power BI or Tableau.
  
  

Skills & Knowledge

Behavioral Skills:

• Critical Thinking
• Detail Oriented
• Interpersonal Communication
• Learning Agility
• Problem Solving
• Time Management
  
  

Technical Skills

• Advanced Data Visualization Techniques
• Advanced Statistical Analysis
• Big Data Analysis Tools and Techniques
• Data Governance
• Data Management
• Data Modelling
• Data Quality Assurance
• Programming languages like SQL, R, Python
  
  

Tools Knowledge

• Business Intelligence Software like Tableau, Power BI, Alteryx, QlikSense
• Data Visualization Tools
• Microsoft Office Suite
• Statistical Analytics tools (SAS, SPSS3)
  
  

What Cencora offers

Benefit offerings outside the US may vary by country and will be aligned to local market practice. The eligibility and effective date may differ for some benefits and for team members covered under collective bargaining agreements.

Full time

Affiliated Companies

Affiliated Companies: CENCORA INDIA TECHNOLOGY SERVICES PRIVATE LIMITED

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