Data Analyst

Company overview:

PEP is a dynamic personal care company that proudly houses two innovative brands – mCaffeine & Hyphen. With a passion for creating high-performance, conscious, and consumer-loved products, we are redefining the way personal care is experienced. While mCaffeine is India’s first caffeinated personal care brand, loved for its energizing and playful approach, Hyphen is built on the philosophy of simplifying skincare through science-backed formulations. Together, our brands reflect PEP’s mission to deliver quality, creativity, and care to millions of consumers. We believe in Confidence over all skin & body biases.

Come, join the pack!

Job Summary:

Data Analysts will collaborate with various departments and stakeholders to gather, document,

and analyze business requirements, processes, and workflows. The ideal candidate will analyze

complex datasets, develop dashboards and reports, and translate business needs into

actionable insights to support strategic decision-making.

Key Responsibilities:

Work closely with business stakeholders to understand requirements and define KPIs
Analyze business data to identify trends, patterns, and opportunities for improvement
Write complex MySQL queries for data extraction, transformation, and analysis
Develop and maintain Power BI dashboards and reports for business users
Perform data analysis and automation using Python (Pandas, NumPy, etc.)
Translate business problems into analytical solutions and data models
Ensure data accuracy, consistency, and quality across reports
Document business requirements, data definitions, and analytical logic

Qualifications & Skills: