About SplashLearn At SplashLearn, our vision is to build the most engaging learning experiences that transform children into lifelong learners. We are the world's first scientifically-designed, game-based curriculum spanning Prekindergarten to Grade 5. Loved by a whopping 40 million learners across 150 countries and trusted by over 750k teachers and 180k schools, SplashLearn is the fastest growing elementary math program in the US. If those numbers seem too abstract, consider this: Every 1 in 3 schools and 1 in 7 elementary school children in the US love SplashLearn! Backed by Accel Partners and many other prominent investors, SplashLearn has bagged many prestigious edtech awards such as the Stevie Award for the best edtech product, Tabby Award for best business, Parents Choice Award and Best App Ever Award. Primary Skills -: SQL
- Should have expertise on building complex and highly optimized SQL queries Data modelling/ ETL
- Strong logical & analytical concepts in databases, schemas, dimensional modelling enabling fast and accurate access of metrics and its drill down BI Tools
- Experience of working with BI tools such as Looker, PowerBI, Tableau, Qlik Automation
- Strong rigor in automating repetitive tasks and processes Ability to multitask and work on a diverse range of requirements Ability to adapt to and learn new tools/ techniques (Hevo, Pentaho, Fivetran, Airflow etc.) quickly Attention to detail and strong data orientation Good to have -: Basic understanding of web analytics tools such as google analytics, mixpanel etc. Basic understanding of scripting languages (R, Python, etc.) Basic understanding of statistical concepts such as application of mean, median, percentile, variance, standard deviation, normal distribution, p value, confusion matrix etc. Responsibilities -: Design and develop complex data queries to move and transform data from operational data sources to analytical databases Act as a bridge between your team and the data engineering teams, you will ensure that proper table structures / solutions are built to draw insights and its fully validated Capture reporting requirements and design tables, metrics, reports and dashboards that enable stakeholders to gather understanding on activation rate, conversion rate, content consumption, engagement and retention Documentation
- Ensure meticulous documentation of processes, meta data, query logic, and results Experience -: * 2
- 4 years of analytics experience Culture at SplashLearn At SplashLearn, we dig individuality. We love people who have something to say, and we listen. With us, you will get a chance to weave a little bit of you in our suite of learning products that are being used by millions of users. We have a workplace that is perennially high on energy. You can find people deeply engrossed in conversations that range from the latest movie to the newest tech on the block, and you will also see people who don't want to have anything to do with that and are quietly typing away on their machines.