▷ (Only 24h Left) Sr 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 At Elanco we are driven by our vision of Food and Companionship Enriching Life and our purpose - all to Go Beyond for Animals Customers Society and Our People 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