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 data submission.
  
  

Qualifications

• Bachelor's Degree or 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.
• Advanced proficiency in Microsoft Excel and familiarity with or ability to learn Tableau for data validation, reporting, and user support.
• Strong organizational, time management, and prioritization skills.
• Proven ability to document business processes and system requirements.
• Excellent written and verbal communication skills for interacting with various stakeholders (senior management, technical teams, business stakeholders, colleagues, and external clients).
• Experience importing, exporting, and processing data in various flat file formats (txt, csv) using different delimiters (comma, tab, pipe).
  
  

Desired Skills

• 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.
• Self-motivation, resourcefulness, and initiative to research and implement new processes for data validity and timeliness.
  
  

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