Senior Functional Consultant

Weekday AI; India; Hybrid; INR 500,000 - 5,000,000; Full time

Job summary

Weekday is seeking an experienced Senior Functional Consultant to drive data-driven insights for client engagements. You will lead analytics projects, develop advanced Power BI dashboards, and translate business questions into actionable recommendations for stakeholders.

You will work with SQL, Python, and Power Apps to pull data, build models, and monitor commercial KPIs, preferably in FMCG or Retail. Hybrid/remote work with IST hours; you will own end-to-end workstreams and present findings to

Qualifications

• 6-10 years of experience in functional consulting, business analysis, data analytics or BI.
• Advanced Power BI capabilities: dashboards, data modelling, DAX and visualisation.
• SQL and Python proficiency.
• Power Apps knowledge.
• Strong stakeholder management and communication.
• End-to-end project ownership.
• FMCG/Retail analytics experience and Circana knowledge preferred.

Responsibilities

• Develop and maintain advanced Power BI dashboards and reports.
• Build and optimise data models, write DAX, and create visualisations.
• Use SQL and Python for data extraction, transformation, analysis, and reporting.
• Leverage Power Apps to support business processes.
• Conduct detailed business analysis to identify trends and opportunities.
• Analyse commercial KPIs and guide strategic decisions.
• Work with syndicated data (Circana) to generate insights.
• Own projects end-to-end from requirements to delivery.
• Present findings clearly to business and technical stakeholders.

Skills

Power BI

SQL

Python

DAX

Business analysis

Stakeholder management

Communication skills

Tools

Power Apps

Circana

Job description

This role is for one of Weekday's clients
Salary range: Rs 500000 - Rs 5000000 (ie INR 5 - 50 LPA)

Min Experience: 6+ years
Location: Hybrid / Remote (To Be Determined)
JobType: full-time

We are looking for an experienced Senior Functional Consultant with strong expertise in business analysis, Power BI, SQL, and Python to drive data-driven business insights and support strategic decision-making.

The ideal candidate should have advanced Power BI capabilities, a solid understanding of commercial KPIs, and experience working with business analytics, preferably within the FMCG or Retail industry. Exposure to syndicated data, particularly Circana, will be an added advantage.

The candidate will be responsible for independently managing analytical projects and workstreams, conducting in-depth business analysis, and translating complex data into actionable recommendations for business stakeholders.

Key Responsibilities

• Develop and maintain advanced Power BI dashboards and reports to support business performance monitoring and decision-making.
• Build and optimise data models, write DAX calculations, and create effective data visualisations.
• Use SQL and Python for data extraction, transformation, analysis, and reporting.
• Leverage Power Apps to support business processes and analytical requirements.
• Conduct detailed business analysis to identify trends, performance gaps, opportunities, and actionable insights.
• Analyse commercial KPIs and business metrics to guide strategic and operational decisions.
• Work with syndicated data and business datasets to generate meaningful insights.
• Collaborate with stakeholders to understand business requirements and translate them into analytical solutions.
• Independently own projects and workstreams from requirement gathering through execution and delivery.
• Present analytical findings and recommendations clearly to business and technical stakeholders.
• Proactively identify problems, recommend solutions, and ensure timely delivery of project milestones.

Required Qualifications and Skills

• 6-10 years of relevant experience in functional consulting, business analysis, data analytics, or business intelligence.
• Advanced proficiency in Power BI, including dashboard development, data modelling, DAX, and data visualisation.
• Intermediate-level proficiency in SQL and Python.
• Intermediate-level knowledge of Power Apps.
• Strong business analysis and analytical problem-solving capabilities.
• Excellent stakeholder management and communication skills.
• Ability to independently manage projects and deliverables end-to-end.
• Proactive approach to problem-solving, ownership, and execution.

Preferred Qualifications

• Experience in the Fast-Moving Consumer Goods (FMCG) or Retail industry.
• Strong understanding of commercial KPIs and business analytics.
• Experience working with syndicated data, preferably Circana.
• Ability to conduct in-depth analysis and translate findings into actionable business recommendations.

Must-Have Skills

• Power BI
• SQL
• Python

Good-to-Have Skills

• FMCG
• Commercial KPIs
• Syndicated Data

Work Requirements

• Flexible hybrid or remote working arrangement, to be finalised.
• Core working hours: 10:00 AM to 7:00 PM IST.
• Ability to manage assigned projects and workstreams independently while collaborating with cross-functional stakeholders.