Commercial Business Intelligence Partner
Elanco
Summary
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.
Job description
Your Responsibilities
- Data Solution Architecture & Execution: 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.
- Dashboard Design & Visualization: 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.
- Stakeholder Partnership & Prioritization: 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.
- Commercial Data Translation: Apply data literacy to interpret sales, retail-out, and distribution data; identify root causes behind business trends and translate quantitative findings into strategic recommendations.
- Capability Expansion & Evolution: 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.
What You Need to Succeed (minimum qualifications)
- Education: 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.
- Required Experience: Minimum of 5 years of relevant hands-on experience in business intelligence, data engineering, or commercial data analytics.
- Top Skills: 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.
What will give you a competitive edge (preferred qualifications)
- 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.
Additional Information
- Travel: Up to 10% (Occasional travel as required for key meetings)
- Location: Global Elanco Headquarters - Indianapolis, IN - Hybrid Work Environment
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.
Benefits
- Relocation packages
- Two weeklong shutdowns
- Parental leave
- Employee Resource Groups
- Annual bonus
- Flexible work arrangements
- 401(k) matching
Company overview
Elanco Animal Health Incorporated is a global leader in the animal health pharmaceutical industry, dedicated to improving the health and well-being of both pets and farm animals worldwide. Founded in 1954 as a division of Eli Lilly and Company, Elanco became an independent public company in 2018 and has since grown to become the world's second-largest independent animal health company. With approximately 9,000 employees globally, the company operates with a clear purpose: 'making life better for animals, makes life better.' Elanco develops innovative medicines, vaccines, and health solutions that empower veterinarians, farmers, and pet owners to advance animal care. The company maintains a balanced portfolio between pet health and farm animal products, offering over 200 brands that address critical health challenges ranging from companion animal diseases to livestock productivity. Headquartered in Indianapolis, Indiana, Elanco is publicly traded on the New York Stock Exchange (NYSE: ELAN) and continues to drive innovation in animal health through strategic acquisitions and dedicated research and development efforts.