Home/Job List/Data Analyst (Advanced Excel & Power BI)
EliteRecruitments

Data Analyst (Advanced Excel & Power BI)

EliteRecruitments

Gurugram, Haryana, India
Full-Time
Posted 2 days ago

Job Description & Responsibilities

Job Description – Data Analyst (Advanced Excel & Power BI)

Experience: 3+ Years

Grade: B1/B2

Location: Gurgaon / Pune / Bangalore

Notice Period: 15–30 Days

Role Overview

We are looking for a skilled Data Analyst with strong expertise in Advanced Excel and Power BI to support reporting and planning activities. The client currently uses Excel-based reporting models and is planning to migrate these reporting processes to Power BI.

The ideal candidate should have hands-on experience in complex Excel formulas, dynamic referencing, data transformation and Power BI reporting.

Key Responsibilities

  • Work on existing Excel-based reporting and planning models.
  • Develop, maintain and optimise complex Excel formulas and reporting structures.
  • Use advanced Excel functionalities to create dynamic and efficient reporting solutions.
  • Work with Name Manager, Structured Tables and Dynamic Referencing.
  • Perform data cleaning, transformation and manipulation using Power Query.
  • Convert cross-tabular data into structured, flat datasets through unpivoting.
  • Develop and maintain Power BI reports and dashboards.
  • Support the migration of existing Excel-based reporting models into Power BI.
  • Ensure data accuracy, consistency and reliability across reporting outputs.
  • Collaborate with stakeholders and participate in client meetings as required.

Mandatory Technical Skills

Advanced Excel

  • Strong formula creation skills, including LET, INDIRECT, OFFSET, SUMPRODUCT and XLOOKUP.
  • Name Manager.
  • Structured Tables and Dynamic Referencing.
  • Advanced data manipulation and reporting.

Power Query

  • Data cleaning and transformation.
  • Data restructuring and preparation.
  • Unpivoting and creating flat data structures for pivoting.

Power BI

  • Hands-on experience with Power BI reporting and dashboard creation.
  • Understanding of data modelling and reporting migration.

Additional Requirements

  • Minimum 3 years of relevant experience.
  • Strong analytical and problem-solving skills.
  • Good communication and stakeholder management skills.
  • Must be comfortable visiting the office for client meetings when required.
  • Candidates should be available to join within 15–30 days.

Required Skills

ExcelPower BI

Job Details

Employment TypeFull-Time
Work ModeOn-Site
Experience3 – 8 years
Positions1

Posted by

N/A

Posted on:

20 Nov 2026

About EliteRecruitments

More open roles

Browse all jobs →