The Job
As a Store Ingestion Specialist, you will play a key role in managing the ingestion, validation, reconciliation, and posting of financial and royalty data received from digital service providers (DSPs) and other delivery channels. You will be responsible for ensuring the accuracy and completeness of raw financial files, supporting timely royalty postings, resolving data discrepancies, and maintaining data integrity throughout the ingestion process.
You will work closely with Finance, Accounting, BI, Tech/Data teams, DSPs, and other internal and external stakeholders in an international environment to ensure accurate and timely processing of financial and royalty data.
You will be reporting to the Head of Customer Finance and Legal Operations based in Mumbai and will work closely with the broader Revenue Invoicing, Ingestion and Customer Finance teams in an international environment.
Key Responsibilities:
Receive and process raw financial and royalty files from various DSPs and delivery channels through email, SFTP/FTP, and backend portals, across formats including Excel, PDF, and TXT.
Review incoming raw files for completeness and accuracy, identifying incorrect templates, missing information, data inconsistencies, and discrepancies between summary and detailed data.
Maintain accurate records of raw files by ensuring files are stored in designated S3 buckets in accordance with internal processes.
Manage the ingestion and posting of royalty and financial reports, including the upload of FX rate files and success files through FileZilla.
Monitor ingestion processes and identify errors or issues, coordinating with relevant Tech, BI, Data, and Finance teams to ensure timely resolution.
Review ingested reports for accuracy and perform reconciliation of financial data, including cross-checking AR invoices and payments.
Export data to Retool and apply relevant foreign exchange rates as part of the ingestion and posting process.
Perform appropriate validation and second-level reviews before obtaining Finance approvals and facilitating data posting.
Manage regular SR/SIP report postings, ensuring postings are completed accurately and within defined timelines.
Coordinate with DSPs to obtain corrected or updated raw files where required and follow up on data discrepancies until resolution.
Work closely with Tech and Data teams during posting activities to monitor progress, troubleshoot issues, and ensure timely completion.
Review postings against invoices and receipts created in Oracle and investigate discrepancies and variances.
Perform detailed analysis of complex or exceptional cases and coordinate with relevant stakeholders to resolve differences.
Communicate changes in split percentages or other relevant business inputs in advance to ensure appropriate accounting adjustments.
Support monthly financial closing activities by ensuring ingestion, posting, reconciliation, and supporting financial data are complete and accurate.
Prepare, maintain, and export relevant reports and documentation for financial reporting, audit, and record-keeping purposes.
Collaborate with Finance, Accounting, BI, Tech/Data, and other internal stakeholders to resolve data, posting, reconciliation, and accounting-related queries.
Identify recurring data and process issues and contribute to improvements in data quality, automation, and operational efficiency.
Ensure adherence to internal controls, procedures, data management standards, and applicable financial policies throughout the ingestion and posting processes.
Prioritize daily activities effectively and manage multiple ingestion, reconciliation, and posting activities within defined timelines.
Work closely with the Royalty Ingestion Lead and other revenue and customer finance specialists to ensure consistent and efficient execution of store ingestion activities.