at an educational platform. The first analytical position in the company – building analytics from scratch, working with SQL and BI systems.
Tasks:
- Simple SQL queries to DWH (ClickHouse) based on clear specifications from the CTO
- Ad-hoc data extractions and reconciliations upon requests from product and marketing teams
- Support for existing dashboards in Metabase/PostHog: updates, minor improvements
- Gradual immersion into subscription unit economics: cohorts, retention, LTV, churn
Requirements:
- Basic confident SQL: JOIN, GROUP BY, simple window functions
- Experience (at least student/pet project) with any BI system – Metabase, DataLens, Power BI, Tableau
- Willingness to understand existing data logic, not just write your own queries
- Ability to work independently between synchronization points – there will be no constant supervision
Conditions:
- Remote
- Direct access to the CTO and company product metrics
- Real data from day one
Skills:
- SQL
- ClickHouse
- Metabase
- PostHog
- Python
- pandas