Data Analyst - Reconciliation

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:

• 5–6 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.
  
  

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 provider. The 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.