Marketing Analyst

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.

What are you working on?

• The name of the project(s): World Tour Merge
• Genres: Casual
• Platforms: iOS, Android

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