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
- Agile 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 Excellerator
📍 Bengaluru