Senior Data Engineer (Remote)

Zencastr

Where
Remote (San Francisco Office)

Posted 2 months ago· Checked live at Zencastr 2 hours ago

Stale: open 69 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what Zencastr asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Zencastr's own hiring page 2 hours ago.
What is the job?
As our first dedicated Data Engineer, you will build and own the data foundation that powers analytics, reporting, and decision-making across the organization. This is a hands-on role where you'll design the dimensional model, own the pipelines that feed it, and establish the standards our data practice is built on. You won't be starting from zero or working alone.
What does it pay?
The posting doesn't say.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

As our first dedicated Data Engineer, you will build and own the data foundation that powers analytics, reporting, and decision-making across the organization. This is a hands-on role where you'll design the dimensional model, own the pipelines that feed it, and establish the standards our data practice is built on.

You won't be starting from zero or working alone.

What You’ll Do

  • Design and build a conformed, Kimball-style dimensional model across our operational, behavioral, and transactional data
  • Own ingestion end to end, including capturing change over time from sources that don't preserve history natively
  • Consolidate transformation logic that currently lives in more than one place into a single governed, tested layer
  • Implement and manage our data warehouse and transformation layer, taking ownership of the pipelines that move data from our operational systems into it
  • Establish foundational best practices for data modeling, documentation, testing, and governance
  • Improve data reliability, quality, and accessibility across systems
  • Collaborate with analysts and business stakeholders to support evolving data needs
  • Encode business metric definitions once, so that reporting stops drifting across teams
  • Monitor and optimize performance and cost efficiency across pipelines, storage, and warehouse queries

Nice to have

  • Change data capture patterns from operational databases
  • Subscription billing data — proration, refunds, failed payments, trials
  • Experience with distributed processing frameworks (e.g., Spark, Beam, Dataflow)
  • Experience as a first or early data hire

Key responsibilities

  • Design, build, and maintain reliable data pipelines that transform operational data into structured, analytics-ready datasets
  • Design and maintain the dimensional model — dimensions, facts, and bridge tables with clearly defined grain
  • Develop and maintain scalable data models and data marts to support reporting and business analysis
  • Manage and optimize data ingestion and event workflows to ensure consistent, high-quality upstream data flows
  • Implement and manage transformation processes that structure raw data for analytics use
  • Implement orchestration, testing, freshness monitoring, and alerting so that data issues are caught before stakeholders encounter them
  • Build and maintain change capture or snapshotting to support historical reporting and slowly-changing dimensions
  • Improve data freshness — moving our core operational data from batch refreshes toward near-real-time availability, and establishing freshness SLAs stakeholders can rely on
  • Ensure strong standards for data quality, validation, and consistency across systems
  • Document models and definitions so analysts and stakeholders can self-serve with confidence
  • Monitor and optimize performance, reliability, and cost efficiency within the analytics environment
  • Partner cross-functionally to translate business requirements into scalable data solutions
  • Proactively improve our data systems so they remain structured, consistent, and scalable as the organization grows

Similar open jobs

Data engineer jobs in San Francisco (87)Remote data engineer jobs (166)Jobs in San Francisco (11750)