Senior Digital Analyst (Data Activation)

Responsibilities

• You’ll take technical ownership of Paid Media activation through our data warehouse, Reverse ETL and the surrounding data ecosystem.
• You’ll help move us away from manual checks towards proper production monitoring and observability of our marketing activation pipelines.
• You’ll use SQL and dbt to build and maintain Marketing-specific datasets used for customer audiences, conversion signals and other activation use cases.
• You’ll work with Analytics Engineering and Data Engineering on modelling patterns, architecture and standards, while developing increasing ownership of the Marketing-specific transformation layer.
• When something goes wrong, you’ll help diagnose where in the chain the problem exists. You’ll take an end-to-end view of the service without needing to own every underlying system.
• You’ll help teams understand whether a requirement is best solved through warehouse-based activation, our real-time tracking stack, an MMP such as Singular, another integration pattern or work from an upstream Engineering/Data team.

Requirements

• You’re comfortable using SQL to understand complex datasets and solve real production problems.
• You’ve worked with dbt or another code-based data transformation framework and understand the fundamentals of building maintainable data models.
• You’ve worked with production systems that move customer or event data between platforms.
• You have experience working with customer or marketing data including events, user attributes and identifiers. You understand how this impacts marketing performance.
• You have knowledge of event managers within advertising platforms (such as Google Ads, Meta, TikTok, etc…)
• You’re comfortable collaborating with Data Engineers, Analytics Engineers and Software Engineers.
• You can discuss technical trade-offs, contribute through Git/code review workflows and know when a problem needs expertise outside your own team.
• You’re comfortable with ambiguity and can take an unclear problem, investigate it, structure it and drive it towards a solution.

Preferred

• Experience independently owning production processes or data models
• Knowledge of Python
• Knowledge of APIs and third-party integrations
• Experience with Conversion APIs (CAPIs) of advertising platforms (such as Google Ads, Meta, TikTok, etc…)
• Experience with identity resolution, building customer and identity graphs
• Experience with a Mobile Measurement Partners such as Singular or Appsflyer