Data Engineer

This is a short-term contract engagement running to mid-August. The core need is focused but important: the team has approximately 20 surveys and associated datasets that need cleaning, standardising and properly mapped into a structured data warehouse layer. Day-to-day work will be a mix of hands-on SQL, some light dbt automation within Snowflake, CI/CD hygiene on GitHub and general data pipeline tidy-up.

Tableau and AWS are part of the wider stack but not required for this engagement. The primary focus is the warehouse layer itself.

There is genuine potential for this to extend beyond August as the organisation builds out its data product and moves into health economics modelling and AI-driven tooling.

What You Will Be Doing

• Auditing and cleaning approximately 20 surveys and their associated data, resolving inconsistencies in mappings and translations

• Writing and running SQL queries against Snowflake to interrogate, validate and transform data

• Building and maintaining dbt models to improve traceability, validation and automated testing within the pipeline

• Standardising CI/CD processes, including committing clean, version-controlled code to GitHub and keeping Snowflake in sync

• Applying GDPR best practice throughout, with particular attention to PII handling, cohort minimum thresholds and data anonymisation

• Solid hands-on SQL experience, comfortable writing complex queries from scratch

• Snowflake experience, ideally including warehouse management and automation

• Strong with dbt (data build tool) for pipeline modelling and testing

• Strong knowledge of ETL/ELT processes and data warehouse principles

• CI/CD experience with GitHub, including branching, commits and version control discipline

• A strong understanding of GDPR and data privacy requirements, particularly around health or sensitive personal data

• MySQL exposure is a plus

• Experience in health tech, public health or a data-sensitive sector is genuinely useful here, not just a nice-to-have

Brio Digital is working with a health tech company providing a platform that supports preventative care at scale, giving individuals meaningful feedback on their health while enabling organisations to understand workforce and population health trends.

The data underpinning this platform is sensitive, health-related and subject to strict GDPR and PII governance requirements. The team is cloud-native, running on Snowflake, AWS, GitHub and Tableau Cloud.