Store Ingestion Specialist
Core
Manage the ingestion, validation, reconciliation, and posting of financial and royalty data from digital service providers (DSPs) and delivery channels to ensure accurate royalty postings and data integrity.
Role type
Senior IC finance operations specialist (royalty ingestion)
Builds
Accurate royalty and financial reports for internal accounting and external DSP settlements
Domain
Music industry finance / royalty operations
Deliverable
dashboards & analysis
Required skills
Financial data processing, reconciliation, data validation, discrepancy investigation, process improvement, stakeholder coordination, operational prioritization
Preferred skills
DSP/media industry experience, royalty operations knowledge, SQL, Retool, FileZilla, Amazon S3, Oracle ERP
Technologies
Excel, Google Sheets, SQL, Retool, FileZilla, Amazon S3, Oracle
Responsibilities
Receive and process raw financial/royalty files from DSPs via email, SFTP, and portals; validate file completeness and accuracy; maintain records in S3 buckets; upload FX rates and success files; monitor ingestion processes and coordinate error resolution; reconcile financial data against AR invoices and payments; export data to Retool with FX adjustments; perform second-level reviews before Finance approval; manage SR/SIP report postings; coordinate with DSPs for file corrections; investigate posting discrepancies in Oracle; support monthly financial closing; prepare reports for audit and record-keeping.
Seniority
Senior, hands-on IC