Marketing Analytics & AI Foundations Lead

Elsevier; City Of London; On-site; GBP 41,000 - 69,000; Full time

Benefits offered by this job

Wellbeing initiatives

Shared parental leave

Study assistance

Sabbaticals

Job summary

Elsevier is hiring to build trusted data foundations powering dashboards and AI products for marketing performance. You will develop dbt models, a semantic layer, and data quality controls while also creating AI agents that provide monthly performance commentary.

You’ll sit in a small, agile team reporting to the Marketing Performance Director and collaborate with Data Ops and marketing stakeholders. You’ll apply strong SQL/Python skills and extensive dbt experience to create reliable analytics

Qualifications

• 3+ years building production data and analytics systems with SQL and Python.
• Strong dbt experience including modelling, testing, macros.
• Good dimensional modelling fundamentals (grain, conformed dimensions, slowly changing dimensions).
• Hands-on experience with LLMs (agents, tool/function calling, retrieval) in production.
• Solid engineering habits: version control, testing, CI and documentation.
• Ability to build relationships across teams and translate marketing questions into answers.

Responsibilities

• Design and build the dbt models and semantic layer behind dashboards and AI products with clear standards, tests, lineage and documentation.
• Build and run AI agents for marketing on Snowflake, dbt semantic layer, MCP connections and LLM tools; help define architecture roadmap.
• Create a simple evaluation approach: standard question sets with expected answers, regression checks before each release, open reporting on accuracy.
• Set up and maintain UAT environment and a repeatable path to production.
• Work with Data Ops and marketers to understand the decisions they need to make; document as you build.

Skills

SQL

Python

dbt

LLMs

Data modelling

CI/CD

Communication

Tools

Snowflake

Tableau

MCP connections

Salesforce

Adobe Analytics

Braze

Sprinklr

Job description

Elsevier is hiring to build trusted data foundations powering dashboards and AI products for marketing performance. You will develop dbt models, a semantic layer, and data quality controls while also creating AI agents that provide monthly performance commentary.

You’ll sit in a small, agile team reporting to the Marketing Performance Director and collaborate with Data Ops and marketing stakeholders. You’ll apply strong SQL/Python skills and extensive dbt experience to create reliable analytics