Sr Data Analyst - Pet Retail Dispensing & Inventory Analyst

Elanco Animal Health Incorporated • Bangalore, IN

78d

About The Position

At Elanco (NYSE: ELAN) - it all starts with animals! As a global leader in animal health, we are dedicated to innovation and delivering products and services to prevent and treat disease in farm animals and pets. We're driven by our vision of 'Food and Companionship Enriching Life' and our approach to sustainability - the Elanco Healthy Purpose - to advance the health of animals, people, the planet and our enterprise. At Elanco, we pride ourselves on fostering a diverse and inclusive work environment. We believe that diversity is the driving force behind innovation, creativity, and overall business success. Here, you'll be part of a company that values and champions new ways of thinking, work with dynamic individuals, and acquire new skills and experiences that will propel your career to new heights. Making animals' lives better makes life better - join our team today!

Requirements

• Education: Bachelor's Degree
• Experience: 5+ years of demonstrated data management experience, including merging, cleaning, and analyzing large datasets.
• Experience using Alteryx, particularly for automating data validation, or the ability to learn basic programming concepts (RegEx, SQL, Visual Basic) for Alteryx formula creation.

Nice To Haves

• Alteryx Certification in any of the following: Alteryx Designer Core, Designer Advanced, Designer Expert, Predictive Master, Machine Learning, and/or Auto Insights.
• Familiarity with using APIs for automated data intake.
• Proven ability to leverage internal and external relationships to achieve objectives.
• Ability to perform under pressure and meet deadlines.
• Strong analytical and problem-solving skills, including identifying patterns and missing data elements in complex datasets.

Responsibilities

• Manage weekly and monthly dispensing data: download, process, validate, and load data into Azure. Validate loaded data, troubleshoot loading issues, and perform regression analysis.
• Maintain existing Alteryx intake formats customized for 30+ customers, developing new Alteryx formats with changes and for additional customers that are onboarded. Create, design, implement, and maintain recurring reports and data uploads, analyzing them to identify opportunities and provide ad-hoc analysis.
• Collaborate with technical teams to translate business needs into technical requirements for dispensing database updates and enhancements.
• Communicate Product Master updates to IT and Category Shopper teams.
• Proactively monitor PetSmart dispensing data in Tableau, escalating and resolving data discrepancies and inaccuracies.
• Maintain the Master X-Ref Source File by adding new SKUs daily, ensuring accurate product information and conversion factors in Salesforce. Collaborate with internal teams and external Retail reporters to ensure timely and accurate data submission.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Chemical Manufacturing
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees