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.
1. Continually seek to improve current services and capabilities in Data & Analytics
2. Cooperate with stakeholders to model data at source systems that aligns with the Enterprise data model
3. Develop and maintain core data models (primarily for products and transactions)
4. Work as a part of the greater Data Engineering to provide high quality, timely, data to stakeholders
5. Cooperate with Data Governance to provide them insights and enable them to assign data ownership
6. Develop database solutions to store and retrieve company information
7. Analyse structural requirements for new software and applications
8. Support data migrations from legacy systems to new solutions
9. Improve system performance by conducting tests, troubleshooting and integrating new elements
10. Optimise new and current database systems
11. Define security and backup procedures
12. Work with architecture to build a holistic picture of the Abcam enterprise environment
13. Advisory for data governance
Qualifications
14. Proven work experience as a Data Architect
15. Good communication and organizational skills, stakeholder management
16. In-depth understanding of database structure principles
17. Experience gathering and analyzing system requirements
18. Expertise in SQL and Oracle
19. Proficiency in MS Excel
20. Familiarity with data visualization tools (e.g. Tableau)
21. Proven analytical skills
22. Problem-solving attitude
23. 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