← Todas as vagas

Senior Marketing Data Analyst

Sobre a vaga

• Manage data extraction from ad networks, MMPs (Adjust, AppsFlyer), and analytics tools (GA4) via Improvado into Google BigQuery
• Monitor pipeline health and identify broken feeds, delayed loads, and schema changes
• Build and maintain SQL transformations and data models in BigQuery
• Establish correct relationships across multiple data sources
• Write documented, reusable SQL, Python, and/or R queries and scripts
• Calculate and model LTV by cohort, channel, and campaign
• Own churn calculation and reporting
• Build predictive models for churn and LTV
• Run cohort and retention curve analysis
• Analyze CAC, CAC:LTV ratios, ROAS, and ROI by channel and campaign
• Conduct funnel and conversion drop-off analysis
• Support multi-touch and incrementality attribution modeling
• Produce revenue, spend, and user-growth forecasts
• Contribute to media mix and budget allocation modeling
• Design and maintain interactive Tableau dashboards blending multiple data sources
• QA dashboards and reports for accuracy before delivery to clients and stakeholders
• Take ownership of data accuracy from source to dashboard
• Proactively flag anomalies, discrepancies, risks, blockers, and caveats
• Partner with UA/performance marketers, clients, and stakeholders to define KPIs and refine reporting frameworks
• Provide clear and prompt status updates and communicate data issues to non-technical stakeholders
• Become fluent in the Improvado → BigQuery → Tableau pipeline and dashboard suite within the first 90 days
• Implement at least one process improvement, automation, or QA safeguard independently within the first 90 days

• 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, including multi-source dashboards with correct data relationships
• Experience with Adjust, AppsFlyer, GA4, and major ad networks
• Solid grasp of LTV, CAC, churn, ROAS, retention/cohort analysis, and marketing analytics metrics
• Comfortable building basic predictive/statistical models, such as churn or LTV prediction, using SQL, Python, or R
• Demonstrated track record of catching mistakes before they ship
• Comfortable working with minimal supervision and proposing solutions
• Excellent written and verbal English
• Experience designing and analyzing A/B tests is a bonus
• Familiarity with GCP tooling beyond BigQuery, including Cloud Functions, Composer/Airflow, and dbt, is a bonus
• Deeper machine learning experience for predictive analytics is a bonus
• Additional languages beyond English are a bonus

• High-trust, high-autonomy role
• Opportunity to own the marketing data pipeline end-to-end
• Additional languages beyond English valued as a bonus