The Role – Analyst II (Analytics)

Data in the current business environment is key to business success. As an Analyst-II in the Beauty Business Analytics team, you will independently own recurring business reporting, dashboards, category performance monitoring, structured diagnostic analyses, pipeline building and ML/AI modeling. You will work with category, business, product and analytics stakeholders to convert business questions into reliable insights to support decision-making.

Key Responsibilities

1. Execution & Insights Generation

- Structure and execute analytical frameworks to solve well-defined business and product problems independently.
- Mine large-scale behavioral and transactional datasets to uncover root causes of business metrics trends, funnel drop-offs, and user retention behaviors.
- Translate analytical findings into crisp, digestible business insights and concrete actionable recommendations for stakeholders.

2. Reporting & Dashboarding

- Own daily/monthly MIS, category trackers, hourly sales reports, and recurring performance scorecards
- Build, maintain, QA, and improve Tableau dashboards and automated reporting layers
- Support Pink Sale and other campaign/event trackers, traffic dashboards, and post-sale summaries
- Maintain scheduled reports, validate Databricks/table pipelines, document logic, and reduce manual effort

3. Applied Modeling & Advanced Analytics

- Build, validate, and deploy practical predictive models (e.g., user churn prediction, customer segmentation, demand forecasting) to support targeted business strategies.
- Democratize analytical assets and self-serve metrics to enable faster,



data-driven decision-making across business units.

Capabilities & Competencies

- Problem Solving & Analytical Thinking: Solid ability to structure structured or semi-ambiguous problem statements, perform hands-on quantitative analysis, and derive clear, logical conclusions.
- Technical & Tools Proficiency:
- Advanced SQL capabilities for complex data extraction, joining, and aggregation.
- Deep proficiency in Python or R for statistical analysis and data manipulation (Pandas, NumPy, Scikit-learn, etc.).
- Practical experience with visualization tools such as Databricks, Tableau, PowerBI
- Exposure to Clickstream/Web Analytics tools (e.g., Mixpanel, Google Analytics, Amplitude)
- Statistical Modeling & Experimentation: Statistical significance and Hypothesis testing, Hands-on experience applying core machine learning algorithms (Regression, Classification, Clustering, Time-Series) and designing A/B testing frameworks.
- Communication & Stakeholder Management: Strong verbal and written communication skills with the ability to "connect the dots" through data and present clear narratives to cross-functional peers.
- Ownership & Attitude: High degree of self-motivation, intellectual curiosity ("the drive to dig into the who, why, and how"), and an energetic "can-do" attitude towards problem-solving.

Qualifications & Experience

- Education: Bachelor’s or Master's degree in a quantitative field such as Computer Science, Statistics, Mathematics, Economics, Analytics, or Engineering.
- Experience: 3–5 years of hands-on experience in Data/Business/Product Analytics.
- Prior experience in E-commerce, D2C, Consumer Tech, or Retail platforms is highly preferred.

📌 Analyst - II (Bengaluru)
🏢 Nykaa
📍 Bengaluru