Data Analyst

Job Description

Company Description

SAKU Retails Pvt Ltd (SAKU - www.saku.co.in), started in 2024, is a vertically integrated Direct-to-consumer (D2C) house of brand, in fashion (Menswear and Womenswear) located in Gurugram. Our mission is to make high-quality, high fashion designer products accessible to masses.

We&aposre a customer and people first company from Day 1.

For us, our culture, love for our customers and care for our employees is non-negotiable.

We&aposre bootstrapped and strongly believe in unit economics and sustainable growth over burning investor money in the name of expansion.

Role Description

This is a full-time Data Analyst cum MIS role located on-site in Gurugram.

Broadly, your work will be split into following 3 buckets:

- 30% of your time on high impact data analysis, making dashboards and data driven decisions,
- 30% of your time on data cleaning / data entry; and
- 40% of your time on operational tasks

The Planning Analyst will be responsible for analysing data, developing plans, and monitoring key performance indicators.

Specific Roles and Responsibilities:

- Analyse Sales report at SKU level, store level and online (daily, weekly, monthly and quarterly)
- Analyse gross margins at SKU level
- Analyse and monitor stock velocity (fast moving, slow moving, and non-moving) and optimize the stock accordingly
- Analyse inventory ageing and plan discount schemes and in-store transfers accordingly
- Create and maintain various dashboards to enable management to take affective and timely business critical decisions
- Plan production re-runs / order based on sales velocity
- Analyse and update SKU wise inventory at various stores and central warehouse and plan replenishments and material movement accordingly
- Maintain CRM data (offline and online) and segment the data into various categories based on their purchase / website visit behaviour
- Prepare customer funnels for various marketing campaigns (email, Whatsapp and sms)
- Keep track of outcomes of various marketing campaigns and analyse ways to improve marketing campaign effectiveness
- Track Ad funnel KPIs and identify patterns and ways to improve various metrics across performance marketing channels (Meta, Google and others)
- Maintain costing sheets and assist in effectively taking pricing decisions
- Maintain production status sheets
- Analyse daily online sales from Shopify platform and other platforms (such as Myntra), oversee dispatch of all orders through warehouse dispatch team and update inventory across platforms
- Manage return and exchange data for accurate reconciliation of physical stock with inventory in systems
- Maintain and create ERP master data across all categories
- Maintain barcode master data
- Co-ordinate with multiple stakeholders (ERP support team, OMS, Platforms etc.)
- Support in ad-hoc data analysis

Qualifications and Technical Skills

- 0-2 years experience in data analysis
- Bachelor&aposs degree in Business, Finance, or a related field
- Strong Skills in MS Excel including advanced formula and dashboards (including Pivots)
- Proficiency in data analysis tools and software
- Strong Analytical Skills and Planning abilities
- Good problem solving and troubleshooting skills and ability to provide creative solutions to complex problems
- Experience with Key Performance Indicators (KPIs)

Other Skills

- Structured thought-process, organised, detail-oriented
- Strong Organisational skills
- Good Communication skills
- High Focus towards execution
- Ability to work collaboratively with cross-functional teams
- Creative problem solver
- Ability to work independently and as part of a team
- Curious about new trends
- First principles thinker
- Ability to simplify complex issues
- Experience in retail / D2C industry is a plus
- Experience of working on high velocity data and large number of SKUs is a plus
- Interest in fashion industry is a plus

What we offer

- Freedom to explore, fail fast and learn fast
- Creative freedom to express yourself
- Freedom to conceptualise and execute ideas
- A culture to challenge each other, to bring the best in all of us
- A trusting team environment
- Growth path to become the best in the business
- A team of empathetic problem solvers
- Continuous learning culture

---