Data Engineer
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
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!