BI Data Analytics Consultant

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