Senior Marketing Data Analyst

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.