Data Analyst - Reconciliation

Role Overview:

Data Analyst - Reconciliation

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: