Business Analyst - D2C

Swiss Beauty; Gurugram District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Swiss Beauty in Gurugram seeks a data-driven D2C Business Analyst to convert data into actionable insights, targeting revenue growth, profitability, and margin improvements. The role requires hands-on SQL and Power BI, plus a solid grasp of D2C metrics, working with cross-functional teams including Marketing, Product, Finance, and Operations.

You will own analyses across revenue, orders, customers, channels; build dashboards, identify margins, leakage, and growth opportunities; translate

Qualifications

• 2–5 years in Business Analytics, preferably D2C/e-commerce.
• Advanced SQL and Power BI proficiency is mandatory.
• Strong Excel/Google Sheets capabilities.
• Solid understanding of D2C/e-commerce metrics.
• Ability to work with large, complex datasets and derive actionable insights.
• Translate analyses into recommendations for business impact and work with stakeholders.

Responsibilities

• Own regular analysis of D2C performance across revenue, orders, customers, products, channels and profitability.
• Develop a deep understanding of the D2C funnel: Traffic→PDP→Add to Cart→Checkout→Purchase→Delivery→Repeat.
• Identify trends, opportunities, gaps and performance issues; perform period analyses against targets.
• Build automated dashboards to reduce manual reporting and improve decision speed.
• Analyze SKU, category, channel and campaign profitability; identify margin leakages.
• Evaluate promotional campaigns for incremental profitability and CM improvement.
• Create Power BI dashboards for leadership and cross-functional teams; ensure data accuracy.

Skills

Advanced SQL

Power BI

Excel/Sheets

D2C metrics

Data analysis

Stakeholder communication

Problem solving

Tools

BigQuery

GA4

Job description

Role Overview

We are looking for a highly analytical and business-oriented D2C Business Analyst who can convert data into actionable insights and directly contribute to revenue growth, profitability, and margin improvement.

Job Title: Business Analyst – D2C

Experience: 2–5 Years

Function: D2C / Business & Analytics

Role Overview

We are looking for a highly analytical and business-oriented D2C Business Analyst who can convert data into actionable insights and directly contribute to revenue growth, profitability, and margin improvement. The role requires strong hands‑on expertise in SQL and Power BI, along with a solid understanding of D2C/e-commerce business metrics. The candidate will work closely with D2C, Performance Marketing, Product, Finance, CRM, Operations, and Supply Chain teams to identify growth opportunities, cost leakages, and margin improvement areas. This is not purely a reporting role. The candidate will be expected to identify problems, recommend actions, and track the business impact of those actions.

Key Responsibilities1. Business & D2C Analytics

• Own regular analysis of D2C business performance across revenue, orders, customers, products, channels, and profitability.
• Build a strong understanding of the complete D2C funnel: Traffic → PDP → Add to Cart → Checkout → Purchase → Delivery → Repeat Purchase.
• Identify trends, anomalies, business opportunities, and performance gaps.
• Conduct daily, weekly, monthly, and YTD performance analysis against targets.
• Build automated dashboards and reduce dependency on manual reporting.
• Margin & Profitability Improvement

A key objective of this role will be to identify and execute opportunities for contribution margin improvement.

