Builder Prime is hiring a Data Engineer

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 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

Requirements

• 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

Nice to Have

• Experience with data orchestration tools (Airflow, Dagster, Prefect, or similar)
• AWS services (S3, RDS, DMS, EKS)
• PostgreSQL administration and replication
• 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.

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 – 20 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 (This year we went to Cancun, Mexico. Join us for our next retreat in Spring 2027)
• 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!

Work Arrangement

Hybrid

Additional Information

• This is a remote position open to candidates authorized to work in the US without visa sponsorship, who presently reside in the US.
• Builder Prime has an office in the greater Denver metro area (Westminster) that the majority of the sales team works out of.
• This position will pay a base salary of $125,000-$145,000 depending on experience.
• 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.