MakeMyTrip - Business Analyst

Role Overview:

The incumbent will be be responsible for daily reporting, automating reports and processes, provide data driven insights & analysis and drive strategic projects

Responsibilities:

- Be on top of and publish critical business and product metrics on daily basis and help optimise conversions and drive efficiencies

- Take complete ownership of reporting areas and work on simplifying, optimising, automating and evolving those areas

- Proactively analyse data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance, investigating and communicating areas for improvement in efficiency and productivity

- Create and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources

- Identify, analyse, 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 cross functional stakeholders to prioritize business and information needs

- Drive strategic projects, as and when required

- Support Online Product, Revenue and Category teams on day to day basis Competencies

Required:

- Advanced Excel knowledge, shortcuts, lookups, pivot table, macros, etc

- Knowledge of SQL queries is desired

- Knowledge of statistics and experience using statistical packages for analysing datasets (Excel, SPSS, SAS, R, Python, etc) is a plus

- 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

- Technical expertise regarding data models, database design development, data mining and segmentation techniques

- Adept at queries, report writing and presenting findings

- Bonus points for past experience with any analytics product (Google Analytics / Omniture / Redash etc.)

- Attention to detail and ability to find needle in the haystack.

- Strong bias for action. Execution oriented.

- Proven track record of taking ownership of things and delivering results.