Data Analyst (Advanced Excel & Power BI)
EliteRecruitments
Gurugram, Haryana, India
Full-Time
Posted 2 days ago
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.
About EliteRecruitments
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
- Operations Manager– Center of Excellence (Skill Development)Anudip Foundation · Coimbatore, Tamil Nadu, India
- Architect & Estimation Excellence - Oracle AI - ManagerPwC Acceleration Center India · Bengaluru, Karnataka, India
- Custom Software Developer, IT Software Engineer, Workflow Automation - Engineering Excellence & ExperienceRoche · Hyderabad, Telangana, India
- Accountant - Tally, Excel, Journal EntriesUR CFO Consultancy Pvt. Ltd. · Maharashtra, India
- Looking For a Excel TeacherFindMyGuru · India
- SME - SC Operational ExcellenceOrange Business · Mumbai, Maharashtra, India