Builder Prime
See why hundreds of home improvement businesses trust Builder Prime’s all-in-one platform to power their growth.
Data Engineer
Location
California + 12 moreAll locations: California, Colorado, Florida, Idaho, Nebraska, New York, Ohio, Oregon, Texas, Utah, Virginia, Washington, Wisconsin
Posted
63 days ago
Salary
Not specified
3 yrs expEnglishAWSPandasPythonSQLTableau
Job Description
• 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
Job Requirements
- 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
- 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.
Benefits
- Exceptional Health Coverage – We cover 95% of medical, dental, and vision premiums for employees (Aetna & Guardian), plus 50% for dependents
- Strong Retirement Match – 401k with up to 4% company match that's immediately vested (no waiting period!)
- Generous Time Off – 15 PTO days, 48 hours sick time, 9 paid holidays, plus a paid volunteer day to give back to your community
- Annual International Retreat – All-expenses-paid company trip to connect with teammates in amazing destinations (2026: Cancun, Mexico!)
- Life Happens Coverage – Company-paid life insurance ($50k), AD&D, and short-term disability, plus optional accident, hospital, critical illness, and additional life insurance
- Grow With Us – $300 annual professional development stipend, plus an incredible sabbatical at 5 years (2 extra weeks PTO + $1,000 travel bonus)
- Comprehensive Parental Leave – 10 weeks paid parental leave for birthing parents, 4 weeks for non-birthing parents
- Fully Equipped From Day One – Company-provided laptop and all the equipment you need to succeed
- 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!
