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 customer data, through data design, to meet business needs. For this role, you should know how to analyze and profile data sources, 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 dbt (data build tool). It’s desirable that you have experience 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.
The Data Architect role is a part of the Data Engineering team and partners with corporate functions of Technical Operations, Customer Experience, New Product Development, Supply Chain, Manufacturing, HR, Finance and Procurement in a truly global business. This requires you to be agile, audacious, and dedicated to ensuring we’ve the right data architecture and capability in our teams to help our customers achieve their research missions, faster.
1. Continually seek to improve current services and capabilities in Data & Analytics
2. Work as a part of the greater Data Engineering to provide high quality, timely, data to stakeholders
3. Identify and profile data sources with stakeholders, support data extraction and integration, contribute to the ELT process, create and maintain data mappings.
4. Model data at source and destination to support the Enterprise Data Model. Own organised data models, usable and understandable by business stakeholders who analyse it.
5. Support data transformations, work with stakeholders to define, maintain, and manage changes.
6. Cooperate with Data Governance to provide them insights and enable them to assign data ownership.
7. Ensure data Security and Compliance, design access controls and rules, for properly encrypted data.
8. Analyse structural requirements for new software and applications
9. Support data migrations from legacy systems to new solutions
10. Improve system performance by conducting tests, troubleshooting and integrating new elements
11. Optimize new and current database systems
12. Define security and backup procedures
13. Work with architecture to build a holistic picture of the Abcam enterprise environment
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. Familiarity with data visualization tools (e.g. Tableau)
20. Proven analytical skills
21. Problem-solving attitude
22. 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