Data Architect (Product Data)

Company Description

For over 20 years, Abcam has been providing tools the scientific community needs to enable faster breakthroughs in critical areas like cancer, neurological disorders, infectious diseases, and metabolic disorders.

We believe that to continue making progress, we need to work together in new ways. We need your own unique perspective as well as this of our people to make an always greater impact on the world. This community needs people like you: dedicated, agile and above all audacious so we can truly bring progress forward.

Job Description

We are looking for aData Architectto set the vision for the organisation’s use of product data, through data design, to meet business needs. For this role, you should know how to analyse data models at source, model data at destinations (warehouses and other), define system requirements, and implement migration methods for existing data. Hands-on experience with SQL and PL/SQL is essential, as we use Oracle and other storage systems. 

Ideally, you are familiar with data visualization techniques using relevant tools (e.g. Tableau), and with basics of AWS and of Python. 

Ultimately, you will develop and maintain various data models which represent entities of abcam business, store them effectively, securely, and make sure that data can benefit your stakeholders. 

Continually seek to improve current services and capabilities in Data & Analytics 

Cooperate with stakeholders to model data at source systems that aligns with the Enterprise data model 

Develop and maintain core data models (primarily for products and transactions)

Work as a part of the greater Data Engineering to provide high quality, timely, data to stakeholders 

Cooperate with Data Governance to provide them insights and enable them to assign data ownership 

Develop database solutions to store and retrieve company information 

Analyse structural requirements for new software and applications 

Support data migrations from legacy systems to new solutions 

Improve system performance by conducting tests, troubleshooting and integrating new elements 

Optimise new and current database systems 

Define security and backup procedures 

Work with architecture to build a holistic picture of the Abcam enterprise environment 

Advisory for data governance 

Qualifications

Proven work experience as a Data Architect 

Good communication and organizational skills, stakeholder management 

In-depth understanding of database structure principles 

Experience gathering and analyzing system requirements 

Expertise in SQL and Oracle 

Proficiency in MS Excel 

Familiarity with data visualization tools (e.g. Tableau) 

Proven analytical skills 

Problem-solving attitude 

BSc in Computer Science, Computer Engineering or relevant field 

Additional Information

We know that when it comes to benefits, no one size fits all. Flexibility and choice matter which is why, in addition to market competitive salaries, we offer you a flexible benefits package which is tailored to your unique needs and support your financial, physical and emotional wellbeing. This includes 18 weeks fully paid maternity leave, 6 weeks fully paid paternity leave as well as highly flexible working and much more. Besides, your development will be integral to your experience here. You will grow alongside other talented minds, in ways you may often find unexpected.

When people come together, incredible things happen. Here you’ll work in a safe environment where you can be who you truly are. We’ll champion and celebrate your uniqueness throughout your journey with us. This is how we excel at partnering with the scientific community no matter the challenge, ultimately helping solve the world’s most critical diseases. Find out more about Diversity & Inclusion at Abcam.

#LI-CM1