Financial Planning and Data Analysis Specialist

IOL Chemicals and Pharmaceuticals Limited; Ludhiana; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

IOL Chemicals and Pharmaceuticals Limited is seeking a Financial Planning and Data Analysis Specialist to prepare, analyze, and maintain MIS reports and product costing data for informed decision-making. You will support cost analysis, budgeting, variance reporting, and inventory valuation with timely MIS reporting to leadership.

Responsibilities include preparing MIS reports, product and cost analyses, monthly closings coordination, and ensuring accuracy of cost data across departments.

Qualifications

• Strong analytical ability with attention to detail in reporting.
• Solid knowledge of costing, MIS preparation, budgeting and variance analysis.
• Experience with cost accounting, inventory accounting and plant finance is preferable.

Responsibilities

• Prepare MIS reports on production, sales, inventory, costing and profitability.
• Analyze product costing, process costing, batch costing and cost sheets.
• Monitor costs vs. budgets and provide detailed variance analyses.

Skills

Analytical thinking

MS Excel advanced

Cost analysis

Budgeting & variance analysis

Education

MBA Finance / CMA

Tools

SAP

MS Excel

Job description

Job Role: The Financial Planning and Data Analysis Specialist will be responsible for preparing, analyzing, and maintaining management information reports and product costing data for IOL Chemicals and Pharmaceuticals Limited. The role will support business decision-making through accurate cost analysis, budget monitoring, variance reporting, inventory valuation support, and timely MIS reporting to leadership.

Job Responsibilities:

1. Prepare periodic MIS reports related to production, sales, inventory, consumption, costing, profitability, and key business performance indicators.
2. Prepare and analyze product costing, process costing, batch costing, and cost sheets for pharmaceutical and chemical products.
3. Monitor actual costs against standard costs, budgets, and forecasts, and prepare detailed variance analysis with explanations.
4. Support monthly closing activities by coordinating with Finance, Production, Stores, Purchase, and other departments for accurate cost and operational data.
5. Assist in inventory valuation, material consumption analysis, yield analysis, process loss tracking, and reconciliation of production and inventory records.
6. Prepare profitability analysis by product, customer, business segment, and plant as required by management.
7. Coordinate for preparation of annual budgets, cost estimates, forecasts, and cost control reports.
8. Assist in cost audit activities by preparing required costing records, schedules, reconciliations, and supporting data for internal and statutory cost audit requirements.
9. Ensure accuracy, consistency, and timely submission of MIS and costing reports, and perform other related activities assigned from time to time.

Qualifications:

1. MBA Finance / CMA.
2. Working knowledge of cost accounting, inventory accounting, budgeting, variance analysis, and MIS reporting.
3. Exposure to manufacturing, pharmaceutical, chemical, or process industry costing will be preferred.
4. Proficiency in advanced MS Excel and working knowledge of SAP systems is desirable.

Experience: 8-10 years of relevant experience in MIS, costing, cost accounting, plant finance, or manufacturing finance, preferably in pharmaceutical, chemical, API, or process manufacturing industry.

Skills and Competencies:

1. Strong analytical ability with attention to detail and accuracy in reporting.
2. Good knowledge of costing principles, MIS preparation, budgeting, and variance analysis.
3. Proficiency in MS Office, especially advanced Excel; knowledge of SAP and data analysis tools will be an added advantage.