Analyst - II

About the job 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: Strong 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.