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