Rebate Data Analyst

Ajanta Pharma Ltd; Mumbai; Hybrid; INR 800,000 - 1,200,000; Full time

Benefits offered by this job

Hybrid Work Model

Free Gym Facility

Exposure to international finance

Job summary

Ajanta Pharma Ltd. is seeking an Executive – Rebate Data Analyst to join the Finance team. You will analyze rebate and financial data, validate claims, support GTN activities, and assist with journal entries and tax computations.

The role demands strong Excel skills, attention to detail, and the ability to work in a high-volume environment. Hybrid work model and exposure to international finance processes are provided.

Qualifications

• Bachelor’s degree in Accounting, Finance, Commerce, or a related field.
• 2–4 years of relevant experience in financial analysis, rebate management, accounting, revenue management, or a related function.
• Strong understanding of the generic pharmaceutical industry, including product flow, reimbursement, chargeback administration, and chargeback payment processes.
• Understanding of Gross-to-Net (GTN) concepts and rebate/allowance calculations is preferred.
• Advanced Microsoft Excel skills including formulas, PivotTables, lookups, data analysis, and Macros/VBA.
• Strong analytical and problem-solving skills with the ability to work with large volumes of financial data.
• Excellent verbal and written communication skills; able to collaborate with stakeholders at various levels.
• Ability to manage multiple priorities and deliver high-quality work within tight deadlines.

Responsibilities

• Prepare, maintain & analyses management reports on a weekly and monthly basis.
• Review customer rebate and other claims and prepare supporting analysis to validate the claims.
• Compare customer-provided information with data available in the ERP and identify discrepancies.
• Prepare upload files for processing Journal Vouchers (JVs) in NetSuite.
• Prepare and review worksheets for True-Up calculations relating to GTN components.
• Process and analyze claims in accordance with agreements and policies.
• Perform detailed reconciliations and investigate variances between customer claims, ERP data, and financial records.
• Maintain documentation and schedules for audit and compliance purposes.
• Coordinate with internal and external stakeholders to resolve discrepancies timely.
• Ensure all activities are completed accurately within deadlines.
• Prepare ad-hoc reports and analyses as required by management.
• Perform other duties as assigned by the Manager.

Skills

Attention to detail

Analytical skills

Communication skills

Prioritization

Education

Bachelor’s degree in Accounting, Finance, Commerce, or a related field

Tools

NetSuite ERP

Microsoft Excel

Power BI

iContract

EDI

Job description

Work Model: Hybrid – 3 days Work from Office / 2 days Work from Home

Shift: 1:00 PM to 10:00 PM (Afternoon Shift)

Experience: 2–4 years

Education: Bachelor’s Degree in Accounting, Finance, or a related field

Department: Finance

About the Role

We are looking for a detail-oriented and analytical Executive – Rebate Data Analyst (Financial Data) to join our Finance team. The role will be responsible for analyzing rebate and financial data, validating customer claims, supporting Gross-to-Net (GTN) activities, preparing journal entry uploads, and assisting with tax computations and reporting.

The ideal candidate should have strong financial analytical skills, advanced Excel expertise, excellent attention to detail, and the ability to work effectively in a high-volume, time-sensitive environment.

Key Responsibilities

• Prepare, maintain & analyses management reports on a weekly and monthly basis.
• Review customer rebate and other claims and prepare supporting analysis to validate the claims.
• Compare customer-provided information with data available in the company’s ERP system and identify discrepancies.
• Prepare upload files for processing Journal Vouchers (JVs) in NetSuite.
• Prepare and review worksheets for True-Up calculations relating to various components of Gross-to-Net (GTN).
• Process and analyze claims in accordance with applicable agreements and company policies.
• Perform detailed reconciliations and investigate variances between customer claims, ERP data, and financial records.
• Maintain accurate documentation and supporting schedules for audit and compliance purposes.
• Coordinate with internal and external stakeholders to obtain required information and resolve discrepancies in a timely manner.
• Ensure all assigned activities are completed accurately and within established deadlines.
• Prepare ad-hoc reports and analyses as required by management.
• Perform other duties and responsibilities as assigned by the Manager.

Required Qualifications & Skills

• Bachelor’s degree in Accounting, Finance, Commerce, or a related field.
• 2–4 years of relevant experience in financial analysis, rebate management, accounting, revenue management, or a related function.
• Strong understanding of the generic pharmaceutical industry, including product flow, reimbursement, chargeback administration, and chargeback payment processes.
• Understanding of Gross-to-Net (GTN) concepts and rebate/allowance calculations is preferred.
• Advanced Microsoft Excel skills are essential, including strong knowledge of formulas, PivotTables, lookups, data analysis, and Macros/VBA.
• Strong analytical and problem-solving skills with the ability to work with large volumes of financial data.
• Excellent verbal and written communication skills, with the ability to communicate effectively with stakeholders at various levels within and outside the organization.
• Strong attention to detail, accuracy, organization, and follow-up skills.
• Ability to manage multiple priorities and deliver high-quality work within tight deadlines.
• Ability to work effectively both independently with minimal supervision and collaboratively within a team environment.

Preferred / Good-to-Have Skills

• Experience working with NetSuite ERP.
• Experience with iContract or similar contract/rebate management systems.
• Experience with Power BI, including dashboard preparation and data visualization.
• Experience with EDI and electronic chargeback processes.
• Exposure to U.S. pharmaceutical revenue management and reimbursement processes.
• Knowledge of U.S. tax processes and IRS requirements.

What We’re Looking For

The successful candidate will demonstrate:

• High attention to detail and a strong commitment to accuracy.
• Excellent analytical and numerical ability.
• Strong ownership and accountability for assigned activities.
• Ability to work in a high-volume, high-intensity environment while maintaining accuracy and meeting turnaround requirements.
• Strong organizational skills with effective prioritization and follow-through.
• A proactive approach to identifying issues, resolving discrepancies, and improving processes.
• Professional communication skills and the ability to collaborate effectively with cross-functional teams.

What We Offer

• Hybrid Work Model – 3 days working from office and 2 days working from home.
• Free Gym Facility to support employee health and wellness.
• Supportive and collaborative work environment.
• Exposure to international finance processes and U.S. market operations.
• Opportunities to work with leading financial and analytical tools such as NetSuite, Excel, Power BI, and iContract.
• Learning and professional development opportunities.
• Employee-focused workplace culture with opportunities for career growth.