Data Management - Business Finance (3rd party payroll)

Alembic Pharmaceuticals Limited; Mumbai; On-site; INR 500,000 - 700,000; Full time

Job summary

Alembic Pharmaceuticals Limited is seeking a data analyst with advanced Excel skills to manage databases, reconcile data, and create dashboards for MIS reporting. You will collaborate with internal teams to ensure data accuracy and confidentiality, while automating repetitive reporting tasks.

The role emphasizes meticulous data handling, proficiency with VLOOKUP/XLOOKUP, Pivot Tables, and data validation to deliver reliable insights for stakeholders across the organization.

Qualifications

• Advanced knowledge of Microsoft Excel required.
• Proficient in Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Conditional Formatting and Data Validation.
• Strong analytical and problem-solving skills are essential.

Responsibilities

• Manage and maintain databases, spreadsheets, and records with high accuracy.
• Perform data entry, validation, cleansing, and reconciliation activities.
• Create and maintain Excel trackers, dashboards, and MIS reports.
• Analyze data using advanced Excel functions such as VLOOKUP, XLOOKUP, Pivot Tables, Power Query, and formulas.
• Prepare periodic reports and present key findings to stakeholders.
• Monitor data quality and resolve discrepancies.
• Coordinate with internal teams to gather, update, and verify data.
• Ensure data confidentiality and compliance with company policies.
• Automate repetitive reporting tasks wherever possible.

Skills

Microsoft Excel

Pivot Tables

VLOOKUP/XLOOKUP

INDEX-MATCH

Conditional Formatting

Data Validation

Analytical Thinking

Problem Solving

Job description

Role & responsibilities

• Manage and maintain databases, spreadsheets, and records with high accuracy.
• Perform data entry, validation, cleansing, and reconciliation activities.
• Create and maintain Excel trackers, dashboards, and MIS reports.
• Analyze data using advanced Excel functions such as VLOOKUP, XLOOKUP, Pivot Tables, Power Query, and formulas.
• Prepare periodic reports and present key findings to stakeholders.
• Monitor data quality and resolve discrepancies.
• Coordinate with internal teams to gather, update, and verify data.
• Ensure data confidentiality and compliance with company policies.
• Automate repetitive reporting tasks wherever possible.

Required Skills

• Advanced knowledge of Microsoft Excel.
• Strong understanding of Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Conditional Formatting, and Data Validation.
• Good analytical and problem-solving skills.