Commercial Business Intelligence Partner

Summary

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 PartnerAs a Commercial Business Intelligence Partner, you will join our Enterprise Data & Analytics team to turn complex commercial data into actionable insights thatdrivebusiness 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.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 EnvironmentDon'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 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:Multiple relocation packagesTwo weeklong shutdowns (mid-summer and year-end) in the US (in addition to PTO)8-week parental leave9 Employee Resource GroupsAnnual bonus offeringFlexible work arrangementsUp to 6% 401K matching#LI-JC1Elanco 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 statusElanco may use automated tools, including AI, to support parts of our recruitment process, such as reviewing applications against job‑related criteria and/or transferrable skills. These tools help ensure a consistent, structured evaluation, but they do not make hiring decisions. All decisions involve a human reviewer. For more information on how we handle personal data, please see our Elanco Workforce Privacy Notice.SummaryLocation: Indianapolis, INType: Full time

Job Description

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 PartnerAs a Commercial Business Intelligence Partner, you will join our Enterprise Data & Analytics team to turn complex commercial data into actionable insights thatdrivebusiness 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.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 EnvironmentDon'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 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:Multiple relocation packagesTwo weeklong shutdowns (mid-summer and year-end) in the US (in addition to PTO)8-week parental leave9 Employee Resource GroupsAnnual bonus offeringFlexible work arrangementsUp to 6% 401K matching#LI-JC1Elanco 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 statusElanco may use automated tools, including AI, to support parts of our recruitment process, such as reviewing applications against job‑related criteria and/or transferrable skills. These tools help ensure a consistent, structured evaluation, but they do not make hiring decisions. All decisions involve a human reviewer. For more information on how we handle personal data, please see our Elanco Workforce Privacy Notice.SummaryLocation: Indianapolis, INType: Full time