Senior Functional Consultant

Accountabilities:

Design, develop, and maintain advanced Power BI dashboards and reports to support business performance monitoring, operational efficiency, and strategic decision-making.
Build and optimise data models, implement complex DAX calculations, and create clear, effective, and insightful data visualisations.
Use SQL and Python to extract, transform, analyse, and process large datasets, ensuring accurate and reliable reporting.
Leverage Power Apps to support business processes, improve analytical workflows, and address functional requirements.
Conduct in-depth business and data analysis to identify trends, performance gaps, growth opportunities, and areas for improvement.
Analyse commercial KPIs and business performance metrics to provide actionable insights and support strategic and operational decisions.
Work with syndicated data and various business datasets to generate meaningful insights and support informed decision-making.
Collaborate with business and technical stakeholders to understand requirements, define analytical needs, and translate them into effective solutions.
Independently manage projects and analytical workstreams from requirement gathering and planning through execution, delivery, and follow-up.
Present analytical findings, business insights, and recommendations clearly to both technical and non-technical stakeholders.
Proactively identify challenges, recommend practical solutions, and ensure projects and deliverables are completed within agreed timelines.
Maintain a strong focus on analytical quality, business relevance, and continuous improvement across reporting and consulting activities.
Requirements:
Professional Experience and Qualifications
6–10 years of relevant professional experience in functional consulting, business analysis, data analytics, or business intelligence.
Advanced proficiency in Power BI, including dashboard development, data modelling, DAX calculations, and data visualisation.
Intermediate-level proficiency in SQL and Python for data extraction, transformation, analysis, and reporting.
Intermediate-level knowledge of Power Apps and its application to business processes and analytical solutions.
Strong understanding of business analysis methodologies and the ability to translate business requirements into technical and analytical deliverables.
Business and Analytical Skills
Strong analytical and problem-solving capabilities, with the ability to interpret complex datasets and identify meaningful business insights.
Good understanding of commercial KPIs, business performance metrics, and data-driven decision-making.
Ability to conduct detailed quantitative analysis and translate findings into clear, actionable business recommendations.
Experience working with business datasets and reporting environments, ensuring data accuracy and consistency.
Stakeholder Management and Project Ownership
Excellent communication and stakeholder management skills, with the ability to collaborate effectively across business and technical teams.
Proven ability to independently manage projects and analytical workstreams from initial requirements through final delivery.
Strong organisational and prioritisation skills, with the ability to manage multiple responsibilities and meet project deadlines.
A proactive and solution-oriented mindset, demonstrating accountability, initiative, and ownership of deliverables.
Ability to explain technical concepts and analytical findings in a clear and accessible manner to different audiences.
Preferred Qualifications and Additional Experience
Previous experience in the Fast-Moving Consumer Goods (FMCG) or Retail industry.
Strong knowledge of commercial performance indicators, sales metrics, and business analytics.
Experience working with syndicated market data, preferably Circana.
Experience analysing retail or FMCG datasets to identify market trends, business opportunities, and performance improvements.
Demonstrated ability to connect data analysis with business strategy and practical recommendations.
Must-Have Technical Skills: Power BI, SQL, and Python.
Good-to-Have Skills: FMCG or Retail industry experience, commercial KPI analysis, and syndicated data expertise, particularly Circana.
Work Requirements
Flexible hybrid or remote working arrangement, to be finalised.
Availability during core working hours of 10:00 AM to 7:00 PM IST.
Ability to manage assigned projects and workstreams independently while maintaining effective collaboration with cross-functional stakeholders.
Benefits:
Competitive salary: Annual compensation ranging from INR 5 LPA to INR 50 LPA, depending on experience, skills, and suitability for the position.
Flexible working arrangements: Hybrid or fully remote working options, with the final arrangement to be determined.
Work-life flexibility: A structured core working schedule from 10:00 AM to 7:00 PM IST.
Professional development: Opportunities to strengthen expertise in business intelligence, data analytics, functional consulting, and advanced reporting technologies.
Business impact: The opportunity to independently lead analytical projects and contribute directly to strategic and operational decision-making.
Cross-functional collaboration: Exposure to diverse business stakeholders and opportunities to work on meaningful business challenges.
Technical growth: Opportunities to deepen knowledge of Power BI, SQL, Python, Power Apps, commercial analytics, and syndicated data.