Lead Data Engineer

Stream; Boulder (CO); Hybrid; USD 150,000 - 180,000; Full time

Benefits offered by this job

Paid time off 19+ days

Hybrid work (3 days in office)

Health insurance (employee)

401k with match

Stock options

Learning & development budget

MacBook Pro provided

Office on Pearl Street

Job summary

Stream is seeking a Lead Data Engineer for Revenue Operations to own the data platform end-to-end. You will build ingestion pipelines, transform data, and ensure reliability while shaping the platform architecture in a fast-paced environment.

You will collaborate across GTM and product to deliver trusted datasets to Looker Studio, Google Sheets, and internal CRM, with AI-forward analytics translation and strong emphasis on data modeling and architecture.

Qualifications

• 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.

Responsibilities

• Build and evolve the ingestion platform using Python/dltHub pipelines into BigQuery.
• Build the transformation layer with SQLMesh models and clean dimensional models.
• Improve reliability with data quality checks and monitoring; trace issues across pipelines.
• Own the platform infrastructure including BigQuery, GCP, Terraform, IAM, and deployment workflows.
• Enable the business by delivering trusted datasets to Looker Studio, Sheets, and CRM; run reverse ETL to Salesforce.
• Raise the technical bar by shaping engineering standards and architecture.

Skills

SQL

Python

BigQuery

ELT tooling

CI/CD

Terraform

Data modeling

GCP

Tools

dbt

dltHub

SQLMesh

Fivetran

Airbyte

Airflow

Job description

Lead Data Engineer, Revenue Operations

About Stream

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 role

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).

What you'll do

• 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.

About you

You like owning a platform end to end and staying hands-on while you do it. You're comfortable in a small team, and you're energized by building rather than by growing an org around you. You influence through the work: architecture, code review, and clear conventions, not a title.

You have:

• 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

Bonus points:

• 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

Why this one is worth a look

• You own the data platform the whole company runs on, not one pipeline or one domain.

• Your work powers forecasting, commissions, pricing, churn analysis, product insight, and board reporting. The quality of your engineering shows up directly in how the company runs.

• The stack is modern and AI-forward: Python, dlt, SQLMesh, BigQuery, Terraform, GitHub Actions, with Claude, Cursor, and Linear across the team.

• You inherit a foundation that already works, built from scratch, so you evolve and harden it rather than start from zero.

You’ll thrive here if

• You want a broad, ambiguous platform to own and the autonomy to make calls on it

• You ship fast and learn fast, even when things are unfinished

• You're comfortable working with teammates across time zones

You probably won't if you want tightly scoped tickets, a fully defined process before acting, or a slow and highly predictable environment.

Why join Stream?

We're a Series B company with global presence and a team of around 145 people from more than 35 countries. We're backed by Felicis Ventures, GGV Capital, 01 Advisors, Techstars, and Arthur Ventures, with angels including Dick Costolo (ex-CEO of Twitter), Olivier Pomel (CEO of Datadog), Tom Preston-Werner (co-founder of GitHub), and Nicolas Dessaigne (co-founder of Algolia).

We'll be straight with you: a startup is more demanding than a large company. There's no fixed playbook, you'll own things end to end, and you'll sometimes pick up work outside your title. That's also what makes it a fast place to grow. If you want real ownership and high scale more than structure and a set career ladder, you'll feel at home here.

What 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.