Product Analyst - Gurugram

About the Opportunity:

Role : Product Analyst

Level : Senior Executive/Assistant Manager

Location : Gurugram

Function : Adtech

About the Function

Adtech @makemytrip is a new area where we help MMT monetize its users largely through Marketplace and Impact advertisements. MMTs premium audiences are in demand for most of the advertisers and we help the advertisers reach the right target audience at the right place and at the right time through the right messaging. Adtech is one of the fastest growing businesses inside MMT and have all the ingredients to be one of the significant contributors to our bottom-line.

About the Role

As a Product Analyst, you will be responsible for maintaining large size data in an easily trackable format, data analysis and deriving/leveraging meaningful insights for business.

What will you be doing

• Create and maintain rich interactive visualizations through data interpretation and analyze integrated reporting components from multiple data source.
• Data mining using state-of-the-art methods.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
• Develop and execute database queries and conduct analyses.
• Work with management to prioritize business and information needs

What are you required to bring to the team

• Knowledge of Advanced SQL queries, Python and Advanced Excel is must.
• Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
• Familiarity with BI technologies.
• Adept at queries, report writing and presenting findings.
• Strong interpersonal skills to effectively drive complex projects within as well as outside the team.
• Knowledge of statistics and experience using statistical packages for analysing datasets (SPSS, SAS, R, etc) is preferred

Qualification & Experience

• B. Tech from reputed institute with 4-7 years of experience in data analytics (SQL & Advanced Excel), analyzing data trends and reporting

Key Success Factors for the Role

• Passion for data and an exceptional ability to solve complex problems.
• Strong communication skills, Influencing skills, great interpersonal & stakeholder management skills.
• High on energy, a go-getter and a team player