BI Analyst

IntellectoKids is one of the world's largest developers of educational apps for children from 3 to 7 years old. The company's apps are in the Top 15 in the Kids 5 & Under category in the App Store in 40 countries, including the United States.

We are seeking a Middle+ Product Analyst.

Responsibilities:

• Design, build, and maintain dashboards and reports for iOS, Android, and Web platforms

• Develop and optimize data models for data visualization

• Create and maintain ETL processes

• Establish unified methodology for key metrics calculation

• Ensure data quality and consistency across reports

• Provide analytical support to marketing and product teams: ad-hoc reports and regular reporting

Requirements:

• 2+ years of experience as a BI Analyst or in a similar role

• Strong SQL skills (complex queries, optimization, window functions)

• Hands-on experience building dashboards in Tableau or similar BI tools (Power BI, Looker, Metabase)

• Understanding of data warehouse architecture and data modeling principles

• Experience with ETL processes

• Solid understanding of key product and marketing metrics

Nice to have:

• Experience with Redshift (PostgreSQL), Tableau, Airflow stack

• Python proficiency for automation and data processing

• Experience with Adjust/AppsFlyer or similar MMPs

• Understanding of event-based analytics and cohort analysis

What we offer:

• Wide range of tasks in business intelligence and data visualization

• Opportunity to join a top team in the mobile EdTech segment

• Impact on the company's analytical infrastructure development

• Data-driven decision-making culture

• Remote work, paid sick leave, and vacation