Commercial Business Intelligence Partner

Posted 4 Days Ago
Be an Early Applicant
Indianapolis, IN, USA
In-Office
Senior level
Healthtech • Pharmaceutical • Manufacturing
The Role
Build and transform commercial data solutions using SQL and Databricks, create executive dashboards in Tableau and Power BI, and translate ambiguous business questions into actionable insights. Partner with commercial stakeholders on sales, retail-out, and distribution analytics; identify business trends, standardize reporting, and support enterprise self-service analytics and data maturity initiatives.
Summary Generated by Built In

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.

Skills Required

  • Bachelor’s degree in a quantitative field such as Business Analytics, Computer Science, Statistics, Mathematics, or Information Systems, or equivalent experience
  • At least 5 years of relevant hands-on experience in business intelligence, data engineering, or commercial data analytics
  • Advanced Tableau expertise
  • Strong proficiency in SQL and large dataset analysis using Databricks or data lakes
  • Ability to translate ambiguous business needs into actionable data solutions under tight turnaround times
  • Power BI experience
  • Experience with commercial, sales, retail-out, or distribution data in CPG, Retail, Pharmaceutical, or Animal Health industries
  • Experience querying and modeling data in Databricks and modern cloud data warehouse architectures
  • Working knowledge of Python for advanced data manipulation or automation
  • Ability to balance multiple stakeholder priorities, communicate trade-offs, and set realistic expectations
  • Experience collaborating with global cross-functional teams and supporting enterprise analytics transformation

Elanco Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Elanco and has not been reviewed or approved by Elanco.

  • Leave & Time Off Breadth — Time off options are broad, including PTO, flexible leave, and the ability to purchase additional vacation. These provisions are highlighted as supportive of work-life balance.
  • Healthcare Strength — Health coverage includes medical, dental, and vision alongside company-paid life, disability, and wellness support. Pet insurance and assistance programs reinforce a comprehensive wellbeing offering.
  • Retirement Support — Retirement offerings include a U.S. 401(k) and, for some employees, access to a defined benefit pension. These programs add meaningful long-term value to total rewards.

Elanco Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Indianapolis, IN
8,445 Employees

What We Do

At Elanco, we work to improve the health of animals through innovative products and services for pets and farm animals around the world. As a global animal health company, we provide solutions that empower our customers to advance a vision of Food and Companionship Enriching Life. Since 1954, Elanco has committed to empowering veterinarians, farmers, and all those who care for animals with the tools they need to help animals live healthy lives. Healthier animals are the key to making our lives better - This is the fundamental belief uniting all global Elanco employees. That’s why we are committed to the idea that our business can be a unique force for good for all in society. Through our Elanco Healthy Purpose™ framework of Environmental, Social and Governance (ESG) commitments, we focus on delivering sustainable solutions to advance the well-being of animals, people and the planet. This program also enables our employees around the world to take paid time off to make an impact as a volunteer, offering their time or talent to give back to our customers, causes and communities. #ElancoHealthyPurpose #WeAreElanco

Similar Jobs

PwC Logo PwC

Pricing, Promotions, and Revenue Management Consulting Director

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
47 Locations
370000 Employees
155K-410K Annually

PwC Logo PwC

Architect

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
52 Locations
370000 Employees
77K-202K Annually

PwC Logo PwC

R&I Managed Services Deals Desk Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
69 Locations
370000 Employees
91K-322K Annually

General Motors Logo General Motors

People Analytics Enablement Leader

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
179K-273K Annually

Similar Companies Hiring

Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees
Vitalize Thumbnail
Artificial Intelligence • Healthtech • Software
US
50 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
55 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account