Data Analyst - Pet Retail Dispensing & Inventory Analyst US

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!

Business Unit Overview:

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