Revenue Analyst (Order to Cash)
Posted Updated
Description
- We are hiring an O2C Revenue Analyst to support the accuracy, completeness, and reliability of data flowing through Sonar’s order-to-cash and revenue accounting processes
- This role focuses on extracting, transforming, validating, and loading Salesforce CPQ data into Aptitude RevStream (AREV), investigating data exceptions, and reconciling billing information to the revenue subledger
- Working closely with Revenue Accounting, Billing Operations, and BizTech, you will apply strong data processing skills, advanced Excel capabilities, SQL reporting knowledge, and hands-on AREV experience to support monthly and quarterly closes
- You will help investigate transactions requiring additional calculations or system configuration, with accounting conclusions and configuration changes reviewed by the appropriate process owners
- This role will also strengthen team coverage through cross-training, clear process documentation, and knowledge sharing
- Your work will help reduce reliance on individual process owners, improve data quality and controls, and build a more efficient and scalable revenue processing workflow
- Extract Salesforce CPQ and billing data, clean and transform datasets, validate completeness and accuracy, and prepare and load data inputs
- Reconcile billing data, investigate differences, and maintain supporting schedules and evidence for monthly and quarterly closes
- Investigate and resolve recurring data exceptions, including upgrades, amendments, prorated transactions, and multi-year agreements, in partnership with Revenue Accounting and Billing Operations
- Support additional calculations, product configuration, and revenue recognition rule testing, following established accounting guidance, approval requirements, and change controls
- Develop and maintain SQL reports and Excel-based transformations, mappings, and validation checks to identify missing, inconsistent, or incorrectly classified data
- Identify opportunities to use automation, technology, and AI-enabled tools to reduce manual work while maintaining appropriate review and controls
- Prepare clear data lineage, reconciliation support, and process documentation for internal reviews and external audits
Benefits
- 401K Plan: Sonar US matches up to 4% of gross salary
- 90% healthcare premium coverage for employees, 60% for dependents
- EAP (Employee Assistance Program) Health Savings Accounts (HSA, FSA, DCFSA). Supplemental coverage is offered by EE’s expense
- Life and disability insurances fully paid by Sonar. Sonar covers 100% of Telemedicine for FTE whom are covered by Sonar medical
- Hospital Indemnity, Accident, Critical Illness
- Pet Insurance
- Time Off: 25 PTO days plus additional days based on seniority and circumstances
- Commuting: Public transport reimbursement of 60% for annual subscription
- Free parking space
- Pension: Sonar UK contributes 50% of the total costs, which amounts to 5% of your gross salary for saving. Employees contribute the other 5%
- Flexibility to work from home 2 days a week on Wednesdays and Fridays
- Health Insurance: Sonar covers 100% of the employee premiums for medical, dental, and EAP (Employee Assistance Program) plans through BUPA
- Time Off: 28 PTO days, plus additional days based on seniority and circumstances
- Commuting: we will reimburse 60% towards the cost of an annual public transport pass
- Experience using Aptitude RevStream, SFDC, NetSuite and Stripe is preferred
- The ability to work on-site, collaborate across Finance and BizTech, and meet deadlines in a fast-paced close environment
- Strong attention to detail and the ability to document repeatable procedures, communicate technical issues clearly, and cross-train colleagues
- 4+ years of strong hands-on experience in O2C data operations, revenue systems, data processing, or data engineering, preferably in a software or subscription-based business
- A bachelor’s degree in Accounting, Finance, Information Systems, Data Analytics, or a related field, or equivalent relevant experience
Skills
Sign in to read and join the discussion.