Reliance eCommerce - Deputy Manager - Analytics

Role Name: Deputy Manager - Analytics

Reporting Manager Head - Category Product and Analytics

Role Purpose: This position is responsible for managing Business Intelligence & Analytics dashboards, frameworks and projects [strategically and operationaly] for AJIO.com. The role involves working closely with Executive and Functional leaders and teams to build and maintain KPI metrics dashboards, functional/ operational scorecards, decision-making frameworks and analytics projects, and monitor and share periodic insights

BSC perspective Key Responsibilities

Business Reviews : 

- Present insightful weekly and monthly business review presentations that concisely summarizes data on overall business and financial performance, and help facilitate decision-making for senior management

- Identify metrics/KPI for each function - Marketing, Planning, Customer care, warehouse, Catalog and present in weekly and monthly reviews

Reports, Dashboards & Decision Making Framework

- Work with functional and sub-functional owners to identify information needs and develop concise reports; primary stakeholders include the product team, business operations and supply chain, as well as Customer service and Finance teams.

- Prepare Business Requirement Documents (BRDs) of BI & Analytics requirements

- Deliver BI Dashboards & Reports (Tableau and Google Analytics based) across all functions to support the decision making process

- Own and maintain the calendar and schedule for all reporting requirements across functions

- Project management of existing reporting and dashboard requirements and identify improvements/enhancements to existing reports

Business Analytics : 

- Identify and own analytics projects such as customer RFM model to help improve key benchmark metrics

- Strong analytical skills and data driven approach to decision making

- Maturity to handle ambiguous business scenarios and arrive at logical business solutions with limited data / uncertainties

- Comfortable in tracking key business KPIs through automated reports and ad-hoc data analyses

- Proficiency in VBA, MS- Excel (Basic & Advance) and SQL is a must

- Working knowledge of MS Access, Tableau and R is a plus

- Excellent communication and project management skills

RCAs, Alerts - 

- Produce timely, accurate and effective root cause analyses and reporting of KPI trends and help identify clear set of action items for the metric owner

- Capture and prioritize hypotheses for further analysis by Business Analytics and Product teams which might help us further build on a positive momentum or arrest the stagnant or negative trend in important metrics

- Set up automated business alerts based on a rule set - to proactively highlight variations in business metrics

Competencies - 

Functional Competencies - Familiarity with KPIs and industry benchmarks used to evaluate internet businesses; preferably in the Ecommerce space

- Ability to handle data - Data mining and reporting from SQL/NoSQL databases & advanced Excel skills

- Exposure to Web analytics and has hands on experience with tools like Google Analytics

- Excellent presentation and data visualization skills. Experience working with visualization tools like Tableau

- Basic understanding of Statistics & Hypothesis testing

- Must have excellent organizational skills and demonstrate great attention to detail

- Strong stakeholder management and communication skills

- Ms-Excel (2013) and VBA

- Experience in rapid application development using VBA for excel/MS-Access

- Develop custom VBA macros to automate existing processes

- Support and Enhance existing MS Excel for day to day analysis (Proficient in creating excel data models, data tables, pivoting, conditional formatting, charts, lookups etc.)

- Experience in developing application using VBA for Excel

 SQL:

- Database development skills

- Experience in writing basic SQL queries

- Develop reports in SQL Server Reporting Services

 Tableau :

- Should be able to modify and create tableau reports

- Perform analysis through Tableau visualizations basis business requirements

 R :

- Should be able to automate business reports using a combination of R and/or Excel

- Perform ad-hoc exploratory data analyses

Academics and Experience

Qualification :B.E. + MBA from reputed institute

Work Experience: Minimum 3 years of BI, Reporting & Analytics experience supporting an online or digital business; preferably from ecommerce or consulting background