SQL Analyst - Braze Segmentation

Advanced Resource Managers Ltd; City Of London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading recruitment consultancy is seeking an experienced SQL Analyst to work on a Customer Data Platform (CDP) project in London. The role involves defining audiences, pushing data to Braze, and collaborating with various teams. Candidates should have 3-6 years of experience in analytics with strong SQL skills and familiarity with data modeling in modern warehouses. This is a hybrid position with 3 days on-site work.

Qualifications

• 3 - 6+ years in analytics/marketing data roles with advanced SQL.
• Proven experience with CDP and/or reverse-ETL patterns.
• Experience building audiences at scale.

Responsibilities

• Own audience & trait definition for CRM and Marketing.
• Design pipelines to push data to Braze.
• Create a self-serve library of SQL snippets.

Skills

Advanced SQL

Data Modelling

Experience with Braze

Campaign Operations

QA Mindset

GDPR Understanding

Tools

dbt

Job description

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:

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.