SQL Analyst -- Braze Segmentation

SQL Analyst, CDP & CRM Segmentation

London based - hybrid working - 3 days on site

3-6 Month contract - Inside IR35

Why this role exists

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.

Disclaimer:

This vacancy is being advertised by either Advanced Resource Managers Limited, Advanced Resource Managers IT Limited or Advanced Resource Managers Engineering Limited ("ARM"). ARM is a specialist talent acquisition and management consultancy. We provide technical contingency recruitment and a portfolio of more complex resource solutions. Our specialist recruitment divisions cover the entire technical arena, including some of the most economically and strategically important industries in the UK and the world today. We will never send your CV without your permission. Where the role is marked as Outside IR35 in the advertisement this is subject to receipt of a final Status Determination Statement from the end Client and may be subject to change.