Sr. Functional Consultant

Weekday AI; Delhi; On-site; INR 5,000,000 - 6,000,000; Full time

Job summary

Weekday is seeking a Senior Functional Consultant to lead cross-functional teams and deliver analytics-driven transformations for FMCG and retail clients.

You will architect advanced analytics platforms using Power BI, SQL, and Python to uncover insights, optimize supply chains, and enhance customer experiences. This role demands deep retail and KPI knowledge and a proven ability to translate complex requirements into scalable tech solutions.

Qualifications

• 6+ years of experience as a functional consultant in FMCG or retail.
• Proven Power BI solutions delivering commercial impact.
• Strong SQL for data extraction, transformation, and tuning.

Responsibilities

• Conduct detailed business requirement analysis for FMCG and retail clients to define KPIs and performance metrics.
• Design, develop, and deploy interactive Power BI dashboards that visualize commercial KPIs and operational data.
• Write complex SQL queries to extract, transform, and load data from multiple enterprise data sources.
• Develop Python scripts for data cleansing, advanced analytics, and automated reporting workflows.
• Collaborate with stakeholders to conduct data quality assessments and maintain data governance standards.
• Lead solution workshops and training sessions to empower end-users with analytical capabilities.
• Provide technical mentorship to junior consultants and analysts on best practices in data modeling.
• Align functional solutions with industry regulations and compliance requirements.
• Monitor project progress, manage risks, and ensure timely delivery within scope and budget.
• Document solution architectures, process flows, and user guides for future reference.

Skills

Power BI

SQL

Python

Data modeling

Data governance

Analytics

Stakeholder comms

Cross-functional leadership

Tools

Azure

AWS

ETL pipelines

Job description

This role is for one of the Weekly's clients

Salary range: Rs 5000000 - Rs 6000000 (ie INR 5-60 LPA)

Experience: 6+ yrs

Location: India

As a Senior Functional Consultant, you will lead cross-functional teams in delivering transformative solutions across the FMCG and retail sectors, driving commercial excellence and data-driven decision making. You will architect and implement advanced analytics platforms, leveraging Power BI, SQL, and Python to uncover insights that propel business performance, optimize supply chains, and enhance customer experience. Your deep understanding of retail operations and commercial KPIs will enable you to translate complex business requirements into scalable technology solutions. You will be the catalyst for continuous improvement, ensuring that every project aligns with strategic objectives and delivers measurable impact.

Key Responsibilities

• Conduct detailed business requirement analysis for FMCG and retail clients to define KPIs and performance metrics.
• Design, develop, and deploy interactive Power BI dashboards that visualize commercial KPIs and operational data.
• Write complex SQL queries to extract, transform, and load (ETL) data from multiple enterprise data sources.
• Develop Python scripts for data cleansing, advanced analytics, and automated reporting workflows.
• Collaborate with stakeholders to conduct data quality assessments and maintain data governance standards.
• Lead solution workshops and training sessions to empower end-users with analytical capabilities.
• Provide technical mentorship to junior consultants and analysts on best practices in data modeling.
• Align functional solutions with industry regulations and compliance requirements.
• Monitor project progress, manage risks, and ensure timely delivery within scope and budget.
• Document solution architectures, process flows, and user guides for future reference.

What makes you a great fit

• 6+ years of experience as a functional consultant in FMCG or retail environments.
• Proven track record of delivering high-impact Power BI solutions that drive commercial results.
• Strong proficiency in SQL for data extraction, manipulation, and performance tuning.
• Hands‑on experience with Python for data analysis, automation, and machine learning projects.
• Deep knowledge of retail operations, supply chain dynamics, and key commercial KPIs.
• Excellent communication skills, able to translate technical concepts to non‑technical stakeholders.
• Ability to manage multiple projects simultaneously while maintaining strict quality standards.
• Analytical mindset with a knack for turning complex data into actionable insights.
• Familiarity with cloud platforms (Azure, AWS) and modern data architecture patterns.
• Commitment to continuous learning and staying updated on emerging analytics technologies.