Lead Data Engineer

About the Position

Lead Data Engineer, Revenue Operations

Boulder, CO (US)

Stream powers real-time Chat, Video, Activity Feeds, and AI Moderation for billions of end-users across thousands of apps, from Strava and Bumble to eBay and Patreon. Our platform processes billions of API requests per month and supports applications with millions of concurrent users, while delivering highly reliable, low-latency services and a great developer experience.

The data platform in this role is what our go-to-market and product decisions run on. You'll own the pipelines, integrations, and central repository that bring Stream's data together, plus the models that turn it into something the business can trust. We're mid-migration to GCP, so there's real architecture to shape.

Two things make this different from most data jobs. A Revenue Operations team owns the stakeholder relationships and the business questions, so your time goes into building durable systems instead of chasing requirements. And analytics translation is increasingly handled by AI, which is exactly why the engineering underneath it has to be right. Data modeling is the core of this role.

It's a small team and a fast, unfinished environment. High drive, sometimes hectic. If you like owning a platform end to end, that's the appeal.

This is a full-time job opening based in Boulder (3 days hybrid).

Responsibilities

• Build and evolve the ingestion platform. Python/dltHub pipelines loading into BigQuery, integrating Salesforce, Stripe, Postgres, PostHog, cloud billing, and other GTM systems. Design incremental loading, write dispositions, and scheduling, and make onboarding a new source predictable and low-risk.
• Build the transformation layer. SQLMesh models across our layered architecture, clean and well-tested dimensional models, and clear conventions for grain, naming, and audit. Keep the core business models accurate: revenue waterfall, GTM funnel, marketing attribution, and product usage.
• Improve reliability. Expand data quality and observability, build freshness checks, reconciliation tests, and execution monitoring. Take point when data is stale, wrong, or late, and trace issues across pipelines, transformations, and upstream systems.
• Own the platform infrastructure. BigQuery and supporting GCP, plus Terraform, IAM, service accounts, scheduled jobs, and deployment workflows, tuned for security, reliability, and cost.
• Enable the business. Deliver trusted datasets to Looker Studio, Google Sheets, and our internal CRM, and run reverse ETL back into operational systems like Salesforce.
• Raise the technical bar. Help shape engineering standards and architecture, review pipeline and model changes, and share context with the analysts and engineers who contribute to the platform.

Requirements

• 5+ years building and operating production data platforms
• Expert SQL and strong Python
• Experience designing incremental, idempotent, well-tested pipelines
• Solid experience with BigQuery or another modern cloud data warehouse
• Experience with modern ELT tooling such as SQLMesh, dbt, dltHub, Fivetran, or Airbyte
• Experience with orchestration and CI/CD (GitHub Actions, Airflow, or equivalent)
• Infrastructure-as-code experience with Terraform or a close equivalent
• Strong data modeling skills: dimensional modeling, warehouse design, testing, and observability

Nice to Have

• Revenue Operations or GTM data experience
• Salesforce and Stripe data modeling
• Product analytics platforms such as PostHog
• Marketing attribution and funnel analytics
• MRR, expansion, contraction, churn, and revenue reconciliation logic
• Working closely with business stakeholders while keeping engineering discipline
• GCP depth, including IAM, service accounts, and BigQuery cost optimization

We Offer

• 19+ days of paid time off plus 10 paid holidays
• Hybrid work flexibility (3 days a week from the office)
• Free health insurance for the employee and partial coverage for dependents (80% contribution coverage for health and 100% for dental and vision)
• 401k contribution plan with 4% match
• Fitness stipend
• Company equity
• Dog-friendly office!
• A Macbook Pro provided
• A Learning and Development budget
• Team lunches and plenty of snacks
• RTD pass + free parking pass on Pearl Street
• An office on Pearl Street in downtown Boulder
• 12 weeks paid parental leave for primary parents
• The opportunity to attend or present to global conferences and meetups
• The possibility to visit our office in Amsterdam

Note: this list of benefits applies to Colorado-based employees and is adjusted per your location of residence.

Salary (for Colorado only): Our salary ranges are based on national averages. We have wide ranges so we can be flexible and determine compensation based on a number of factors including the candidate's skills, level of experience, and location.

For Colorado-based candidates we offer a salary $150,000 to $180,000 per year, plus stock options. Final offer within this range depends on experience and interview outcome.

Hybrid office policy: applicants based (or relocating to) one of our office locations are expected to work according to the applicable local office attendance policy.

Equal opportunity employer statement: Stream provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Note for external recruiters: We currently have this role covered and do not accept unsolicited agency resumes. We are not responsible for any fees related to unsolicited resumes.