Data Analyst Analytics Consultant

Weekday AI (YC W21); India; On-site; INR 5,000,000 - 18,000,000; Full time

Job summary

Weekday AI (YC W21) in India is seeking an experienced Data Analyst / Analytics Consultant to transform complex data into actionable insights. You will build interactive Power BI dashboards and deliver pricing and distribution analytics to support pricing, sales, and category decisions.

The role requires 4+ years of analytics experience, strong data visualization skills, and the ability to translate business questions into measurable KPIs. Location: India. Job Type: Full-time.

Qualifications

• 4+ years in data analytics, business intelligence, analytics consulting or related field.
• Strong Power BI expertise and dashboard development.
• CPG/FMCG analytics, commercial analytics, or sales analytics experience preferred.
• Strong understanding of pricing analytics and price realization.
• Experience with distribution analytics and multi-source data integration.

Responsibilities

• Analyse business data to generate actionable insights across CPG/FMCG operations.
• Design, develop, and maintain interactive Power BI dashboards and reports.
• Translate requirements into KPIs, data models, and visualizations.
• Conduct pricing analytics to evaluate price performance and discounts.
• Perform distribution analytics for channel performance and reach.
• Analyze sales, revenue, volume, and product performance.
• Present findings to senior stakeholders and support decision-making.
• Collaborate with cross-functional teams and ensure data accuracy.

Skills

Data analytics

SQL

Stakeholder communication

Problem solving

Data visualization

Education

Bachelor's or Master's degree in Data Analytics/Statistics/Mathematics/CS/Engineering

Tools

Power BI

DAX

Power Query

Excel

Job description

Job Description:

This role is for one of the Weekdays clients

Salary range: Rs 5000000 - Rs 18000000 (ie INR 5-18 LPA)

Experience: 4+ yrs

Location: India

Job Type: Full-time

We are looking for an experiencedData Analyst / Analytics Consultantwith strong expertise inPower BI, CPG/FMCG analytics, pricing analytics, and distribution analytics. The role focuses on transforming complex commercial and operational data into actionable insights that support pricing, sales, distribution, category, and business decisions.

The ideal candidate will combine strong analytical capabilities with business understanding and hands-on data visualization skills. You will work with large datasets, develop interactive Power BI dashboards, identify commercial trends, and translate analytical findings into clear recommendations for business stakeholders.

Key Responsibilities

• Analyse business and commercial data to generate actionable insights acrossCPG/FMCG operations.


• Design, develop, and maintain interactivePower BI dashboards, reports, and analytical solutions.


• Translate business requirements into meaningful KPIs, metrics, data models, and visualization requirements.


• Conductpricing analyticsto evaluate price performance, pricing trends, price realization, discounting, and commercial opportunities.


• Performdistribution analyticsto assess distribution reach, availability, outlet/channel performance, geographic coverage, and distribution effectiveness.


• Analyse sales, revenue, volume, product, customer, channel, and category performance.


• Identify trends, anomalies, performance gaps, and key business drivers through structured data analysis.


• Develop dashboards for sales performance, pricing, distribution, product performance, and other commercial KPIs.


• Work with stakeholders to define analytical questions, reporting requirements, business rules, and success metrics.


• Perform data preparation, cleansing, transformation, validation, and reconciliation to ensure analytical accuracy.


• Build appropriate data models and relationships to support scalable Power BI reporting.


• Develop calculated measures, KPIs, filters, drill-downs, and interactive visualizations in Power BI.


• Monitor dashboard performance and optimize data models, queries, and reports where required.


• Combine data from multiple sources to develop comprehensive commercial and operational insights.


• Present analytical findings and recommendations clearly to business and senior stakeholders.


• Support business teams in interpreting dashboards and using data for decision-making.


• Conduct ad-hoc analysis to support pricing, distribution, sales, category, marketing, and strategic initiatives.


• Maintain documentation for data definitions, reporting logic, KPIs, dashboards, and analytical methodologies.


• Collaborate with data, technology, sales, marketing, finance, and other cross-functional teams.


• Continuously identify opportunities to improve reporting automation, analytical processes, and business intelligence capabilities.

What Makes You a Great Fit

• 4+ years of experiencein data analytics, business intelligence, analytics consulting, commercial analytics, or a related field.


• Strong hands-on expertise inPower BIand enterprise dashboard development.


• Proven experience inCPG/FMCG analytics, commercial analytics, sales analytics, or consumer business analytics.


• Strong understanding ofpricing analytics, including price realization, pricing performance, discounts, and pricing trends.


• Hands-on experience withdistribution analytics, including distribution coverage, channel performance, availability, and geographic analysis.


• Strong SQL skills for data extraction, transformation, validation, and analysis.


• Experience working with large and complex datasets from multiple business sources.


• Strong understanding of data modelling, data preparation, KPI development, and business reporting.


• Experience developing Power BI dashboards usingDAX, calculated measures, Power Query, data relationships, filters, and drill-downs.


• Strong analytical and problem-solving skills with the ability to identify business trends and translate them into actionable insights.


• Ability to understand commercial objectives and connect analytical findings with business outcomes.


• Strong stakeholder-management and communication skills, with the ability to present complex analysis to non-technical audiences.


• High attention to detail and strong focus on data accuracy, consistency, and reporting quality.


• Ability to manage multiple analytical projects and competing priorities independently.


• Experience with sales, revenue, category, customer, channel, or supply-chain analytics is an advantage.


• Familiarity with Excel and other data-analysis tools is desirable.


• Experience with FMCG/CPG sales and distribution datasets, trade promotion analytics, revenue growth management, or category analytics is an advantage.


• Bachelors or Masters degree inData Analytics, Statistics, Mathematics, Economics, Computer Science, Engineering, Business, or a related disciplineis preferred.

Requirements: