Finance Controller/Finance Data analyst

Acme Pharmaceutical; Ahmedabad District; On-site; INR 500,000 - 900,000; Full time

Job summary

Acme Pharmaceutical in India seeks a finance data analyst to lead MIS reporting and cost analytics. You will derive key financial metrics such as fixed and variable costs, margins, ROI and break-even analyses, then compile daily to monthly reports and forecasts.

You will also extract data from Tally and ERP systems to support dashboards and decision-making. The role requires strong Excel skills, proficiency in Google Sheets, and the ability to present clear business insights.

Qualifications

• Proficient in MS Excel and advanced Excel features for financial analysis.
• Experience with Google Sheets and ERP systems in finance.
• Basic dashboard creation skills.

Responsibilities

• Derive Fixed Cost, Variable Cost, Operational Expense, Net Margin, ROI, Break Even and Working Capital insights.
• Prepare daily, weekly & monthly MIS reports.
• Share Sales forecast, performance, gaps and business insights.
• Extract data from Tally and ERP for reporting.

Skills

MS Excel

Advanced Excel

Tables

Power Query

Google Sheets

Tally

ERP in finance

Dashboard preparation

Analytical skills

Communication skills

AI tools

Tools

Tally

ERP software

Job description

Role & responsibilities

• Knows to derive Fixed Cost, Variable cost, Operational Expense, Net Margin, ROI, Break Even, Working Capital, and other important aspect of business.
• Prepare daily, weekly & monthly MIS reports
• Share Sales forecast, Performance, Gaps, and Business insights.
• Manage data in Excel & Google Sheets
• Prepare trackers, dashboards & reports
• Collect and verify data from different departments
• Works as second in command with Finance.
• Extract data from Tally and ERP independently for reporting
• Maintain records and documentation
• Ensure accurate and timely reporting

Required Skills:

• Excellent knowledge of MS Excel, Advance Excel, Tables, Power Query
• Good knowledge of Google Sheets, Tally other ERP in finance
• Basic knowledge of dashboard preparation
• Good analytical and communication skills
• Basic knowledge of AI tools