Key Responsibilities

Data Management & Cleansing

Collect, consolidate, and clean data from multiple internal sources.

Identify and resolve data inconsistencies, duplicates, and missing information.

Perform data validation and quality checks to ensure reporting accuracy.

Standardize datasets for reporting and analysis.

Maintain data integrity across recurring reports.

Data Analysis & Reporting

Analyze large datasets to identify trends, patterns, and business insights.

Prepare recurring MIS reports, dashboards, and analytical summaries.

Generate weekly, monthly, quarterly, and ad hoc reports.

Support business reporting through accurate data compilation and analysis.

Monitor key metrics and maintain reporting templates.

Advanced Excel

Build and maintain advanced Excel workbooks using:

XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS

Pivot Tables & Pivot Charts

Power Query

Power Pivot

Conditional Formatting

Data Validation

Energetic Charts

Advanced formulas and functions

Automate repetitive reporting activities wherever possible.

Optimize existing spreadsheets for efficiency and accuracy.

Presentation Development

Develop executive-quality PowerPoint presentations using analyzed data.

Convert raw data into meaningful charts, graphs, tables, and infographics.

Ensure presentations are visually engaging, accurate, and professionally formatted.

Create recurring business review decks and performance summaries.

Maintain consistency in branding,



formatting, and presentation standards.

Documentation & Process Support

Maintain reporting documentation and standard operating procedures (SOPs).

Organize and archive reporting files and historical data.

Continuously improve reporting templates and data preparation processes.

Support internal teams by providing clean, accurate datasets for reporting purposes.

Required Skills

Technical Skills

Advanced Microsoft Excel (Expert Level)

Microsoft PowerPoint (Expert Level)

Data Cleansing & Data Validation

Data Analysis & Reporting

MIS Reporting

Power Query

Pivot Tables & Pivot Charts

Data Visualization

Strong Attention to Detail

Preferred Skills

Power BI

SQL (Basic to Intermediate)

VBA/Macros

Power Automate

Basic Python for data manipulation

Qualifications

Bachelor's degree in Business Administration, Commerce, Statistics, Mathematics, Computer Science, Engineering, or a related field.

Relevant certifications in Excel, Power BI, or Data Analytics are an added advantage.

Experience Required

5+ years of experience in Business Analysis, MIS Reporting, Data Analytics, or Reporting Operations.

Strong hands-on experience with large datasets and reporting.

Proven expertise in advanced Excel and PowerPoint.

Experience in data cleansing, reconciliation, and validation.

Experience preparing executive-level reports and presentation decks.

📌 Business Analyst (Bengaluru)
🏢 NetApp
📍 Bengaluru