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 a Data Architect to 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