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.
