Senior Data Engineer

Senior Data Engineer job in London – DOE

About CluePoints

CluePoints is transforming the way clinical trials are conducted through advanced Risk-Based Quality Management (RBQM) and Data Quality Oversight solutions. By combining statistics, artificial intelligence, and machine learning, the company helps life sciences organisations improve the quality, accuracy, and integrity of clinical trial data, accelerating the delivery of safer and more effective treatments to patients worldwide.

As a fast-growing international technology business, CluePoints brings together professionals from more than 20 nationalities, creating a collaborative and innovative culture built around continuous learning and flexibility. Guided by the values of Care, Passion, and Smart Disruption, the company is committed to delivering AI-driven insights that enhance clinical research and improve patient outcomes.

This role is ideally based on a hybrid working model in London.

The Role

CluePoints is looking for an experienced Senior Data Engineer to join its Finance team and contribute to the continued development of the organisation’s Data & Analytics capabilities.

This position will play a central role in designing, implementing, and maintaining a scalable enterprise data platform. Working within the Data & Analytics team, you will be responsible for building and optimising a centralised data warehouse infrastructure that supports reporting, analytics, and data-driven decision making across the business.

Using your expertise in Kimball data modelling and Azure technologies, you will develop reliable data pipelines and ensure data from multiple sources is integrated consistently and efficiently. You will work closely with Senior Data Analysts to provide curated and aggregated datasets that support Power BI reporting and business intelligence requirements.

The current data platform is based on a Medallion architecture and Kimball methodology, supporting more than 70 Power BI models and delivering thousands of insights to stakeholders throughout the organisation.

Key Responsibilities

• Lead the design and implementation of scalable and efficient data architecture solutions within Microsoft Azure.
• Develop and maintain ETL processes using Azure Data Factory to integrate data from multiple sources.
• Design and optimise staging and production layers within the enterprise data warehouse.
• Ensure data quality, consistency, and integrity through governance frameworks, monitoring processes, and quality assurance procedures.
• Analyse source systems, APIs, and raw datasets to support effective data ingestion and transformation.
• Maintain technical documentation, including data dictionaries and data models.
• Share knowledge and best practices across the team to support continuous improvement.
• Collaborate closely with Senior Data Analysts to support complex SQL queries and Power BI reporting requirements.
• Provide reporting support and continuity when required.
• Work effectively within a hybrid and globally distributed environment.
• Communicate technical concepts clearly to both technical and non-technical stakeholders.

Skills and Experience Required

The ideal candidate will possess extensive experience designing and managing enterprise data warehouses and delivering scalable cloud-based data solutions.

Essential Requirements

• At least seven years of hands-on experience designing and maintaining data warehouse solutions using Kimball methodology.
• Strong experience with Azure Data Factory for ETL development.
• Expertise in Azure SQL Server, Azure DevOps, Key Vault, and Logic Apps.
• Advanced data modelling skills with the ability to create scalable warehouse architectures.
• Proven experience optimising data loads for performance, reliability, and scalability.
• Understanding of modern data technologies and the ability to design solutions that support future business growth.
• Experience integrating data from multiple systems while ensuring accuracy and consistency.
• Strong troubleshooting and problem-solving capabilities across data pipelines and infrastructure.
• Ability to work closely with analysts, stakeholders, and cross-functional teams.
• Familiarity with Agile development methodologies and CI/CD practices.

Desirable Skills

The following experience would be advantageous:

• Previous experience working within a Software-as-a-Service (SaaS) environment.
• Familiarity with Microsoft Power BI for reporting and visualisation.
• Knowledge of Azure cost optimisation and cloud resource management.
• Experience with scripting languages such as Python, PowerShell, or Bash.
• Understanding of data quality frameworks and monitoring practices.
• Exposure to Microsoft Fabric technologies, including Fabric Data Factory, Lakehouse, and Warehouse components.
• Experience designing hybrid data architectures that combine data lakes and data warehouses within Azure environments.

Current Technology Stack

The existing data ecosystem includes:

• Enterprise Data Warehouse built using Medallion architecture.
• Kimball dimensional modelling methodology.
• Azure Data Factory.
• Azure SQL Server.
• Power BI, supporting more than 70 reporting models.
• Thousands of analytical insights delivered to business stakeholders.

Benefits

CluePoints offers a comprehensive benefits package for employees based in the United Kingdom, including:

• Private Medical Insurance through Vitality Health, including full hospital cover, 24/7 GP access, and therapy sessions.
• Group Critical Illness Cover provided by Aviva.
• Life Insurance with death-in-service cover.
• Pension scheme with a 9% employer contribution through Scottish Widows.
• Sponsored certifications and professional development opportunities.
• Hybrid working model designed to support flexibility, collaboration, and team engagement.
• A vibrant culture focused on learning, innovation, and social interaction.

Diversity and Inclusion

CluePoints is committed to providing equal opportunities and fostering an inclusive workplace where everyone can thrive. Applications are welcomed from individuals of all backgrounds, regardless of age, disability, gender identity, marital status, pregnancy or maternity, race, religion or belief, sex, or sexual orientation.

All personal information provided during the recruitment process will be handled in accordance with UK GDPR and the Data Protection Act 2018 and will only be used for recruitment purposes.

This is an outstanding opportunity for a Senior Data Engineer job in London looking to join a rapidly growing technology company at the forefront of e-clinical innovation and help shape the future of clinical research through data-driven solutions.