MIS Executive - Financial Modelling

Key Responsibilities

• Financial Modelling & Forecasting:

  Build and maintain financial models including Profit & Loss (P&L) statements, Balance Sheets, Cash Flow statements, and scenario-based forecasts to support business planning and decision-making.

• Data Analysis & MIS Reporting:

  Create accurate, timely, and interactive MIS dashboards and reports using Excel, Power Query, or Google Sheets for key stakeholders.

• Advanced Excel Expertise:

  Use functions like VLOOKUP, HLOOKUP, INDEX-MATCH, PivotTables, and conditional formatting to analyze and summarize large financial datasets.

• Automation & Optimization:

  Automate recurring reports and data workflows using Excel VBA, Macros, Google Apps Script, or Power Query to improve efficiency.

• ETL & Data Management:

  Extract, transform, and load financial data from multiple sources into Excel or Google Sheets for analysis. Ensure data accuracy, consistency, and integrity.

• Sensitivity & Scenario Analysis:

  Perform what-if analysis to evaluate the financial impact of business changes or external factors.

• Data Validation & Cleansing:

  Implement rules and processes to clean and validate raw data, ensuring high-quality inputs for financial reporting.

Qualifications & Requirements

• Bachelor s degree in

  Finance, Accounting, Economics, or related field

• 2-5 years of hands-on experience in

  financial data management or MIS reporting

• Proven experience in

  financial modelling, budgeting, and forecasting

• Proficiency in

  MS Excel, Google Sheets

  , and tools like

  Power Query or VBA/macros

• Strong analytical and problem-solving abilities
• Excellent communication and presentation skills
• Ability to handle multiple projects and meet deadlines in a fast-paced environment

Job Perks

• Fully Remote Role

  Work from anywhere

• Competitive Salary Package

• Professional Growth & Learning Opportunities

• Exposure to real-time business data and financial strategy