You will own the digital-marketing data: the pipelines that bring advertising, social, web-analytics, email and app-store data into the warehouse, and the models that let the client see whether campaign spend turns into visitors and bookings.
What you will do
- Build and run connectors to advertising and social platforms, web analytics, email-marketing tools and app stores, current and future.
- Normalise campaign, spend, impression, click and conversion data across platforms so it can be compared.
- Maintain the attribution and UTM models and the marketing data marts that feed the dashboards and ROI analysis.
- Keep the connectors healthy through API changes, rate limits and credential rotations.
- Work with the marketing stakeholders to define the metrics and reconcile them with platform reports.
- Write the monthly progress report for the marketing data stream.
What you need
- Python connectors with pagination, rate limiting, retries and incremental loads
- Hands-on experience with at least two advertising or social APIs (Meta, Google Ads, Snapchat, TikTok, X)
- GA4 data model and the GA4 export to BigQuery
- Email-marketing platforms and app-store download data as sources
- A marketing-data connector such as Funnel.io or Supermetrics
- SQL and warehouse modelling for campaign and conversion data
- Attribution and UTM fundamentals: multi-touch models, campaign taxonomies, deduplication across platforms
Good to have
- Google Ads and GA4 certifications
- Marketing-mix or incrementality modelling
- Arabic and regional ad platforms