Senior Functional Consultant

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.

Requirements

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.