Data Architect (Customer Data)

Cambridge Full-Time 43200 - 72000 £ / year (est.) No home office possible

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.

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

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

Identify and profile data sources with stakeholders, support data extraction and integration, contribute to the ELT process, create and maintain data mappings.

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.

Support data transformations, work with stakeholders to define, maintain, and manage changes.

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

Ensure data Security and Compliance, design access controls and rules, for properly encrypted data.

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

Optimize new and current database systems

Define security and backup procedures

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

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

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