About us:

Games2win is one of the largest casual mobile gaming companies in the world. We own over 50 proprietary mobile games with over 210 million downloads and have an extremely strong daily and monthly active user base. Games2win is the publisher of global hit titles such as Driving Academy, Stories for Friends, International Fashion Stylist, Parking Frenzy, High School Driving Test, and many other hit games. Some of our games such as Parking Frenzy have ranked #1 on the US iTunes App Store (free app & game). Power Cricket T20 is ranked #1 in the India Sports category. Almost all of our Mobile Games have hit top app store ranks.

Top investors such as Clearstone Venture Partners, Nirvana Venture Advisors and Silicon Valley Bank have funded G2W. The founders of G2W Inc. are Alok Kejriwal – a Serial Entrepreneur and Mahesh Khambadkone – an Online Gaming Specialist.

Play our games available on the Android and iTunes App Stores or visit us on games2winmedia.com to learn more about our Company.

 Job description

(Please read this entire JD carefully. There is a call for action request at the end of the post that you need to action should you be interested in applying for this job)

 Based in: Mumbai

Reporting to: Manager Analytics

Experience Require – Minimum 1 Years of Experience

What do you need to do? (Role and Responsibilities)

    • Help the Business Analytics team to collect and collate data from various tools.
    • Create reports as per the format defined by the team.
    • Timely creation of reports and maintain the schedule for these reports.
    • Make sure that all the required data points defined are present and are being collected by the tools being used.
    • Do a first level analysis of the reports created and highlight any major changes on data points.

 Who could you be? Background and Experience:

  • You are working or have worked in a technical or analytics job function for at least 1 year.
  • Analytical mind-set with good communication skills and interpersonal capabilities.
  • Can work confidently with EXCEL and SQL.
  • Must be able to prioritize multiple assignments, with a high degree of accuracy, and function quickly in a fast paced, deadline oriented environment.

 Educational Qualification:

Graduate/Diploma Degree holder in Science/Commerce fields or any other equivalent educational background.

Next Steps:

Part 1: If this opportunity excites you then send us a note on which Analytics tools you’ve used in the past and why do you use them.

Part 2:

Consider the data_table at the below link:

https://docs.google.com/spreadsheets/d/1WYhKiREeIJFsDG6Z-uqKnwRiwG8FwK5GznrPKCVvsXQ/edit?usp=sharing

Below is a snippet of the table for your reference:

id country date item_name iap_price
1C91E019A6B349FBA63233528F1F0099 United States 31-10-2018 budget 1.99
BC3BA5F6D7024DF3AF2E253C66DD954A United States 26-12-2018 budget 1.99
A87D86FBF0754DED8A4FF70B6FCCA51F United States 27-12-2018 budget 1.99
2A07E2D8F8F14238BC1934D9900D20C0 United States 21-01-2019 budget 1.99
BB0BE1B3526A459B8C13D1E8B5904042 United States 27-01-2019 budget 1.99
59561537C55743A9BD576DF020C07873 United States 02-02-2019 everything 34.99
73A505AF04694578AF7F6389D100459A United States 06-02-2019 budget 1.99
221AE05FF3CE40E9B8CD6C22F146C8DF United States 07-02-2019 everything 34.99
259C25279045410DB733407852A149FC United States 07-02-2019 budget 1.99

What are the SQL queries that you will use to get the below data points?

  1. Total unique users who bought something, how many items did they buy on average and the average price point of each item bought.
  2. Total items sold and the average price point of the items overall.
  3. Top 3 items sold daily and revenue from these Top 3 items daily.
  4. Total revenue made from each item broken down by country and day.

Best of Luck!

Send your thoughts with your introduction and expectations to: hr@games2win.com