Data Analyst

3 Months ago • 2 Years +

Data Analysis

Job Description

Ilyon is seeking a curious and technically skilled Data Analyst, fluent in SQL and comfortable with BI tools, with an added edge in data science knowledge. This role involves generating business-critical insights, contributing to light modeling projects like segmentation or LTV forecasting, and diving into data to explain key findings. Responsibilities include analyzing user behavior, monitoring campaign performance (ROAS, CPI, LTV), supporting UA and marketing teams with dashboards, tracking revenue KPIs, and writing advanced SQL queries for large datasets.

Good To Have:

Familiarity with tools like Appsflyer, Firebase, Google Ads, Meta Ads.
Experience working with marketing, creative, or monetization teams.
Exposure to financial reporting, revenue forecasting, or cohort-based analysis.
Understanding of DAX, or light Python scripting for automation.

Must Have:

Analyze user behavior, funnels, monetization, and retention across games or apps.
Monitor, analyze, and visualize campaign performance: ROAS, CPI, LTV, retention.
Evaluate creative tests and channel efficiency across paid UA platforms.
Support UA and marketing teams with daily dashboards, budget pacing, and insights.
Work closely with finance and monetization teams to track revenue KPIs.
Respond to business questions with ad hoc SQL analyses.
Support forecasting models for LTV, ROI, and spend planning.
Collaborate on cohort modeling, funnel analysis, and time-series reporting.
Investigate data anomalies, test hypotheses, and answer complex business questions.
Apply statistical techniques such as regression, cohort analysis, or hypothesis testing.
Write advanced SQL to query large datasets from BigQuery and Snowflake.
Work closely with BI/data engineering to structure data models for scalable analysis.
Build, own, and maintain reports in data visualization tools.
Create automated data pipelines or queries for recurring business reporting.
Ensure clear, accurate, and accessible data for marketing and finance stakeholders.

Add these skills to join the top 1% applicants for this job

communication

data-analytics

financial-data-analysis

forecasting-budgeting

budget-management

game-texts

business-analysis

automated-testing

data-visualization

power-bi

looker

tableau

data-science

python

sql

firebase

Description

We’re looking for a curious and technically skilled Data Analyst who’s fluent in SQL, comfortable with BI tools, and brings an extra edge with data science knowledge. In this role, you’ll generate business-critical insights and contribute to light modeling projects such as segmentation, or LTV forecasting.

This is a perfect role for someone who loves diving into data, explaining what matters, and occasionally applying statistical techniques when deeper insights are needed.

Business Analytics & Insight

Analyze user behavior, funnels, monetization, and retention across games or apps.
Monitor, analyze, and visualize campaign performance: ROAS, CPI, LTV, retention.
Evaluate creative tests and channel efficiency across paid UA platforms (Meta, Google, TikTok, etc.) and support UA and marketing teams with daily dashboards, budget pacing, and insights.
Work closely with finance and monetization teams to track revenue KPIs.
Respond to business questions with ad hoc SQL analyses.
Support forecasting models for LTV, ROI, and spend planning.
Collaborate on cohort modeling, funnel analysis, and time-series reporting.
Investigate data anomalies, test hypotheses, and answer complex business questions.
Apply statistical techniques such as regression, cohort analysis, or hypothesis testing.

Reporting & Dashboarding

Write advanced SQL to query large datasets from BigQuery and Snowflake.
Work closely with BI/data engineering to structure data models for scalable analysis.
Build, own, and maintain reports in data visualization tools.
Create automated data pipelines or queries for recurring business reporting.
Ensure clear, accurate, and accessible data for marketing and finance stakeholders.

Requirements

2+ years of experience in data analytics or a related role.
Proficiency in SQL for data querying and exploration.
Strong analytical skills and business intuition.
Experience with data visualization tools (e.g.,Power BI, Looker, Tableau).
Familiarity with Python or other scripting languages for ad hoc analysis.
Excellent communication skills – able to explain complex data in simple terms.
Familiarity with tools like Appsflyer, Firebase, Google Ads, Meta Ads- an advantage.
Experience working with marketing, creative, or monetization teams- an advantage.
Exposure to financial reporting, revenue forecasting, or cohort-based analysis- an advantage.
Understanding of DAX, or light Python scripting for automation- an advantage.