Data Analyst

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're 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're 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's 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