About the role
About the Role
We are looking for a Senior Marketing Data Analyst to own our marketing data pipeline end-to-end, from extraction, through transformation in BigQuery, to data analysis and client-ready dashboards in Tableau.
This is a high-trust, high-autonomy role. You'll be the last line of defense before data reaches clients and internal stakeholders, so precision, proactive communication, and independent problem-solving matter just as much as technical skill.
What You'll Own
Data Pipeline & Extraction
- Manage data extraction from ad networks, MMPs (Adjust, AppsFlyer), and analytics tools (GA4) via Improvado into Google BigQuery. - Monitor pipeline health proactively, catch and flag broken feeds, delayed loads, or schema changes before they affect downstream reporting, not after a client notices.
Data Transformation & Modeling
- Build and maintain SQL transformations and data models in BigQuery, establishing clean, correct relationships across multiple data sources. - Write documented, reusable queries and scripts (SQL, Python and/or R) rather than one-off fixes.
Data Analysis & Insights
- Calculate and model LTV by cohort, channel, and campaign; own churn calculation and reporting. - Build predictive models for churn and LTV to support proactive retention and budget decisions. - Run cohort and retention curve analysis to track user quality over time. - Analyze CAC and monitor CAC:LTV ratios to guide acquisition spend; measure ROAS/ROI by channel and campaign. - Conduct funnel and conversion drop-off analysis to identify where users are lost. - Support attribution modeling (multi-touch/incrementality) to clarify true channel contribution. - Produce revenue, spend, and user-growth forecasts; contribute to media mix and budget allocation modeling.
Dashboarding & Visualization
- Design and maintain interactive Tableau dashboards that blend multiple data sources with correct joins and relationships. - QA every dashboard and report for accuracy before it reaches a client or stakeholder, numbers tie out, filters work, nothing is stale.
Quality & Ownership
- Take full ownership of data accuracy from source to dashboard; you self-check rather than relying on someone else to catch mistakes. - Proactively flag anomalies, discrepancies, or risks to your manager and stakeholders as soon as you spot them, no surprises, no last-minute fire drills.
Collaboration & Communication
- Partner directly with UA/performance marketers, clients, and stakeholders to define KPIs and refine reporting frameworks. - Communicate clearly and promptly: status updates, blockers, and caveats are shared before they become problems, not after.
What success looks like in your first 90 days:
- Full fluency with our Improvado → BigQuery → Tableau pipeline and current dashboard suite. - Zero client-facing data-quality escalations traceable to preventable errors. - At least one process improvement, automation, or QA safeguard you identified and implemented on your own initiative.
What We're Looking For
- 5–8 years of experience in data analytics, ideally within marketing, digital advertising, or performance-driven environments. - Strong SQL (BigQuery) and working proficiency in Python or R. - Hands-on experience with Improvado or a comparable UI-based data extraction tool. - Advanced Tableau skills, you can build multi-source dashboards with correct data relationships, not just single-table charts. - Experience with Adjust, AppsFlyer, GA4, and major ad networks. - Solid grasp of core marketing analytics metrics, LTV, CAC, churn, ROAS, retention/cohort analysis, and how to turn them into recommendations. - Comfortable building basic predictive/statistical models (e.g., churn or LTV prediction) using SQL, Python, or R. - A demonstrated track record of catching your own mistakes before they ship (be ready to talk through a real example in the interview). - Comfortable working with minimal supervision: you flag problems and propose solutions rather than waiting to be asked. - Excellent written and verbal English; you can explain data issues clearly to non-technical stakeholders.
Bonus Points
- Experience designing and analyzing A/B tests. - Familiarity with GCP tooling beyond BigQuery (Cloud Functions, Composer/Airflow, dbt). - Deeper machine learning experience for predictive analytics (beyond core churn/LTV models). - Additional languages beyond English.
Text as published by AF. We don't edit postings; apply and ask questions on the employer's site.