Ajanta Pharma Ltd
Website:
ajantapharma.com
Job details:
Assistant Manager – Finance
Location: Andheri, Mumbai
Industry: Pharmaceutical
Experience: 3–5 Years
Qualification: CA / MBA (Finance)
Job Summary
We are looking for a detail-oriented and analytical Assistant Manager – Finance to join our Finance team. The incumbent will be responsible for preparing, analyzing, and presenting financial and operational MIS reports, including Sales, Gross Contribution (GC), Inventory, Receivables, Budget vs. Actual performance, Expenses, and Manufacturing Capacity Utilization.
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
1. MIS Reporting & Financial Analysis
- Prepare monthly MIS reports covering Sales, Inventory, Receivables, Expenses, and overall business performance.
- Develop division-wise, business unit-wise, and cost center-wise MIS reports.
- Analyze 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 standardization of recurring MIS reports.
2. Sales & Profitability Analysis
- Prepare and analyze 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 Utilization, Production Efficiency, and Manufacturing Performance reports.
- Analyze production variances, operational efficiencies, and manufacturing costs.
- Identify performance gaps and recommend process improvement opportunities.
- Support cost optimization initiatives and operational excellence programs.
- 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 center analysis, product profitability analysis, and expense optimization.
- Assist management with financial modeling and scenario analysis.
5. Business Intelligence & Automation
- Develop interactive dashboards using Power BI.
- Utilize 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.
- Advanced proficiency in Microsoft Excel (Pivot Tables, Power Query, Power Pivot, Advanced Formulas; VBA/Macros preferred).
- Hands-on experience in Power BI dashboard development and data visualization.
- 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.
- 🍱 Subsidized meals.
- 📈 Exposure to strategic financial planning, business analytics, and digital transformation initiatives.
- 🚀 A collaborative work environment with strong learning and career growth opportunities.
Click on Apply to know more.
