Senior Data Engineer (Remote)

Zencastr

San Francisco (CA)

Remote

USD 140,000 - 200,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Zencastr is seeking its first dedicated Data Engineer to build the data foundation powering analytics and decision-making. You will design a conformed dimensional model, own ingestion and transformation pipelines, and set governance and quality standards across the data practice.

You will collaborate with engineering and analytics teams, owning end-to-end data flows from ingestion to warehouse, and define scalable data models and reporting structures.

Qualifications

  • 5+ years in data/analytics engineering or related role with production dimensional model ownership.
  • Strong SQL skills across operational and analytical databases.
  • Experience building fact and dimension tables using star schema principles.

Responsibilities

  • Design, build, and maintain conformed dimensional model across datasets.
  • Own end-to-end data ingestion and transformation pipelines.
  • Consolidate and govern transformation logic into a single layer.
  • Manage data warehouse and pipelines; ensure performance and cost efficiency.
  • Establish governance, testing, and documentation standards.

Skills

SQL proficiency
Dimensional modeling
ETL/ELT pipelines
dbt/Dataform
Airflow/Dagster/Prefect
Data ingestion & streaming
Identity resolution
Data quality & governance
Non-engineer communication

Tools

MongoDB
BigQuery
Snowflake
Redshift
dbt
Airflow
Dagster
Prefect

Job description

About the Role

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. You'll join a data team with direct analytics experience, and partner closely with engineering and other technical teams who have built and run what we have today. There's real institutional knowledge here to draw on. What's been missing is someone whose focus is turning it into a single, well‑modelled foundation the whole company can rely on.

You will work cross‑functionally to understand how data is generated and used, and translate those needs into scalable models and structured reporting layers. A central part of the work is identity resolution: building the spine that reliably connects the same entity as it appears across systems that each have their own identifiers and lifecycles.

This role is ideal for someone who enjoys owning data systems end to end — from ingestion and transformation through modelling, governance, and performance — and who wants the autonomy to design a warehouse properly, with colleagues who can help you understand the business behind the data.

What You’ll Do
  • Design and build a conformed, Kimball‑style dimensional model across our operational, behavioural, 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 modelling, 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 optimise performance and cost efficiency across pipelines, storage, and warehouse queries

You're a Good Fit If You
  • Have 5+ years of experience specifically in data engineering, analytics engineering, or a closely related role, including having built and owned a dimensional model in production

  • Have strong proficiency in SQL, with experience across document‑based operational databases (e.g., MongoDB) and analytical data warehouses (e.g., BigQuery, Snowflake, Redshift, or similar)

  • Have experience building fact and dimension tables using star schema principles to support reporting and data marts, with a clear point of view on grain, conformed dimensions, and slowly‑changing dimensions

  • Have hands‑on experience with modern transformation and modelling frameworks (e.g., dbt, Dataform, or similar), including managing transformation layers within a warehouse environment with version control, testing, and CI

  • Have built and maintained reliable ETL/ELT pipelines that transform raw application data into structured, analytics‑ready datasets

  • Have worked with orchestration tooling (e.g., Airflow, Dagster, Prefect, or similar) and think in terms of dependencies, retries, and backfills

  • Have experience with data ingestion or event streaming platforms (e.g., RudderStack, Segment, Pub/Sub, or similar) and ensuring consistent, reliable upstream data flows, including identity stitching across web and mobile

  • Have a solid understanding of data modelling best practices, including schema design, dimensional modelling, and performance considerations

  • Have a track record of inheriting and operating systems you didn't build

  • Have a strong focus on data quality, validation, and governance, with the ability to identify and resolve inconsistencies

  • Have an understanding of performance optimisation across pipelines, storage, and warehouse queries

  • Can explain technical trade‑offs clearly to non‑engineers

  • Are comfortable operating in a growing environment where you both execute technically and help shape our data architecture standards

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 optimise 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 optimise 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 organisation grows

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Zoominfo • United States

Remote
USD 110,000 - 170,000
Remote work
Senior Data Engineer
Senior Data Engineer

MoldStud • United States

Remote
USD 120,000 - 180,000
Senior Analytics Engineer
Senior Analytics Engineer

Agoro • United States

Remote
USD 120,000 - 190,000
Data Engineer
Data Engineer

Compunnel Inc. • Columbus (OH)

On-site
USD 85,000 - 115,000
Data Engineer -
Data Engineer -

thehivecareers.co • Oregon (WI)

On-site
USD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

RelMap Consulting • United States

Remote
USD 96,000 - 110,000
Data Engineer
Data Engineer

HealthPartners • BLOOMINGTON (MN)

Hybrid
USD 88,000 - 132,000
Data Engineer
Data Engineer

NuView Analytics • United States

Remote
USD 80,000 - 120,000
Bi-Lingual Senior Data Engineer
Bi-Lingual Senior Data Engineer

GTN Technical Staffing • United States

On-site
USD 100,000 - 130,000
Data Engineer
Data Engineer

Trisearch • Denver (CO)

Hybrid
USD 160,000 - 190,000
Health, dental, vision coverage
Hybrid/Remote work options
401(k) with company match
+5