SQL Analyst, CDP & CRM Segmentation
London based – hybrid working – 2-3 days on site
3-6 Month contract – Inside IR35
We’re standing up a Customer Data Platform (CDP) and need a hands-on SQL analyst to tighten audience segmentation, productionise segmentation logic in the warehouse, and push curated traits into Braze so CRM can operate campaigns without overloading the data team.
What you’ll do
* Own audience & trait definition
* Translate CRM/Marketing objectives into precise, reusable audience and trait specs
* Build and maintain warehouse-first segmentation tables/views with clear SLOs and documentation.
* Ship reliable data to Braze
* Design pipelines to push curated traits and audiences to Braze, including change-data capture and dependency handling.
* Set up monitoring/alerts and reconcile Braze counts vs. warehouse truth to ensure high confidence.
* Unblock campaign operations
* Create a self-serve library of SQL snippets, views, so CRM can launch campaigns without ad-hoc data requests.
* Implement suppression logic (deliverability, compliance, frequency caps) and guardrails.
* Partner across teams
* Work closely with Data Engineering, CRM, BI and Product to align event/identity strategy (user IDs, device IDs, email normalisation, consent flags).
* Advise on experiment targeting and measurement readiness (holdouts, lift, attribution inputs).
Must-have experience
* 3 - 6+ years in analytics/marketing data roles with advanced SQL
* Proven work with CDP and/or reverse-ETL patterns and Braze.
* Strong data modelling in a modern warehouse and experience with dbt.
* Building audiences at scale, including identity resolution and edge-case handling.
* Rigorous testing/QA mindset and production hygiene (version control, code review, observability).
* Understanding of privacy & consent in the UK/EU (GDPR, PECR) and operationalising suppression rules.