Revenue Analytics Engineer for Growth & Forecasting

Jobtailor; California (MO); On-site; USD 120,000 - 190,000; Full time

Job summary

Jobtailor seeks an experienced analytics engineer to build and maintain production-grade dbt models and dashboards that connect Salesforce, CPQ, Orb, and product usage data. You will create canonical data marts for contracts, subscriptions, and invoices to support revenue reporting and forecasting.

You will partner with Finance to govern metrics for bookings, ARR, and growth, while enabling reliable monthly closes and variance analysis. Remote-friendly but onsite Tue–Thu in SF/NY as needed.

Qualifications

• 5+ years in analytics engineering, data analytics or a related role at a high-growth B2B company.
• Advanced SQL and dbt skills with production-grade models, tests and lineage in a cloud data warehouse.
• Hands-on experience with usage-based billing or metering platforms such as Orb and payment platforms such as Stripe.
• Experience modeling usage-based commercial terms including minimum commitments, prepaid credits, tiered or volume pricing, overages and contract changes.
• Experience working with Salesforce and CPQ data including products, price books, quotes, orders, amendments and renewals.
• Experience building dashboards and self-serve analytics in BI tools such as Sigma or Hex.

Responsibilities

• Build and maintain production-grade dbt models and dashboards connecting Salesforce and CPQ, contracts, Orb, and product usage data.
• Create canonical marts for customers, products, contract terms, subscriptions, commitments, credits, billable usage, and invoices.
• Reconcile metered product usage to billed revenue, invoice line items, and contract terms.
• Investigate gaps before they affect customers or financial reporting.
• Partner with Finance and Revenue Operations to define and govern metrics for bookings, contracted commitments, consumption, billed revenue, ARR, NDR, and expansion.
• Support monthly close, revenue forecasting, and operating reviews with variance and trend analysis.
• Document metric logic, source ownership, lineage, and exception handling.
• Add tests and version control to maintain reliable revenue data as systems change.
• Connect contract terms, pricing and CPQ data, product usage, metering, billing, and invoices into an accurate view of customer revenue.
• Translate new pricing and contract structures into durable data models and dashboards for Finance and Revenue Operations.

Skills

Advanced SQL

Dbt Model Development

Revenue Analytics

Salesforce Data Management

Usage-Based Billing

Tools

Dbt

Salesforce

CPQ

Orb

Stripe

Sigma

Hex

Job description

Jobtailor seeks an experienced analytics engineer to build and maintain production-grade dbt models and dashboards that connect Salesforce, CPQ, Orb, and product usage data. You will create canonical data marts for contracts, subscriptions, and invoices to support revenue reporting and forecasting.

You will partner with Finance to govern metrics for bookings, ARR, and growth, while enabling reliable monthly closes and variance analysis. Remote-friendly but onsite Tue–Thu in SF/NY as needed.