Senior Marketing Data Analyst

This is a fully remote position, open to applicants in France.

📋 Description

• Oversee the extraction of data from advertising networks, mobile measurement partners (Adjust, AppsFlyer), and analytics tools (GA4) into Google BigQuery via Improvado.

• Assess pipeline performance and detect any broken feeds, delays in loading, and changes in schema.

• Develop and sustain SQL transformations and data models within BigQuery.

• Establish appropriate relationships among various data sources.

• Create documented, reusable SQL, Python, and/or R queries and scripts.

• Calculate and model lifetime value (LTV) by cohort, channel, and campaign.

• Take responsibility for churn calculation and reporting.

• Construct predictive models for churn and LTV.

• Execute cohort and retention curve analyses.

• Evaluate customer acquisition cost (CAC), CAC:LTV ratios, return on ad spend (ROAS), and ROI by channel and campaign.

• Conduct analysis of funnels and conversion drop-offs.

• Assist with multi-touch and incrementality attribution modeling.

• Generate forecasts for revenue, spending, and user growth.

• Contribute to media mix and budget allocation modeling.

• Design and maintain interactive Tableau dashboards that blend multiple data sources.

• Ensure the accuracy of dashboards and reports through quality assurance before delivery to clients and stakeholders.

• Take responsibility for data accuracy from the source to the dashboard.

• Actively report anomalies, discrepancies, risks, blockers, and caveats.

• Collaborate with user acquisition/performance marketers, clients, and stakeholders to establish KPIs and refine reporting frameworks.

• Provide timely and clear status updates while communicating data issues to non-technical stakeholders.

• Achieve fluency in the Improvado → BigQuery → Tableau pipeline and dashboard suite within the initial 90 days.

• Independently implement at least one process improvement, automation, or quality assurance safeguard within the first 90 days.

⛳️ Requirements

• 5–8 years of experience in data analytics, preferably in marketing, digital advertising, or performance-oriented environments.

• Proficient in SQL (BigQuery) with working knowledge of Python or R.

• Practical experience with Improvado or a similar UI-based data extraction tool.

• Advanced skills in Tableau, including the ability to create multi-source dashboards with accurate data relationships.

• Familiarity with Adjust, AppsFlyer, GA4, and leading ad networks.

• Strong understanding of LTV, CAC, churn, ROAS, retention/cohort analysis, and marketing analytics metrics.

• Comfortable constructing basic predictive/statistical models, such as churn or LTV predictions, using SQL, Python, or R.

• Proven ability to identify errors before they are released.

• Able to work independently while proposing solutions.

• Excellent written and verbal communication skills in English.

• Experience in designing and analyzing A/B tests is a plus.

• Familiarity with GCP tools beyond BigQuery, such as Cloud Functions, Composer/Airflow, and dbt, is a plus.

• Additional machine learning experience for predictive analytics is a plus.

• Proficiency in languages other than English is a plus.

🏝️ Benefits

• A high-trust, high-autonomy position.

• The chance to manage the marketing data pipeline from start to finish.

• Additional languages beyond English are appreciated as a bonus.