StellarTech is a B2C mobile publisher in EdTech: subscription apps, in-app monetization and performance marketing at scale. LTV prediction is how we decide where to invest, and the forecasting pipeline is already live. We are opening this role to have one senior analyst own its accuracy and its evolution. This is research and predictive analytics, not reporting: everything that can be standardised is already automated by Data Engineering, so the work is hypotheses, factor analysis and improvements to the prediction algorithm itself. You report to the Head of the Operational Department and work directly with Product, UA, Finance and Data Engineering.

What you will do

• Own and develop the LTV prediction algorithm: find the parameters and factors that increase forecast accuracy, prototype improvements in SQL, measure the gain, then hand the logic over to Data Engineering.
• Validate forecasts on closed cohorts, monitor forecast quality over time and explain where exactly a model deviates from actual LTV.
• Research what moves LTV: product features, segments, purchase sources (for example, purchases coming through CRM vs other sources), and adapt the prediction logic to them.
• Run analytical research end to end, from a vague question to a documented recommendation for Product, UA and Finance: where payback improves, where to concentrate media buying, what changes unit economics at company level.
• Automate analytical routines and model quality monitoring together with Data Engineering.

Requirements

Critical

• 4+ years in Data Analyst / Senior Data Analyst / Product Analyst roles with a product analytics focus: measuring the impact of factors on business metrics, not marketing attribution.
• Strong SQL: complex queries, window functions, optimisation. Here SQL is the main instrument for prototyping and testing the algorithm.