Data Analyst - Pet Retail Dispensing & Inventory Analyst

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!

Role: Data Analyst - Pet Retail Dispensing & Inventory Analyst

The Pet Retail team is focused on the sales of Elanco's products through retail channels of distribution including Pet Specialty Retail, E-Commerce sites, FDM/Mass merchants as well as other specialty or niche retailers. Combined with the recently acquired Bayer Animal Health product lines, Elanco offers an unparalleled line of pet health solutions to the consumer. The Data Analyst plays a vital role in ingesting Pet Retail Dispensing sales and inventory data from our customers. This data is integral for Elanco as it is utilized for marketing and sales intelligence, customer payments, internal compensation and product consumption. This process involves defining, adhering to, and documenting processes for data analysis, mapping, integration, and quality assurance. This position requires a high degree of autonomy, with minimal direct supervision of day-to-day tasks and primarily high-level direction from departmental leadership.

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.

Qualifications:

• 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.

Preferred Qualification:

• 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.

Additional Information:

• Travel: 0%

• Location: India, Bangalore

Don't meet every single requirement? Studies have shown underrecognized groups are less likely to apply to jobs unless they meet every single qualification. At Elanco we are dedicated to building a diverse and inclusive work environment. If you think you might be a good fit for a role but don't necessarily meet every requirement, we encourage you to apply. You may be the right candidate for this role or other roles!

Elanco is an EEO/Affirmative Action Employer and does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status