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.
What You Will Work On
- 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
- Advanced Databricks platform experience
- SQL skills for data mining and reconciliation
- Knowledge of BI tools for data validation and visualization.
- Experience with Salesforce is strongly preferred.
- ERP Oracle FAH/AR and Stripe data integrations is a plus.
- Solid understanding of SaaS and consumption-based revenue and related accounting processes is needed.
- 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).