Business Intelligence Analyst

GB01 Elanco UK AH Limited; Hook; On-site; GBP 40,000 - 60,000; Full time

Job summary

Elanco in Hook, UK is seeking a Business Intelligence Analyst to translate sales, market and customer data into strategic recommendations. You will own and maintain the affiliate BI reporting suite across Tableau, Databricks and Power BI, collaborating with Heads of Sales and regional managers to evaluate campaigns and ROI.

The role focuses on automating data pipelines, enhancing data quality and availability, and ensuring GDPR compliance while building analytics capability across commercial

Qualifications

• University degree in a relevant field.
• Background in Business Intelligence, Commercial Analytics, Market Research or related consulting.
• Practical knowledge of BI reporting systems and SQL.
• Experience with Salesforce and CRM/data sources.
• Strong communication and ability to explain data clearly.

Responsibilities

• Lead diagnostic and predictive analysis across commercial units and regions.
• Own and maintain the affiliate BI reporting suite across Tableau, Databricks and Power BI.
• Translate data into strategic recommendations on performance, risks and opportunities.
• Automate reporting with scalable data pipelines and improve data quality.
• Provide training and share best practices while ensuring GDPR compliance.

Skills

Business Intelligence

Tableau

Power BI

SQL

Excel

Communication

Education

Bachelor's degree

Tools

Salesforce

Databricks

SQL

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:

Business Intelligence Analyst

Your Responsibilities:

• Lead diagnostic and predictive analysis across commercial business units and regions, translating sales, market and customer data into strategic recommendations on business performance, risks and opportunities.
• Own and maintain the affiliate business intelligence reporting suite across Tableau, Databricks and Power BI, integrating sales, customer activity, competitor and marketing data into a reliable single source of truth.
• Partner with Heads of Sales, Regional Sales Managers, Marketing and Territory Business Managers to communicate insights at the right level of detail and evaluate commercial initiatives, programme effectiveness and return on investment.
• Drive the transition from manual reporting to automated, scalable data pipelines, while identifying data gaps and developing practical solutions to improve data quality and availability.
• Build commercial analytics capability by sharing best practices and delivering training on Tableau, Microsoft Excel and reporting tools, while ensuring analytics and data management comply with GDPR, corporate data governance policies and local regulations.

What You Need to Succeed (minimum qualifications):

• University degree.
• Background in Business Intelligence, Commercial Analytics, Market Research or Management and Strategy Consulting.
• Practical knowledge of BI reporting systems, advanced Microsoft Excel and relational databases/SQL.
• Experience working with CRM platforms such as Salesforce and commercial or market datasets.
• Strategic business acumen with a consultative approach, strong communication and presentation skills, and the ability to explain complex data clearly to diverse audiences while managing multiple priorities with minimal supervision.

What will give you a competitive edge (preferred qualifications):

• Practical experience using and integrating AI tools into business or analytical workflows.
• Advanced experience with data transformation or business intelligence platforms such as Databricks, Power BI or Tableau.
• Experience in animal health, pharmaceuticals or an adjacent life sciences sector.

Additional Information:

• Travel: Up to 10% for affiliate conferences and regional sales meetings.
• Location: Hook, UK.

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.

Elanco Animal Health Incorporated (NYSE: ELAN) is a global leader in animal health dedicated to innovating and delivering products and services to prevent and treat disease in farm animals and pets, creating value for farmers, pet owners, veterinarians, stakeholders, and society as a whole. With nearly 70 years of animal health heritage, we are committed to helping our customers improve the health of animals in their care, while also making a meaningful impact on our local and global communities. At Elanco, we are driven by our vision of Food and Companionship Enriching life and our Elanco Healthy Purpose™ CSR framework – all to advance the health of animals, people and the planet. Learn more at www.elanco.com.