Data Analyst - Reconciliation
Data Analyst - Reconciliation
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job ID:42712
Location:Mumbai: Solitaire Corporate Park
Position Category:Administration/Business Support
Position Type:Employee Regular
Role Overview:
The Data Analyst - Reconciliation plays a critical role in supporting the monthly and quarterly commission process by ensuring accurate reconciliation between CRM sales data and ByD invoicing. This role does not involve report building or commission calculation but focuses on validating invoice-to-sale links resolving commission queries and refining processes to improve accuracy and efficiency.
Key Responsibilities:
- Invoice Reconciliation
Conduct monthly reviews of invoices raised for Assessment and Inspection clients.
Cross-check invoices against CRM records and previous reports to validate linkage to legitimate sales opportunities.
Apply a structured validation process including checks on contract alignment product match and invoice timing relative to the sale. - Commission Validation Support
Identify and document instances where invoices relate to clients with non-commissionable sales to pre-empt and resolve queries.
Provide clear explanations for discrepancies such as mismatched products or contracts. - Query Resolution
Collaborate with sales teams monthly to address commission disputes ahead of quarterly payouts.
Investigate and verify missed opportunities or clarify why certain sales are not commissionable.
Support the development of improved query management processes (e.g. dedicated SIP inbox). - Process Improvement
Assist in refining the reconciliation process as part of a new operational activity.
Investigate anomalies such as missing invoices or mismatched client records.
Work with Finance and Sales to identify root causes and propose solutions (e.g. document types third-party invoicing). - Team Collaboration
Support the Finance Analyst in responding to ad hoc SIP commission queries.
Work closely with internal stakeholders to ensure alignment and transparency in commission-related activities.
Support Payroll in ensuring the submission of accurate SIP information each quarter.
Key Skills/Qualifications:
- 56 years of experience in data analysis and/reconciliation ideally within a sales or finance environment.
- Strong working knowledge of Excel including advanced functions for data validation and reconciliation.
- Proven ability to identify discrepancies and investigate data anomalies with accuracy and attention to detail.
- Experience working with CRM and ERP systems (e.g. SAP ByD) highly preferred.
- Clear and confident communicator able to collaborate effectively with cross-functional teams and resolve queries professionally.
- Diligent process-driven and committed to maintaining high standards of data integrity and operational efficiency.
*If you are successful in securing a role with us you will be subject to pre-employment checks depending on the legal requirements and practices in your country of employment.
Diversity and Inclusion at LRQA:
We are on a mission to be the place where we all want to work and we are passionate about embracing different perspectives because we understand the value this brings to our business our clients and each other. We are all about creating a safer and more sustainable future and our inclusive culture is right at the heart of our business.
Together our employees make our communities better and we want you to be part of our diverse team!
LRQA is a leading global assurance integrity and expertise we bring to our partnership with clients support their journey to a safer more secure and more sustainable future. (Group entities).
Copyright LRQA 2021. All rights reserved. Terms of use. Privacy Policy.
Required Experience:
IC
Employment Type
Full Time
