Power BI Business Analyst

Weekday AI; India; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Weekday is seeking a Power BI Business Analyst in India to transform complex datasets into actionable insights. You will design interactive dashboards, build data models, and work with SQL and DAX to support commercial decision-making. Knowledge of Python and Power Apps is a plus.

Experience in FMCG or retail KPIs and syndicated data is beneficial; you will collaborate with stakeholders across functions to define KPIs, monitor performance, and drive data-driven improvements.

Qualifications

• Strong hands-on experience in Power BI dashboard development.
• Expertise in DAX, data modelling, and performance optimisation.
• SQL for data extraction, transformation, and analysis.
• Knowledge of Python for data analysis and automation.
• Power Apps for business processes.

Responsibilities

• Develop and maintain interactive Power BI dashboards and reports.
• Create data models and optimize DAX measures.
• Use SQL to extract and analyze data and support commercial planning.
• Collaborate with stakeholders to define KPIs and reporting needs.
• Leverage Power Apps to streamline workflows.

Skills

Power BI

DAX

Data modelling

SQL

Python

Power Apps

Stakeholder management

Communication

Analytical skills

Job description

This role is for one of Weekday's clients

Min Experience: 4+ years
Location: India
JobType: full-time

We are looking for a skilled Power BI Business Analyst with strong expertise in business intelligence, dashboard development, data modelling, and data-driven decision‑making. The ideal candidate will be proficient in Power BI, DAX, and SQL, with working knowledge of Python and Power Apps.

The role involves transforming complex datasets into meaningful business insights, developing interactive dashboards, analysing commercial performance, and collaborating with stakeholders to support strategic and operational decisions. Experience in the FMCG or retail industry, particularly with commercial KPIs and syndicated data, will be an added advantage.

Key Responsibilities

1. Dashboard Development and Business Intelligence

• Design, develop, and maintain interactive Power BI dashboards and reports to monitor business performance.
• Translate business requirements into effective reporting solutions and actionable insights.
• Create visualisations that enable stakeholders to track key performance indicators and identify business trends.
• Ensure dashboards are accurate, reliable, user-friendly, and aligned with business objectives.

2. Data Modelling and DAX

• Develop and maintain efficient data models to support reporting and analytical requirements.
• Write and optimise DAX measures, calculated columns, and expressions for complex business calculations.
• Implement appropriate data relationships, hierarchies, and aggregation logic.
• Improve dashboard performance and ensure consistency across reporting outputs.

3. Data Analysis and Reporting

• Use SQL to extract, transform, validate, and analyse data from relational databases.
• Analyse business datasets to identify trends, performance gaps, and opportunities for improvement.
• Apply analytical techniques to support commercial planning, performance monitoring, and decision‑making.
• Work with Python where required to support data analysis, automation, and data preparation.

4. Stakeholder Management and Business Collaboration

• Engage with business stakeholders to understand reporting needs, define KPIs, and gather analytical requirements.
• Collaborate with cross‑functional teams to deliver reports and dashboards that address business priorities.
• Present findings clearly and translate analytical results into practical business recommendations.
• Manage stakeholder expectations and ensure timely delivery of reporting solutions.

5. Business Applications and Process Improvement

• Leverage Power Apps to support business workflows and improve operational efficiency.
• Identify opportunities to automate reporting processes and streamline data‑driven operations.
• Maintain documentation for dashboards, data models, calculations, and reporting processes.
• Ensure data quality, accuracy, and consistency across business intelligence solutions.

Required Skills and Qualifications

• Strong hands‑on experience in Power BI dashboard and report development.
• Expertise in DAX, data modelling, and Power BI performance optimisation.
• Working knowledge of SQL for data extraction, transformation, and analysis.
• Familiarity with Python for data analysis and automation.
• Working knowledge of Power Apps and its application in business processes.
• Strong analytical, problem‑solving, and critical‑thinking skills.
• Excellent stakeholder management and communication abilities.
• Ability to translate business requirements into meaningful dashboards, KPIs, and actionable insights.

Must-Have Skills

• Power BI
• DAX and Data Modelling
• SQL

Good-to-Have Skills

• FMCG Industry Experience
• Retail Industry Experience
• Power Apps

Preferred Experience

• Experience working in the FMCG or retail industry.
• Familiarity with commercial KPIs and business performance metrics.
• Knowledge of syndicated data and its use in commercial analytics.
• Experience developing reporting solutions that support sales, category, retail, or commercial decision‑making.