Assistant Manager Financial Planning & Analysis (FP&A)

Navlakha Management Services; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

On-site gym facility

Subsidized meals

Direct exposure to strategic financial

Digital transformation initiatives

Job summary

Navlakha Management Services in Mumbai invites an experienced Assistant Manager FP&A & MIS Reporting to lead financial and operational MIS reporting. You will analyze Gross Contribution, track Budget vs.

Actual performance, and build automated dashboards using Advanced Excel and BI tools to drive strategic decisions. The role requires CA or MBA (Finance) with 3–7 years of FP&A or MIS experience in pharma/manufacturing.

Qualifications

• Qualified CA or MBA in Finance with 3–7 years FP&A/MIS experience.
• Strong Excel (Power Query/Power Pivot/VBA) and BI tooling skills.
• ERP experience and data automation capability is preferred.

Responsibilities

• Lead MIS reporting across Sales, GC, inventory and KPIs.
• Develop division and cost center reports with variance analysis.
• Automate recurring financial reports and dashboards.
• Analyze sales trends, SKU/therapy profitability, and market drivers.
• Support budgeting, forecasting and cost optimization.

Skills

Advanced Excel

Power BI

SQL/Python

Forecasting

ERP experience

Education

CA or MBA in Finance

Tools

SAP/ERP

Tally ERP

Job description

Job Title: Assistant Manager FP&A & MIS Reporting (Finance)

Location: Andheri, Mumbai

Industry: Pharmaceutical / Manufacturing

Experience: 3 to 7 Years

Education: CA / MBA (Finance)

About the Role

We are seeking a sharp, data-driven Assistant Manager FP&A & MIS Reporting to join our Finance team. In this role, you will lead financial and operational MIS reporting, analyze Gross Contribution (GC), track Budget vs. Actual performance, and build automated business dashboards using Advanced Excel and BI tools to drive strategic decisions.

Key Responsibilities

• MIS Reporting & Performance Tracking:
  • Prepare monthly MIS reports covering Sales, Gross Contribution, Inventory, Receivables, Expenses, and operational KPIs.
  • Develop division-wise, business unit-wise, and cost center-wise reports.
  • Deliver comprehensive Budget vs. Actual vs. Previous Year variance analysis.
  • Drive standardization and end-to-end automation of recurring financial reports.
• Sales & Profitability Analytics:
  • Analyze Sales Quantity Reports (SFS & WOS) and evaluate sales trends.
  • Conduct SKU-wise, Therapy-wise, Customer-wise, and Market-wise Gross Contribution (GC) analysis.
  • Develop interactive dashboards to monitor product profitability and sales drivers.
• Manufacturing & Operational Finance:
  • Track and report on Yield, Capacity Utilization, Production Efficiency, and plant performance metrics.
  • Analyze production variances, operational efficiencies, and cost structures.
• Budgeting, Forecasting & Cost Optimization:
  • Support the annual budgeting, rolling forecasts, and financial planning cycle.
  • Perform cost center analysis, expense optimization studies, and scenario modeling.
• Business Intelligence & Process Automation:
  • Build dashboards and automate workflows using Power BI, Advanced Excel (Power Query/Power Pivot/VBA), and Python.
  • Maintain reporting accuracy, data integrity, and seamless integration with ERP systems.

Candidate Profile & Requirements

• Qualification: Qualified CA or full-time MBA in Finance.
• Experience: 3 to 5 years of relevant experience in FP&A, MIS Reporting, or Business Finance (Pharma or Manufacturing industry preferred).
• Technical Skills:
  • Advanced Excel proficiency (Power Query, Power Pivot, complex formulas; Macros/VBA preferred).
  • Hands-on experience with Power BI, SAP/ERP, and Tally ERP.
  • Working knowledge of SQL or Python for data modeling and automation is an advantage.
• Core Competencies: Strong analytical mindset, deep understanding of variance and cost analysis, and effective stakeholder presentation skills.

Perks & Benefits

• Complimentary on-site gym facility for employee wellness.
• Subsidized meals.
• Direct exposure to strategic financial planning and digital transformation initiatives.
• High-growth, collaborative work environment.