Data Engineer

Builder PrimeUnited States - Hybrid$125k – $145k+ Equity1mo ago

In Office Mid NA Cloud Computing Data Analytics Data Engineer Data Quality Governance Python Pandas Polars

Upload My Resume

Drop here or click to browse · PDF, DOCX, TXT

Apply in One Click

Requirements

This role will report directly to our Staff Data Engineer and will sit on the Engineering team.
Design, develop, and maintain scalable data pipelines and transformations
Build and optimize complex SQL queries and data models
Implement and manage real-time and batch data ingestion workflows using CDC
Orchestrate end-to-end data pipelines with monitoring and alerting
Build reports and dashboards in BI tools to support business analytics
Collaborate with analytics and engineering teams to deliver reliable data solutions
Ensure data quality, consistency, and reconciliation across the pipeline
Monitor and optimize data platform performance and costs
Ensure data quality, reliability, and governance standards
SQL Proficiency (Expert): Advanced query optimization, performance tuning, and deep understanding of database internals, complex analytical queries (window functions, CTEs), query plan analysis, and index optimization.
Database Fundamentals (Strong): Expertise in join types (sort-merge, hash, nested loop), index vs. sequential scan tradeoffs, query optimization, materialized views, incremental computation, transaction isolation, and concurrency control.
Python (Proficient): Writing scripts for data processing/transformation, using data libraries (pandas, polars), API integrations, automation, and code quality/testing.
Change Data Capture (CDC) (Strong): Experience with CDC tools (Debezium, AWS DMS, etc.), log-based replication, handling schema evolution, understanding at-least-once/exactly-once semantics, idempotency, and backfilling historical data.
dbt (3+ years): Building and scaling dbt projects, semantic layer/dimensional modeling, incremental models/materialization, testing, documentation, CI/CD for analytics, and package management.
Snowflake (3+ years): Expertise in S3 integration/external stages, Snowpipe (continuous and streaming), warehouse sizing/cost optimization, serverless features/task orchestration, data sharing, performance monitoring, governance (resource monitors), data lifecycle management, and understanding micro-partitions/clustering.
Core Concepts (Foundational): Understanding event time vs. processing time, watermarks/late data handling, backfilling strategies, stream-to-stream joins, and windowing operations (tumbling, sliding, session).
BI Tool Experience (Required): Building reports, dashboards, and visualizations in modern BI platforms (Looker, Tableau, Power BI, Metabase, etc.). Translating business needs into data models/metrics, optimizing data models for performance, and collaborating with stakeholders.
Analytics Partnership: Cross-functional collaboration with analytics/business teams, data model documentation (data dictionaries), supporting ad-hoc analysis, and balancing flexibility with governance.
3+ years of production data engineering experience
3+ years working with dbt or similar transformation frameworks
3+ years hands-on experience with Snowflake
Experience building CDC pipelines and handling real-time data ingestion
Demonstrated ability to build reports and dashboards in BI tools
Track record of building and maintaining data pipelines at scale
Experience with data quality validation and reconciliation
Track record of optimizing data platform performance and costs
THE NICE-TO-HAVES
Experience with data orchestration tools (Airflow, Dagster, Prefect, or similar)
AWS services (S3, RDS, DMS, EKS)
Kubernetes and containerization
Real-time materialized views and incremental view maintenance
Data warehouse optimization for columnar storage
Experience with streaming SQL transformations
Understanding of eventual consistency and distributed systems
Data quality frameworks and testing tools (Great Expectations, Soda, etc.)
Understanding of platforms like Kafka, Flink, or similar
Knowledge or experience in SaaS and the home improvement industry.
Strong understanding of business management CRM software and its application in improving business processes.

Responsibilities

Design, develop, and maintain scalable data pipelines and transformations.
Build and optimize complex SQL queries and data models.
Implement and manage real-time and batch data ingestion workflows using Change Data Capture (CDC).
Orchestrate end-to-end data pipelines with monitoring and alerting capabilities.
Develop reports and dashboards in Business Intelligence tools to support business analytics needs.
Collaborate with both analytics and engineering teams to deliver reliable, high-quality data solutions that meet the company's requirements for accuracy and timeliness.
Ensure data quality, consistency, and reconciliation across all parts of the pipeline.
Monitor and optimize performance and costs associated with cloud data platforms used by Builder Prime.

Benefits

Why You'll Love Working Here:
Exceptional Health Coverage – We cover 95% of medical, dental, and vision premiums for employees (Aetna & Guardian), plus 50% for dependents
Exceptional Health Coverage
Strong Retirement Match – 401k with up to 4% company match that's immediately vested (no waiting period!)
Strong Retirement Match
Generous Time Off – 15 PTO days, 48 hours sick time, 9 paid holidays, plus a paid volunteer day to give back to your community
Generous Time Off
Annual International Retreat – All-expenses-paid company trip to connect with teammates in amazing destinations (2026: Cancun, Mexico!)
Annual International Retreat
Life Happens Coverage – Company-paid life insurance ($50k), AD&D, and short-term disability, plus optional accident, hospital, critical illness, and additional life insurance
Life Happens Coverage
Grow With Us – $300 annual professional development stipend, plus an incredible sabbatical at 5 years (2 extra weeks PTO + $1,000 travel bonus)
Grow With Us
Comprehensive Parental Leave – 10 weeks paid parental leave for birthing parents, 4 weeks for non-birthing parents
Comprehensive Parental Leave
Fully Equipped From Day One – Company-provided laptop and all the equipment you need to succeed
Fully Equipped From Day One
PLUS…
Room to Grow: We LOVE to promote from within. Show us your best stuff, and you’ll have ample opportunity to grow and advance.
Flexible Work Arrangements: We are currently a mix of hybrid and fully remote roles across multiple time zones to support work-life balance.
We Hate Red Tape: We never restrict our team’s creativity, so you’ll have the freedom to experiment and test out new ideas. At Builder Prime, “Iterate To Innovate” is a foundational philosophy.
Strong Culture: Through the use of platforms like Bonusly, the Coffee Chat slack app, and other events and initiatives (both virtual and in-person), we strive to make work both a place where you can do the best work of your career AND have fun. There is no reason it can't be both!