Data Engineer II - Data Engineering

Posted 18 Days Ago
Pune, Maharashtra
3-5 Years Experience
Healthtech • Logistics • Software • Pharmaceutical
We are united in our responsibility to create healthier futures
The Role
The Data Engineer II at Cencora is responsible for extracting and analyzing data to support Legal and Compliance departments. They play a key role in designing analytics models, ensuring data integrity, and facilitating a seamless user experience.
Summary Generated by Built In

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
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 proceduresto 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
What your background should look like
EDUCATIONAL QUALIFICATIONS:
Bachelor's Degree in Statistics, Computer Science, Information Technology or any other related discipline or equivalent related experience.
Preferred Certifications:• Advanced Data Analytics Certifications• SAS Statistical Business Analyst Professional Certification
WORK EXPERIENCE:
4+ years of directly-related or relevant experience, preferably in healthcare data analytics or data engineering.
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
All team members globally are provided with basic life insurance, personal accident insurance, business travel accident insurance, and EAP resources at no cost. Additional country-specific benefits such as healthcare, sick leave, death and disability, retirement, as well as perks and allowances may be provided. Details of programs vary by location.
Schedule
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

Top Skills

SQL

What the Team is Saying

Silvana
Jason
The Company
HQ: Conshohocken, PA
46,000 Employees
Hybrid Workplace
Year Founded: 1871

What We Do

Cencora is a leading pharmaceutical solutions organization centered on improving the lives of people and animals everywhere. With 46,000+ global team members, we have the opportunity to make a positive impact on healthcare in communities everywhere.



Our team members are empowered to activate their careers through a collective of tools and resources designed to support individual career interests and aspirations. We value our listening culture that actions real outcomes and our team members appreciate and recognize one another for contributions that are making a meaningful global impact.



No matter what your role is here, the work we do together has meaning. When you join our team, you become a crucial part of a greater purpose. We’re committed to supporting you personally and professionally, so we can achieve more together at the center of health.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Cencora Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
Company Office Image
HQConshohocken, PA
București, RO
Carrollton, TX
Dříteň, CZ
Gennevilliers, FR
Marseille, FR
Oakville, ON
Pune, Maharashtra
Villanueva de Gállego, Zaragoza
Vilniaus miesto, LT
Zaragoza, Zaragoza
Learn more

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account