Senior Data Engineer (Remote) Job at Zencastr, San Francisco, CA

  • Zencastr
  • San Francisco, CA

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-modeled 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 modeling, 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, 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 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 modeling 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.

Job Tags

Full time

Similar Jobs

Vigilant Cyber Systems, Inc

Junior Software Engineer - DevOps & Virtualization (Remote) Job at Vigilant Cyber Systems, Inc

A cybersecurity solutions firm is seeking a Jr Software Engineer with an emphasis on DevOps to develop and manage virtualized environments. The role involves using tools like Packer and Ansible to automate configurations and build testing infrastructures. Candidates should... 

Madison Medical Affiliates

Medical Assistant - Dermatology Job at Madison Medical Affiliates

 ...Medical Assistant Job Summary: A Medical Assistant provides quality patient care by assisting the physician with clinic specific...  ...Supervisor/Regional Director of Clinic Operations, is within Dermatology and is located in Mequon, WI with once a week travel to West... 

Optum

RN Healthcare Coach Live Oak Clinic Dallas Texas Job at Optum

WellMed, part of the Optum family of businesses, is seeking a RN to join our team in Dallas, TX. Optum is a clinician-led care organization that is changing the way clinicians work and live. As a member of the Optum Care Delivery team, you'll be an integral part of...

GrabJobs

Remote Social Media Manager Job at GrabJobs

 ...Office Location: Remote Offices, Long Island, and New York CityRequirements / Essential DutiesAbility to work Social Media networks, such as but not limited to Twitter, FaceBook, Instagram.Previous account management expierence recommended but not manditory.Must be... 

Brown University Health

Marketing Communications Specialist Job at Brown University Health

 ...its affiliates/services, using such information to add value to consultation and planning for clients and to guide the accurate targeting...  ...as website analytics (Google Analytics and Google Data Studio), SEO, social media and email marketing.EXPERIENCE:Minimum two to four...