Revenue Accounting Data Analyst (Remote)
- Resources Global Professionals
- San Francisco, California
- Full Time
About This Role
This role is accountable for data validation, analysis, and reconciliation of Accounts Receivable (AR) and Deferred Revenue within a complex, data-driven environment. The consultant will use Databricks, SQL, and BI tools to ensure reliability of revenue data flowing from multiple platforms (Salesforce, Stripe, Oracle FAH). The role also supports audit readiness and financial disclosures for SaaS and consumption-based revenue streams.
The consultant will:
- Reconcile contracted revenue (Salesforce) with actual billings and receipts (Stripe).
- Validate and analyze data in Databricks that brings these sources together for financial reporting and ASC 606 compliance.
What that entails: writing SQL queries in Databricks to join Salesforce objects with Stripe transactions to verify:
- Customer IDs match.
- Usage data aligns with billing events.
- Deferred vs. recognized revenue is accurate.
Remote / Payrate range $70-80/hr. depending on experience
Duration of Project: 3-6 months
What You Will Work On
Key Responsibilities:
- Data Validation & Reconciliation:
- Validate and reconcile AR and Deferred Revenue datasets using Databricks to process and query large transactional data.
- Investigate data discrepancies leveraging BI tools and SQL queries.
- Revenue & Insights:
- Use Databricks notebooks to perform advanced data transformations and generate insights on AR sources and revenue streams.
- SQL Development:
- Build and optimize SQL queries (supported by AI tools like Claude Code / CodeX) for deep-dive analysis of revenue datasets.
- Audit & Compliance Support:
- Collaborate with Accounting and auditors, preparing PBC lists, footnote tie-outs, and evidence packages, ensuring compliance with ASC 606.
- Process Enablement:
- Develop repeatable workflows in Databricks for ongoing data validation and reporting.
What You Will Bring
Required Skills & Experience:
Technical Competencies:
- Advanced Databricks platform experience
- SQL skills for data mining and reconciliation
- Knowledge of BI tools for data validation and visualization.
Systems:
- Experience with Salesforce is strongly preferred.
- ERP Oracle FAH/AR and Stripe data integrations is a plus.
Accounting Expertise:
- Solid understanding of SaaS and consumption-based revenue and related accounting processes is needed.
Soft Skills:
- Ability to work independently in a fast-paced, cross-functional environment.
- Strong communication and documentation skills for auditor interactions.
What You Can Expect
- An inspirational place for you to do your best work, be engaged in meaningful ways, and continually develop the skills, competencies and qualities that set our team apart.
- Compensation commensurate with your qualifications, experience, and other factors including geographic location, market and operational factors.
- Total Rewards include: Medical, Dental, Vision, Life Insurance, Disability Insurance, 401(k) Savings Plan, Employee Stock Purchase Plan, Professional Development Program, Paid Time Off and Paid Sick Time (in geographies where legally required).
What We Do
At RGP, we're creating a future where businesses produce their best work without constraints. We've built a global network of over 2,600 experts across four regions, providing a comprehensive suite of solutions across on-demand talent, next-generation consulting, and outsourced services to support organizations at every stage of their growth journey. Trusted by Fortune 100 companies and emerging disruptors alike, we challenge conventional ways of working, drive growth, and pave the way for long-term success through bold innovation and fearless collaboration.
Our values guide everything we do and strengthen our commitment to people. By combining smart processes, human-centered design, and advanced technology, we celebrate our team's excellence and ensure we grow together. We believe in the power of continuous learning and development to drive both individual and organizational success. It's time to rethink how work gets done. Dare to Work Differently with RGP.
RGP is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, or any other legally protected trait and encourage all applicants to apply.