Data Analyst

WebBee; Sector 10; On-site; INR 600,000 - 900,000; Full time

Job summary

WebBee is seeking an experienced Data Analyst to collect, clean and analyse data from multiple sources and translate findings into actionable insights. You will develop and maintain Power BI dashboards, perform SQL queries, and support cross-functional teams with data-driven decisions.

The role focuses on e-commerce data, KPI tracking and reporting, with emphasis on data quality, transformation, and effective visualisation for stakeholders.

Qualifications

• 3–5 years of relevant experience as a Data Analyst or similar role.
• Strong hands-on experience in SQL and Power BI (Mandatory).
• Advanced knowledge of Excel including Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH.
• Good data cleaning, transformation and data modelling skills.
• Experience developing dashboards, reports and data visualisations.

Responsibilities

• Collect, clean, validate, and analyse data from multiple sources.
• Develop, maintain and manage Power BI dashboards and reports.
• Write and execute SQL queries to extract and analyse data.
• Collaborate with departments to deliver actionable insights.
• Analyse e-commerce data (GMV, revenue, AOV, ROAS) and trends.
• Monitor data quality and resolve data discrepancies.

Skills

SQL

Power BI

Advanced Excel

Data analysis

Data modelling

Dashboards

Reporting

Education

Bachelors in CS/IT/Statistics/Math/Analytics

Tools

Power BI

SQL Server

Job description

Role & responsibilities

Data Collection & Analysis

• Collect, clean, validate, and analyse data from multiple sources.
• Work with structured and unstructured datasets to identify trends and patterns.
• Perform data validation and ensure accuracy, consistency, and reliability.
• Identify key business trends, opportunities, and areas for improvement.
• Convert raw data into meaningful insights to support business decisions.

Dashboard Development & Reporting

• Develop, maintain, and manage interactive dashboards using Power BI.
• Create regular, ad-hoc, and customised reports for management and business teams.
• Track and analyse key performance indicators (KPIs) and business metrics.
• Prepare data visualisations and performance reports for stakeholders.
• Automate recurring reports and improve reporting efficiency.

Database Management & SQL

• Write and execute SQL queries to extract, manipulate, and analyse data.
• Work with databases to retrieve and organise relevant business information.
• Perform data joins, aggregations, filtering, and transformations.
• Identify data discrepancies and coordinate with relevant teams for resolution.
• Optimise queries and improve data retrieval processes wherever required.

Business Insights & Coordination

• Collaborate with different departments to understand business requirements and reporting needs.
• Provide actionable insights based on data analysis.
• Support management in strategic and operational decision-making.
• Analyse business performance and highlight areas requiring attention.
• Work on ad-hoc analytical assignments and special projects.

E-commerce

• Analyse e-commerce sales data across platforms such as Shopify, WooCommerce, and other marketplaces to identify business trends and growth opportunities.
• Track key business metrics, including GMV, revenue, order volume, Average Order Value (AOV), conversion rates, and customer retention.
• Develop Power BI dashboards to monitor sales performance, product-wise performance, inventory, and operational KPIs.
• Analyse customer purchasing behaviour, repeat orders, cart abandonment, returns, refunds, and order fulfilment trends.
• Monitor marketing campaign performance, website traffic, channel-wise revenue, and Return on Ad Spend (ROAS).

Preferred candidate profile

• Bachelors degree in computer science, Information Technology, Statistics, Mathematics, Business Analytics, or a related field.
• 3-5 years of relevant experience as a Data Analyst or in a similar analytical role.
• Strong hands-on experience in SQL and Power BI (Mandatory).
• Advanced knowledge of Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, and advanced formulas and functions.
• Good understanding of data cleaning, data transformation, and data modelling.
• Experience in developing dashboards, reports, and data visualisations.
• Strong analytical, logical reasoning, and problem-solving abilities.
• Ability to interpret data and present meaningful business insights.
• Good verbal and written communication skills.