Data Analyst

Education : EQUIVALENTEXPERIENCE

**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**

**Your Role**:Data Analyst - Pet Retail Dispensing & Inventory**

As a Data Analyst, you will be part of the Pet Retail team to deliver sales of Elanco's products through retail channels. In this role, you'll be responsible for ingesting Pet Retail Dispensing sales and inventory data, defining, adhering to, and documenting processes for data analysis, mapping, integration, and quality assurance, and working with a high degree of autonomy under mínimal supervision.

**Your Responsibilities**:

- **Data Management**: Oversee the entire data lifecycle, from downloading and processing weekly/monthly dispensing data to validating, loading it into Azure, troubleshooting issues, and performing regression analysis.
- ** Alteryx Workflow Maintenance and Development**: Maintain and update existing Alteryx intake formats for numerous customers, create new formats as needed, and design/implement recurring reports and data uploads for analysis.
- ** Technical Collaboration and Requirements Gathering**: Bridge the gap between business needs and technical implementation by translating requirements for dispensing database updates and enhancements for technical teams.
- ** Cross-Functional Communication**: Effectively communicate product master updates to relevant teams (IT and Category Shopper) and collaborate with internal and external stakeholders to ensure accurate and timely data submission.
- ** Proactive Data Monitoring and Quality Assurance**: Continuously monitor data integrity (especially PetSmart data), promptly escalate and resolve discrepancies, and maintain the Master X-Ref Source File for accurate product information in Salesforce.

**What You Need to Succeed (minimum qualifications)**:

- ** Education**:Bachelor's Degree or High School Diploma / GED with 5+ years of equivalent experience in data management.
- ** Required Experience**:A minimum of 2 years of experience in data management, including merging, cleaning, and analyzing large datasets.
- Advanced proficiency in English and experience using Microsoft.

**What will give you a competitive edge (preferred qualifications)**:

- Alteryx Certification (Designer Core, Advanced, 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.
- Strong analytical and problem-solving skills, with a focus on identifying patterns and missing data in complex datasets.
- Self-motivation and resourcefulness in researching and implementing new processes for data validity and timeliness.

**Additional Information**:

- Travel: 0 - 10%
- Location: Mercado Andares, Zapopan, Jall.

**Elanco Benefits and Perks**:
We offer a comprehensive benefits package focusing on financial, physical, and mental well-being while encouraging our employees to pursue our purpose Some highlights include:

- Food vouchers 10%.
- Savings fund 13%.
- Restaurant vouchers $1,800
- Christmas Bonus 33 days
- SGMM
- Life insurance
- PTU
- 80% vacation bonus
- Annual bonus of 6%.
- Pension plan
- Discounts by agreement (medical lab, car insurance, Elanco products)
- Flexible schedule
- Short Fridays

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