The role
Job description
Job Title: Data Analyst (Advanced Excel & Power BI)
Experience: 3+ Years
Locations: Pune / Noida / Bengaluru / Gurugram
Work Mode: Hybrid
Employment Type: Full-Time
Work Location & Mode
Locations: Pune, Noida, Bengaluru, and Gurugram.
Work Mode: Hybrid.
Job Overview
We are looking for a skilled Data Analyst with 3+ years of experience in data analysis, reporting, and visualization. The ideal candidate should have strong hands-on expertise in Advanced Excel and Power BI, along with the ability to analyze large datasets, generate meaningful insights, and create interactive dashboards to support business decision-making.
Key Responsibilities
Collect, clean, validate, and analyze data from multiple sources.
Develop and maintain interactive dashboards and reports using Power BI.
Work extensively with Advanced Excel for data analysis, reporting, and automation.
Create complex Excel formulas, Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, and other advanced functions.
Build data visualizations, KPI reports, and performance dashboards.
Identify trends, patterns, and business insights from large datasets.
Prepare regular and ad-hoc reports for business stakeholders.
Ensure data accuracy, consistency, and integrity across reports.
Collaborate with cross-functional teams to understand reporting requirements and deliver analytical solutions.
Optimize existing reports and dashboards to improve efficiency.
Required Skills & Qualifications
3+ years of relevant experience as a Data Analyst, MIS Analyst, Reporting Analyst, or Business Analyst.
Strong hands-on experience with Advanced Excel.
Proficiency in Power BI, including dashboard development and data visualization.
Good understanding of Pivot Tables, Power Query, VLOOKUP/XLOOKUP, INDEX-MATCH, and complex Excel formulas.
Experience in data cleaning, data transformation, and data validation.
Knowledge of Power BI DAX, Power Query, and data modelling.
Strong analytical, logical, and problem-solving skills.
Excellent communication and stakeholder management skills.
Preferred Skills
Basic knowledge of SQL for data extraction and querying.
Experience working with large datasets and multiple data sources.
Understanding of KPI tracking, MIS reporting, and business performance analysis.