Sr. Executive - Financial Planing & Analytics

Ajanta Pharma Ltd; Mumbai; On-site; INR 1,200,000 - 2,100,000; Full time

Benefits offered by this job

Free gym facility for employee welfare

Exposure to strategic financial规划

Career growth opportunities

Job summary

Ajanta Pharma Ltd in Mumbai is seeking a detail-oriented Assistant Manager - Finance to join the Finance team. The role focuses on preparing, analysing, and presenting MIS reports across Sales, GC, Inventory, Receivables, and budgeting.

You will build dashboards with Power BI, automate reports using Advanced Excel and Python, and support management with data-driven insights and variance analysis. Experience in FP&A, ERP-based reporting (SAP/Tally), and manufacturing cost analysis is preferred;

Qualifications

• Strong knowledge of MIS reporting, financial analysis and business performance reporting.
• Expertise in Budgeting, Forecasting, Variance Analysis, Cost Accounting and FP&A.
• Hands‑on experience in Power BI dashboard development and data visualisation.
• Working knowledge of Python for data analysis, automation and reporting.
• Strong understanding of data modelling and large dataset management.
• Working knowledge of ERP-based financial reporting (SAP/Tally).
• Excellent analytical, problem‑solving, communication and presentation skills.
• Ability to interpret financial data and provide actionable business insights.

Responsibilities

• Prepare monthly MIS reports covering Sales, Inventory, Receivables, Expenses, and overall business performance.
• Develop division‑wise, business unit‑wise, and cost centre‑wise MIS reports.
• Analyse Budget vs. Actual vs. Previous Year performance and provide detailed variance analysis.
• Present actionable financial insights and recommendations to senior management.
• Ensure timely, accurate, and reliable reporting of key financial and operational KPIs.
• Drive automation and standardisation of recurring MIS reports.
• Prepare Yield, Capacity Utilisation, Production Efficiency, and Manufacturing Performance reports.
• Analyse production variances, operational efficiencies, and manufacturing costs.
• Identify performance gaps and recommend process improvement opportunities.
• Support cost optimisation initiatives and operational excellence programmes.
• Coordinate with Manufacturing, Supply Chain, and Operations teams to improve reporting accuracy.
• Prepare and monitor departmental and manufacturing expense reports.
• Perform Budget vs. Actual analysis and investigate significant variances.
• Support annual budgeting, forecasting, and financial planning activities.
• Conduct cost centre analysis, product profitability analysis, and expense optimisation.
• Assist management with financial modelling and scenario analysis.
• Utilise Python and Advanced Excel for report automation and data analysis.
• Build and maintain financial data models to support business planning.
• Improve reporting efficiency through automation and process enhancements.
• Ensure data accuracy, integrity, and consistency across reporting systems.

Skills

MIS reporting

Financial analysis

Forecasting

Variance analysis

Communication

Presentation

Tools

Power BI

Python

SAP

Advanced Excel

Tally ERP

Job description

We are looking for a detail-oriented and analytical Assistant Manager - Finance to join our Finance team. The incumbent will be responsible for preparing, analysing, and presenting financial and operational MIS reports, including Sales, Gross Contribution (GC), Inventory, Receivables, Budget vs. Actual performance, Expenses, and Manufacturing Capacity Utilisation.

The ideal candidate should have strong expertise in financial analysis, MIS reporting, data modelling, and dashboard development using Advance Excel & Micros. Hands‑on experience with Advanced Excel, Power BI, Python, and SAP is essential to support business insights, reporting automation, and data‑driven decision‑making.

Key Responsibilities

• Prepare monthly MIS reports covering Sales, Inventory, Receivables, Expenses, and overall business performance.
• Develop division‑wise, business unit‑wise, and cost centre‑wise MIS reports.
• Analyse Budget vs. Actual vs. Previous Year performance and provide detailed variance analysis.
• Present actionable financial insights and recommendations to senior management.
• Ensure timely, accurate, and reliable reporting of key financial and operational KPIs.
• Drive automation and standardisation of recurring MIS reports.

2. Sales & Profitability Analysis

• Prepare and analyse Sales Quantity Reports (SFS & WOS).
• Conduct SKU‑wise, Therapy‑wise, Customer‑wise, and Market‑wise Gross Contribution (GC) analysis.
• Monitor sales trends, product profitability, and business performance.
• Support pricing strategy, profitability analysis, and strategic business decision‑making.
• Develop dashboards to monitor sales and profitability metrics.

3. Manufacturing & Operational Performance

• Prepare Yield, Capacity Utilisation, Production Efficiency, and Manufacturing Performance reports.
• Analyse production variances, operational efficiencies, and manufacturing costs.
• Identify performance gaps and recommend process improvement opportunities.
• Support cost optimisation initiatives and operational excellence programmes.
• Coordinate with Manufacturing, Supply Chain, and Operations teams to improve reporting accuracy.

4. Budgeting, Forecasting & Cost Analysis

• Prepare and monitor departmental and manufacturing expense reports.
• Perform Budget vs. Actual analysis and investigate significant variances.
• Support annual budgeting, forecasting, and financial planning activities.
• Conduct cost centre analysis, product profitability analysis, and expense optimisation.
• Assist management with financial modelling and scenario analysis.

5. Business Intelligence & Automation

• Utilise Python and Advanced Excel for report automation and data analysis.
• Build and maintain financial data models to support business planning.
• Improve reporting efficiency through automation and process enhancements.
• Ensure data accuracy, integrity, and consistency across reporting systems.

Required Skills

• Strong knowledge of MIS reporting, financial analysis and business performance reporting.
• Expertise in Budgeting, Forecasting, Variance Analysis, Cost Accounting and FP&A.
• Hands‑on experience in Power BI dashboard development and data visualisation.
• Working knowledge of Python for data analysis, automation and reporting.
• Strong understanding of data modelling and large dataset management.
• Working knowledge of Tally ERP and ERP‑based financial reporting.
• Excellent analytical, problem‑solving, communication and presentation skills.
• Ability to interpret financial data and provide actionable business insights.

Preferred Experience

• 3-5 years of experience in Financial Planning & Analysis (FP&A), MIS Reporting or Business Finance.
• Experience in the Pharmaceutical or Manufacturing industry.
• Exposure to ERP systems and Business Intelligence tools.
• Strong understanding of Inventory Management, Supply Chain, Production Reporting and Manufacturing Finance.
• Experience in automating financial reports, dashboards and management reporting.
• Familiarity with SQL or other database tools will be an added advantage.

What We Offer

• Free gym facility for employee wellness.
• Exposure to strategic financial planning, business analytics and digital transformation initiatives.
• A collaborative work environment with strong learning and career growth opportunities.