Company Name: Builder Prime

Job Details: RemoteFull,Time

Job Url: https://hiring.cafe/viewjob/ltvutptmd40dxpgm

Job Description: Posted 2d agoData Engineer@ Builder PrimeView All JobsWebsiteUnited StatesRemoteFull TimeResponsibilities:Design pipelines, Build queries, Ingest dataRequirements Summary:3+ years production data engineering experience; strong SQL, data pipelines, dbt, Snowflake, CDC, and BI tooling experience.Technical Tools Mentioned:SQL, Python, dbt, Snowflake, CDC, Looker, Tableau, Power BI
THE COMPANYAt Builder Prime, we’re revolutionizing the home improvement industry by doing more than just building software—we're giving hardworking contractors their time and freedom back. Our all-in-one business management solution is the essential platform for companies at their "level-up" moment, seamlessly integrating CRM, estimating, production management, payments, and reporting. By replacing disjointed tools with a unified data and automation foundation, we empower businesses to operate more efficiently, win more jobs, and achieve their growth goals. We look for collaborative and community-oriented team members who bring initiative and curiosity to the challenge of solving problems for our customers.In 2023, Builder Prime raised their Series A financing from Blueprint Equity and additional investors. We recently announced our Series B, also financed by Blueprint Equity.THE ROLEThis is a remote position open to candidates authorized to work in the US without visa sponsorship, who presently reside in the US. There is a preference for candidates in states where we already have Builder Prime employees; California, Colorado, Florida, Georgia, Idaho, Indiana, Nebraska, New York, Ohio, Oregon, Texas, Utah, Virginia, Washington, and Wisconsin. Builder Prime has an office in the greater Denver metro area (Westminster) that the majority of the sales team works out of.We are seeking an experienced Data Engineer to join our team at Builder Prime. This role requires deep technical expertise in SQL, data transformation pipelines, and modern cloud data platforms. You'll work on critical data infrastructure that powers our analytics and business intelligence capabilities, with opportunities to tackle challenging technical problems involving both real-time streaming and batch data architectures.This position offers a unique opportunity to work in a collaborative, remote-friendly environment where data quality and reliability are paramount. You'll be part of a team that values deep technical curiosity, methodical problem-solving, and the ability to balance pragmatic solutions with technical excellence. We're looking for someone who not only has strong technical skills but can also communicate complex concepts effectively and contribute to our modern data stack using cutting-edge tools.This role will report directly to our Staff Data Engineer and will sit on the Engineering team.THE DAY-TO-DAYDesign, develop, and maintain scalable data pipelines and transformationsBuild and optimize complex SQL queries and data modelsImplement and manage real-time and batch data ingestion workflows using CDCOrchestrate end-to-end data pipelines with monitoring and alertingBuild reports and dashboards in BI tools to support business analyticsCollaborate with analytics and engineering teams to deliver reliable data solutionsEnsure data quality, consistency, and reconciliation across the pipelineMonitor and optimize data platform performance and costsEnsure data quality, reliability, and governance standardsTHE MUST-HAVESCore Technical Skills: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.Experience:3+ years of production data engineering experience3+ years working with dbt or similar transformation frameworks3+ years hands-on experience with SnowflakeExperience building CDC pipelines and handling real-time data ingestionDemonstrated ability to build reports and dashboards in BI toolsTrack record of building and maintaining data pipelines at scaleExperience with data quality validation and reconciliationTrack record of optimizing data platform performance and costsTHE NICE-TO-HAVESExperience with data orchestration tools (Airflow, Dagster, Prefect, or similar)AWS services (S3, RDS, DMS, EKS)PostgreSQL administration and replicationKubernetes and containerizationReal-time materialized views and incremental view maintenanceData warehouse optimization for columnar storageExperience with streaming SQL transformationsUnderstanding of eventual consistency and distributed systemsData quality frameworks and testing tools (Great Expectations, Soda, etc.)Understanding of platforms like Kafka, Flink, or similarKnowledge or experience in SaaS and the home improvement industry.Strong understanding of business management CRM software and its application in improving business processes.THE BENEFITSWhy You'll Love Working Here:Exceptional Health Coverage – We cover 95% of medical, dental, and vision premiums for employees (Aetna & Guardian), plus 50% for dependentsStrong 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 communityAnnual 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 insuranceGrow 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 parentsFully Equipped From Day One – Company-provided laptop and all the equipment you need to succeedPLUS…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!Builder Prime is an Equal Opportunity Employer and values diversity at all levels. We also participate in E-Verify to confirm employment eligibility in the U.S.