← All roles

Lead Data Engineer

Stream· Sales
Apply on company site
Boulder, CO (US)$150k - $180kFull-timePosted 1mo ago

About the role

Lead Data Engineer responsible for owning Stream's data platform end-to-end, including ingestion, transformation, and platform infrastructure, with a focus on Revenue Operations data, migration to GCP, and enabling business insights.

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. 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 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 analysts and engineers who contribute to the platform.

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

Skills

Required:SQLPythonBigQueryELT toolsOrchestration/CI/CD

Benefits

  • 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
Last updated Sep 17, 2026. Interested? Apply on the company site.

About Stream

Scalable Feeds, Chat, & Video - Powerful APIs and Components by Stream

Scalable and fast APIs for building social networks and apps. Activity feeds, chat, and video solutions powered by a global Edge Network.

Company profileWebsite

More open roles at Stream