Marketing analyst

What are you working on? The name of the project(s): World Tour Merge Genres: Casual Platforms: iOS, Android SoloBand Games is an independent mobile game studio based in Cyprus. Our flagship project is World Tour Merge, a merge-2 casual puzzle game with IAP-driven monetization (~95% of revenue). Our core audience is primarily women aged 30 in Tier-1 countries. For which tasks (responsibilities)? We are looking for a Marketing Analyst who will work side by side with the CMO and own the bridge between data infrastructure → business model → UA decisions. We need someone who will turn it into an actionable business system and keep evolving it. What is already in place BigQuery: main DWH Airflow on Cloud Composer: DAGs for API ingestion and dbt runners (schedules, retries, alerts) Tableau: primary BI platform (Predict, Funnel, Progress Dashboard, Marketing Dashboard) Git (GitHub) GitHub Actions for deploying DAGs to Composer 2 versions of predictive LTV models in prod What you’ll be doing: Marketing analytics and research Cohort research: elasticity of ARPU to Retention, impact of D1/D7/D14 on D30/D60 ARPU, splitting incent vs non-incent traffic Channel cannibalization: matrix of attribution chain contributions, impact of paid networks on organic Payer segmentation: tiering by revenue, payer retention, repeat purchase patterns Level funnel analysis with marketing cuts (network × campaign × geo) Forecasting and business modeling Maintain and evolve the predictive LTV model (cohort × channel × country × OS): validate accuracy on new data, tune coefficients, investigate forecast-vs-actual deviations; ROAS curve and payback window: build and update ROAS curves, calculate target ROAS by segment, run scenario analysis; Business plan co-owned with CMO: revenue, budget, and payback forecasts. A management model for UA spend decisions. BI and reporting Tableau dashboards: UA operations, forecast control, funnel progression, channel-level operational view; Automation of optimization documents for ad channels; Working with leadership Direct collaboration with CMO: prioritization, hypothesis discussions, decision framing; Presenting results and models to the Leadership Team; Supporting the UA team in budget and growth-area decisions What kind of professional are we looking for? 3 years in marketing/product analytics, ideally in gamedev or mobile-tech; Strong SQL window functions, CTEs, query optimization on large tables. BigQuery is a plus; Hands-on dbt experience (models, tests, snapshots, macros) is required. If you have limited dbt experience but strong SQL and an Analytics Engineering mindset - open to discussion; Experience with Airflow or another orchestrator (Dagster, Prefect), you understand DAGs, schedules, retries; Tableau or another BI tool (Looker, PowerBI, Metabase) building dashboards end-to-end; Git, basic understanding of CI/CD; Mobile attribution fundamentals: Adjust/AppsFlyer, last-touch vs probabilistic, reattribution; Cohort analysis: cohort formation, retention curves, cumulative revenue, the difference between cohort and calendar views; IAP monetization: revenue structure, store fees, VAT, gross vs net, refunds; Financial modeling: building revenue and payback forecasts, working with scenarios Why do we enjoy working here? B2B contract Competitive compensation aligned with your experience and the value you bring 20 days of paid vacation 5 paid sick days per year A small, senior team where your work is visible and your voice actually matters Flat structure, zero bureaucracy