Senior Data Engineer

Compensation

$130,000-$160,000 per year

Location

United States – Remote or Omaha, NE - Hybrid

The job

As a Senior Data Engineer at Buildertrend, you'll lead the migration of our data platform onto a modern Databricks lakehouse, replacing today's patchwork of legacy systems with a single, reliable source of truth. You'll design the pipelines that bring in data from tools like Salesforce, SQL Server and Gong, turning it into curated, trustworthy datasets that teams across the business, and the AI tools built on top of them, can rely on without double-checking the numbers. Your work directly cuts down on the manual firefighting that eats into engineering time today, and sets the technical standards other engineers will build on for years. By the end of your first year, you'll have carried a major legacy system migration to completion and be stepping into a mentorship or leadership role on the team.

What you will do

• Design, build and maintain Buildertrend's Databricks lakehouse using a medallion (bronze, silver, gold) architecture in dbt, and set the layer standards, naming conventions and build rules other engineers follow.
• Build ELT pipelines with Databricks, dbt and Fivetran that bring in data from SQL Server, Salesforce, MongoDB, Gong, OpenTelemetry and vendors like Zonda, turning it into curated, analytics- and AI-ready datasets.
• Lead the exit from legacy systems like BigQuery, Data Fusion and Cloud Fusion by refactoring pipelines rather than copying them over as-is, untangling circular dependencies, and repointing tools like Tableau to the new platform with clear owners and deadlines.
• Strengthen reliability by improving SQL Server log-ship replication and Fivetran ingestion, and by building automation like auto-recovery, full-refresh jobs and watchdog orchestration that cuts down on manual fixes and outages.
• Build data quality checks, freshness monitoring and quality metrics using dbt tests, Unity Catalog and