Commercial Business Intelligence Partner

Indiana Ag Connection; Indianapolis, Northern (IN, KY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Relocation packages

Hybrid work environment

Annual bonus offering

401K matching

Job summary

Elanco is seeking a Commercial Business Intelligence Partner to join our Enterprise Data & Analytics team in Indianapolis, IN. You will turn large-scale commercial data into actionable insights using Tableau, Databricks, and SQL, partnering with commercial stakeholders to translate questions into scalable data solutions.

As you grow, you will expand advisory footprint across enterprise functions, build executive dashboards, and drive data-driven decision making in a hybrid work environment.

Qualifications

• Minimum of 5 years of hands-on experience in business intelligence, data engineering, or analytics.
• Strong data literacy with ability to translate business needs into actionable data solutions.
• Experience designing dashboards and reports for cross-functional stakeholders.

Responsibilities

• Data Solution Architecture & Execution: transform large datasets with SQL and Databricks; build data models and views for dashboards.
• Dashboard Design & Visualization: create executive dashboards in Tableau (Power BI) tracking KPIs and sales performance.
• Stakeholder Partnership & Prioritization: work with cross-functional leaders to define questions and deliver timely analyses.
• Commercial Data Translation: interpret sales and distribution data to inform strategic recommendations.
• Capability Expansion & Evolution: support maturity initiatives and enable self-service analytics across the business.

Skills

Tableau

SQL

Databricks

Power BI

Education

Bachelor's degree in a quantitative field

Tools

Databricks

Tableau

Power BI

Job description

# Commercial Business Intelligence PartnerBack to search resultsApply to this positionFollow CompanyMore Jobs from ElancoSend to Friend**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. **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 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 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 packages* Two weeklong shutdowns (mid-summer and year-end) in the US (in addition to PTO)* 8-week parental leave* 9 Employee Resource Groups* Annual bonus offering* Flexible work arrangements* Up to 6% 401K matching #LI-JC1 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 Elanco 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.