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
- Dynamic 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.
