Commercial Business Intelligence Partner

Elanco•Indianapolis, IN

2d•Hybrid

About The Position

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! Your Role: Commercial Business Intelligence Partner As a Commercial Business Intelligence Partner, you will join our Enterprise Data & Analytics team to turn complex commercial data into actionable insights that drive business decisions. In this role, you will perform essential data transformation and visualization using Tableau, Databricks, and SQL, while partnering closely with commercial stakeholders in a dynamic environment to translate ambiguous business questions into scalable data solutions. Over time, as our data foundation matures, this role will expand its advisory footprint across additional enterprise functions.

Requirements

Bachelor's degree in a quantitative field (e.g., Business Analytics, Computer Science, Statistics, Mathematics, Information Systems, or a related field) or equivalent level of experience.
Minimum of 5 years of relevant hands-on experience in business intelligence, data engineering, or commercial data analytics.
Advanced Tableau expertise (Power BI a plus) with strong proficiency in SQL and large dataset analysis (Databricks/data lakes); High data literacy and a proven ability to translate ambiguous business needs into actionable solutions under tight turnaround times.

Nice To Haves

Experience with commercial, sales, retail-out, or distribution data within Consumer Packaged Goods (CPG), Retail, Pharmaceutical, or Animal Health industries.
Hands-on experience querying and modeling data in Databricks and working with modern cloud data warehouse architectures.
Working knowledge of Python for advanced data manipulation or automation.
Proven ability to balance priorities across multiple stakeholders, set realistic expectations, and communicate trade-offs effectively in a dynamic environment.
Experience collaborating with global cross-functional teams and supporting enterprise analytics transformation.

Responsibilities

Analyze, query, and transform large-scale commercial datasets using SQL and Databricks; build foundational data models, queries, and data views to feed intuitive dashboards and reports.
Design and deploy executive-ready dashboards and visualizations in Tableau (and Power BI) to track commercial KPIs, sales performance, and channel metrics, delivering clear data stories that inform business decisions.
Partner with cross-functional commercial leaders to define business questions, clarify requirements under ambiguous conditions, balance multiple requests, and deliver data analyses under tight turnaround times.
Apply data literacy to interpret sales, retail-out, and distribution data; identify root causes behind business trends and translate quantitative findings into strategic recommendations.
Support data maturity initiatives across the Enterprise Data & Analytics team, standardizing reporting processes, advancing best practices, and enabling the broader adoption of self-service analytics across business units.