MIS Executive / Advanced Excel Expert (Greater Noida)

We are looking for an Advanced Excel Specialist who can manage large datasets, automate repetitive reporting tasks using VBA/macros, and perform payment reconciliation with accuracy and speed. The role requires strong analytical skills, data cleaning ability, and expertise in Excel functions, Power Query, and automation.

Responsibilities

• Work on large datasets (50,000+ rows) in Excel and clean, transform & format data
• Create & maintain MIS reports, dashboards, and automated templates
• Perform payment reconciliation, vendor/customer settlement & mismatch reports
• Use advanced Excel functions: IF / SUMIF / COUNTIF / VLOOKUP / XLOOKUP / INDEX-MATCH / TEXT / DATE / FILTER etc.
• Build Pivot tables, charts, and dynamic summary reports
• Automate recurring tasks using Excel Macros / VBA
• Import, merge & consolidate multiple files (CSV, Excel etc.)
• Work closely with Accounts / Finance / Operations teams to deliver reports within deadlines
• Ensure data accuracy, zero-error output and fast turnaround time

Required Skills

✅ Advanced Excel (must)
✅ Power Query / Power Pivot
✅ Excel formulas (lookup, logical, text, date, array functions)
✅ Pivot Tables & Charts
✅ VBA / Macros (automation)
✅ Financial or payment reconciliation experience
✅ Data cleaning & transformation
✅ Strong analytical and problem-solving ability
✅ Fast working speed with keyboard shortcuts & productivity hacks

Preferred / Good to Have

• Google Sheets + App Script
• Power BI or Tableau dashboard experience
• Basic SQL knowledge
• Excel certification or VBA course completion

Education

• Any Graduate (B.Com, BBA, BCA, B.Tech, B.Sc, M.Com etc.)

How to Apply

Apply with updated resume + sample Excel work (if available).

-------------------------------------------------------------------------------------------

MIS Executive, Advanced Excel, Excel Expert, Data Analyst, VBA Developer, Macro Automation, Reporting Analyst, Power Query, Power Pivot, Reconciliation Analyst, Excel Specialist, MIS Reporting, Dashboard Developer, Excel Automation, Data Cleaning, Payment Reconciliation

Job Types: Full-time, Permanent

Pay: ₹25,000.00 - ₹40,000.00 per month

Application Question(s):

• Are you proficient in advanced Excel formulas (VLOOKUP / XLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, IF with nested logic)?
• Do you have hands-on experience in Excel Macros / VBA automation?
• Can you handle and clean big datasets (50,000+ rows) without system lag?
• Do you have experience in payment reconciliation / financial data handling?
• How many years of experience do you have in Excel-based data analysis?

Work Location: In person