Senior Data Engineer (Remote)

The role

You will build and own the data foundation to power analytics, reporting, and decision-making. This involves designing dimensional models, owning pipelines, and establishing data practice standards.

What you will do

• Design and build a conformed, Kimball-style dimensional model
• Own ingestion end to end, including capturing change over time
• Consolidate transformation logic into a single governed, tested layer
• Implement and manage the data warehouse and transformation layer
• 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
• Monitor and optimize performance and cost efficiency across pipelines, storage, and warehouse queries
• Design and maintain the dimensional model including dimensions, facts, and bridge tables

Required qualifications

• 5+ years of experience in data engineering, analytics engineering, or a closely related role
• Experience building and owning a dimensional model in production
• Strong proficiency in SQL
• Experience with document-based operational databases (e.g., MongoDB) and analytical data warehouses (e.g., BigQuery, Snowflake, Redshift, or similar)
• Experience building fact and dimension tables using star schema principles
• Hands-on experience with modern transformation and modeling frameworks (e.g., dbt, Dataform, or similar)
• Built and maintained reliable ETL/ELT pipelines
• Worked with orchestration tooling (e.g., Airflow, Dagster, Prefect, or similar)
• Experience with data ingestion or event streaming platforms (e.g., RudderStack, Segment, Pub/Sub, or similar)
• Solid understanding of data modeling best practices
• Track record of inheriting and operating systems you didn't build
• Ability to explain technical tradeoffs clearly to non-engineers

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

About the company

zencastr is a company with a data team with direct analytics experience and technical teams that have built and run existing systems.