Close Back to


Associate BI Developer

Department: IT Infrastructure

Location: Cambridge, Cambridgeshire, United Kingdom

About the role: 

Abcam is looking for an Associate BI Developer to deliver reporting solutions to a variety of customers within Abcam.
Reporting to the BI Team Leader, the Associate BI Developer will be responsible for working with the BI Team and internal stakeholders to deliver data and reports as well as expanding our data warehouse.


Roles & responsibilities:

  •  Provide first line support on tactical requests to the BI team.
  • Build Tableau data sources, which can be used by internal stakeholders to self-serve their reporting needs.
  • Provide training and support in Tableau and other BI platforms to internal stakeholders.
  • Design and build new tables in our Oracle SQL Enterprise Data Warehouse.
  • Work with business users to understand and document requirements and communicate progress on projects.

About you:

  • You will be proficient with writing SQL code, preferably in either Microsoft (T-SQL) or Oracle (PL/SQL) dialects. This would include SELECT queries, joins and aggregation.
  • You will understand basic databasing principles like normalization, views and primary and foreign key relationships.
  • You will preferably have worked with data visualization tools like Tableau, Qlik or PowerBI or made dashboards and reports in Excel.
  • You will have a degree in a numerate subject.

About Us:

Ever since 1998, when our founder, Jonathan Milner, started selling antibodies from the back of his bike, Abcam has aimed to help scientific researchers make breakthroughs faster. We now have offices and labs in the UK, the US, China and Japan, and as we continue to grow, we remain ambitious, driven by our customers’ success and their research needs.
It’s our goal to provide a world-standard in protein research tools, technical support and delivery. When you join Abcam, you’ll join a global business with the passion and the vision to become the most influential company, and, best-loved brand in life sciences.
Our culture is our key differentiator. We believe in empowering individuals, with responsibility given at an early stage. The working environment is fun and fast-paced, collaborative and outcome focused, with a strong customer focus. In addition to competitive salaries, we offer an attractive and flexible benefits package (which includes shares for eligible employees), a culture focussed on wellbeing and opportunities for growth.