BI Data Analytics Consultant

Weekday; India; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Weekday, in collaboration with its client in India, seeks an experienced BI Data Analytics Consultant to transform complex data into actionable insights. You will develop interactive dashboards, model data, and craft DAX measures to support strategic decisions.

The role requires strong analytics, end-to-end project management, and the ability to translate business needs into scalable BI solutions, leveraging Power Apps and Circana where applicable.

Qualifications

• Hands-on Power BI dashboard development and reporting.
• Strong SQL, Databricks for data extraction and analysis.
• Proficient in Python for data analysis and automation.
• Experience with FMCG/retail data and commercial KPIs.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports to support business reporting and decision-making.
• Build and optimise data models, write complex DAX measures, and implement effective data visualisation techniques.
• Use SQL, Python, and Databricks to extract, transform, analyse, and interpret large datasets.
• Conduct detailed business and commercial analysis to identify trends, patterns, opportunities, and performance gaps.
• Analyse key business metrics and commercial KPIs, particularly within FMCG and retail environments.
• Translate business requirements into technical specifications and scalable BI solutions.
• Collaborate with business stakeholders to understand reporting needs, gather requirements, and deliver relevant analytical solutions.
• Independently manage analytics projects from requirement gathering and data analysis through development, deployment, and delivery.
• Present findings and actionable recommendations to stakeholders to support data‑driven business decisions.
• Leverage Power Apps and SharePoint, where applicable, to support business processes and reporting workflows.
• Work with syndicated data platforms such as Circana to generate market, category, and commercial insights.

Skills

Power BI

SQL

Databricks

Python

Business Analysis

FMCG Analytics

Stakeholder Mgmt

Tools

Power Apps

SharePoint

Job description

This role is for one of Weekday’s clients

Min Experience: 7+ years
Location: India
JobType: full-time

We are seeking an experienced BI Data Analytics Consultant with strong expertise in Power BI, SQL, Python, Power Apps, and business analysis. The ideal candidate will combine technical proficiency with business acumen to transform complex data into meaningful insights that support strategic decision-making.

The candidate should have hands‑on experience developing interactive dashboards, building data models, writing DAX measures, creating effective data visualisations, and delivering actionable business insights. Experience in the FMCG and retail sectors, particularly in analysing commercial KPIs and working with syndicated data platforms such as Circana, will be highly preferred.

The role requires strong stakeholder management skills and the ability to independently manage end‑to‑end analytics projects, gather business requirements, conduct in‑depth analysis, and translate findings into practical business recommendations.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports to support business reporting and decision-making.
• Build and optimise data models, write complex DAX measures, and implement effective data visualisation techniques.
• Use SQL, Python, and Databricks to extract, transform, analyse, and interpret large datasets.
• Conduct detailed business and commercial analysis to identify trends, patterns, opportunities, and performance gaps.
• Analyse key business metrics and commercial KPIs, particularly within FMCG and retail environments.
• Translate business requirements into technical specifications and scalable BI solutions.
• Collaborate with business stakeholders to understand reporting needs, gather requirements, and deliver relevant analytical solutions.
• Independently manage analytics projects from requirement gathering and data analysis through development, deployment, and delivery.
• Present findings and actionable recommendations to stakeholders to support data‑driven business decisions.
• Leverage Power Apps and SharePoint, where applicable, to support business processes and reporting workflows.
• Work with syndicated data platforms such as Circana to generate market, category, and commercial insights.

Required Skills and Qualifications

• Strong hands‑on experience in Power BI dashboard development and reporting.
• Proficiency in SQL and Databricks for data extraction, transformation, and analysis.
• Experience with data modelling, DAX, interactive dashboards, and data visualisation.
• Working knowledge of Python for data analysis and automation.
• Strong business analysis capabilities and the ability to convert data into actionable insights.
• Experience working with FMCG or retail data and commercial performance metrics.
• Excellent stakeholder management, communication, and problem‑solving skills.
• Ability to independently manage projects and work with cross‑functional teams.

Must-Have Skills

• Power BI Dashboard Development
• SQL
• Databricks
• FMCG

Good-to-Have Skills

• Business Intelligence and Analytics
• Power Apps
• SharePoint
• Stakeholder Management
• Requirements Gathering
• Python
• Commercial KPI Analysis
• Circana or Other Syndicated Data Platforms