• Build SKU, category, customer, channel, and campaign-level profitability analysis.
• Identify margin leakages across:
• Discounts and promotions
• Performance marketing spend
• Shipping and logistics costs
• COD and payment gateway costs
• RTO and cancellations
• Returns and refunds
• Marketplace/affiliate commissions
• Cashback and loyalty costs
• Evaluate the incremental profitability of promotional campaigns and sale events.
• Recommend actions to improve Gross Margin, CM1, CM2 and overall D2C contribution margin.
• Identify high-revenue but low/profit-negative SKUs, campaigns, channels, and customer cohorts.
• Work with business teams to translate findings into measurable margin improvement initiatives.
• SQL & Data Analysis
• Write advanced SQL queries for large datasets across orders, customers, products, marketing, CRM, and operational data.
• Perform data extraction, transformation, validation, and reconciliation.
• Build reusable SQL datasets and reporting layers.
• Conduct cohort, funnel, retention, SKU, channel, and customer segmentation analysis.
• Work with multiple data sources to create a single view of D2C business performance.
• Strong hands‑on SQL proficiency is mandatory for this role.
• Power BI & Business Dashboards
• Build and maintain interactive Power BI dashboards for leadership and functional teams.
• Automate recurring MIS and business reports.
• Develop dashboards for:
• Revenue & GMV
• D2C P&L / Contribution Margin
• Marketing & ROAS
• Customer Acquisition
• Retention & Cohorts
• Product/SKU Performance
• Inventory
• COD/Prepaid Mix
• RTO & Returns
• Funnel & Conversion
• Build alerts and exception-based reporting so teams can quickly identify business issues.
• Ensure data accuracy and consistency across dashboards.
• Customer & Retention Analytics
• Analyze New vs Repeat customer behavior.
• Build customer cohorts and retention curves.
• Track Repeat Purchase Rate, Purchase Frequency, LTV, CAC and CAC:LTV.
• Identify high-value and low-value customer segments.
• Analyze CRM campaigns across WhatsApp, SMS, Email and Push Notifications.
• Recommend opportunities to increase retention and customer lifetime value.
• Marketing & Growth Analytics
• Analyze channel-level performance across Meta, Google, Affiliates and other acquisition channels.
• Evaluate CAC, ROAS, conversion rate and incremental revenue.
• Connect marketing performance with actual contribution margin, rather than evaluating channels only on ROAS.
• Identify opportunities to optimize marketing spend toward more profitable customer cohorts, products and channels.
• Business Planning & Forecasting
• Support monthly and annual D2C planning.
• Build revenue, order, AOV, traffic and margin projections.
• Support inventory and demand forecasting using historical trends and annual business plan
• Perform scenario analysis for pricing, discounts, marketing spends and promotional events.
• Track Actual vs Target vs Forecast and highlight risks early.
• Cross-Functional Business Partnership

D2C Team – Revenue, profitability and business planning

Performance Marketing – CAC, ROAS and channel profitability

Product – Funnel and conversion improvement

CRM – Retention and customer lifecycle

Finance – Margin and D2C P&L

Operations – RTO, logistics and fulfilment costs

Supply Chain – Inventory and demand planning

The analyst should proactively bring insights to teams rather than waiting for reporting requests.

Key Requirements

• 2–5 years of experience in Business Analytics, preferably within D2C, e-commerce, retail or consumer businesses.
• Advanced SQL knowledge – mandatory.
• Strong hands‑on Power BI experience – mandatory.
• Strong Excel/Google Sheets capabilities.
• Strong understanding of D2C and e-commerce business metrics.
• Ability to work with large and complex datasets.
• Strong analytical and problem-solving ability.
• Ability to translate analysis into clear business recommendations.
• Comfortable working directly with senior business stakeholders.

Good to Have

• Experience with Shopify or similar e-commerce platforms.
• Knowledge of GA4 and digital analytics.
• Understanding of Meta and Google Ads data.
• Exposure to BigQuery or similar data warehouses.
• Basic Python knowledge.
• Experience building automated business reporting systems.
• Understanding of D2C P&L and contribution margin structures.

Key Success Metrics

Performance In This Role Will Primarily Be Evaluated On

• Contribution Margin Improvement
• Identification and reduction of margin leakages
• Revenue and profitability insights generated
• Reduction in RTO/returns and associated costs through analytics
• Improvement in marketing efficiency
• Improvement in customer retention/LTV
• Accuracy and adoption of Power BI dashboards
• Reduction in manual reporting
• Speed and quality of actionable business insights
• Accuracy of business forecasts

Skills: business analysis,power bi,sql