Job Description – Sr. MIS Executive (Accounts Department)
Job Title: MIS Executive – Accounts
Department: Accounts & Finance
Location: Okhla Phase 2, New Delhi
Reports To: Finance Head
Employment Type: Full-Time
Job Summary
We are seeking a detail-oriented and analytical Sr. MIS Executive to support the Accounts & Finance department by preparing, maintaining, and analyzing financial and operational reports. The ideal candidate should possess strong Advanced Microsoft Excel skills, excellent analytical abilities, and a sound understanding of accounting processes. The role requires handling large datasets, preparing MIS reports, ensuring data accuracy, and providing timely insights to management.
Key Responsibilities (MIS & Reporting)
· Prepare daily, weekly, monthly, and quarterly MIS reports for management.
· Develop and maintain dashboards for financial and operational data.
· Generate reports related to sales, purchases, receivables, payables, inventory, and cash flow.
· Prepare customized reports as per management requirements.
· Analyze financial and operational data to identify trends and variances.
Accounts Support
· Coordinate with the Accounts team for timely collection and verification of financial data.
· Assist in bank reconciliation, ledger verification, and month-end reporting.
· Support preparation of GST, TDS, and other statutory data whenever required.
· Maintain proper documentation and report archives.
Data Management
· Validate and reconcile data received from various departments.
· Ensure accuracy, consistency, and confidentiality of financial information.
· Identify discrepancies and coordinate with concerned departments for corrections.
· Automate repetitive reports wherever possible.
Process Improvement
· Develop Excel-based templates and automated reports.
· Improve existing MIS systems and reporting formats.
· Suggest process improvements to enhance reporting efficiency and accuracy.
Required SkillsTechnical Skills
· Expert-level proficiency in Microsoft Excel.
· Strong knowledge of:
o Advanced Formulas (XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, etc.)
o Pivot Tables & Pivot Charts
o Conditional Formatting
o Data Validation
o Power Query
o Excel Dashboards
o Charts & Graphs
o Data Cleaning and Data Analysis
o Basic VBA/Macros (preferred)
· Working knowledge of accounting software such as Tally, Busy, SAP, Oracle, or ERP systems.
· Good understanding of Microsoft Word and PowerPoint.
Functional Knowledge
· Basic accounting principles.
· Accounts Payable (AP) and Accounts Receivable (AR).
· Ledger management.
· GST and TDS basics.
· Bank reconciliation.
· Financial reporting concepts.
Qualifications
· Bachelor's Degree in Commerce (B.Com), Finance, Accounting, Business Administration, or a related discipline.
· Additional certification in Advanced Excel or Data Analytics will be an advantage.
Experience
· 2–5 years of experience in MIS reporting, preferably within an Accounts or Finance department.
Competencies
· Strong analytical and problem-solving skills.
· High attention to detail and accuracy.
· Excellent numerical aptitude.
· Ability to manage multiple assignments and meet deadlines.
· Good communication and interpersonal skills.
· Ability to work independently as well as collaboratively.
Key Performance Indicators (KPIs)
· Accuracy of MIS reports.
· Timely submission of daily, weekly, and monthly reports.
· Reduction in reporting errors.
· Improvement in report automation and efficiency.
· Data accuracy and reconciliation performance.
· Support provided to finance and management decision-making.
Salary: As per company standards and candidate experience.
Pay: ₹25,000.00 - ₹35,000.00 per month
Benefits:
Work Location: In person
