Revenue Analyst

Jobtailor

California (MO)

On-site

USD 120,000 - 190,000

Full time

2 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

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

• 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

Requirements

5+ years of experience in analytics engineering, data analysis, revenue analytics or a related role, ideally at a high-growth B2B company
Advanced SQL and dbt skills, with a record of building production-grade models, tests, documentation, 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, custom rate cards, 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
Direct experience with Orb in a high-growth B2B consumption-based business (preferred)
Familiarity with revenue recognition, monthly close, and audit support (preferred)
Experience with AI infrastructure, developer platforms, or inference (preferred)
Ability to work onsite Tuesday–Thursday in the San Francisco or New York office
Unrestricted work authorization in the United States

Core Competencies

Demonstrates expertise in building and maintaining production-grade dbt models and dashboards, with advanced SQL skills and experience in revenue analytics. Proficient in connecting and reconciling complex data sources to provide accurate financial reporting and insights.

Highest-signal resume keywords