Main responsibilities:- Create and maintain ETL workflows that extract and provide various projects the information required, information that is stored in a Hadoop and Google Cloud Platformdata lake environment- Ensure data quality of newly created tables and fixing issues if any accured- Interact with various stakeholders in order to understand business needs and offer feedback and support in order to provide the info required in the best format- Create documentation related to the tasks delivered using ConfluenceTools and technologies used: Hive/Hadoop, Google BigQuery + BigQuery ML, IntelliJ, Gitlab, Spark

Main responsibilities:- Providing deep dive analysis (using SQL, Hive QL) and weekly KPIs reports for various mobile games- Presenting KPIs and deep dive analysis reports in weekly and monthly HQ meetings- Interacting with game design team and providing feedback on areas of improvement in the game based on user data- Creating Tableau dashboards for easy access to financial info for Producer and financial team and user behavior for game design team: retention, monetization, activity KPIs- Using R Studio for doing more in depth analysis (e.g. clustering analysis)- Create and validate tracking events that are used for in game analysis Tools and technologies used: Hive/Hadoop, Amazon Redshift, Microsoft SQL Server, Google BigQuery, Tableau, R Studio

Main responsibilities:- Managing the marketing activities for a couple of Facebook and mobile games;- KPI reporting;- Providing partners with all the required assets for promoting the games;- Reporting on results of the marketing activities;- Performing deep dive analysis for various games;