Senior Data Engineer - Data Platform at Buildertrend

Job description

Compensation: $130,000-$160,000 per year Location: United States – Remote or Omaha, NE - Hybrid The job: As a Senior Data Engineer-Data Platform at Buildertrend, you ll lead the migration of our data platform onto a modern Databricks lakehouse built on dbt, 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. 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 Fivetran metadata, so stakeholders can trust the numbers without double-checking them. Design access controls for large datasets, including permission models, per-team clusters, service principals and scoped access for AI tools, and handle privacy requests through tools like DataGrail to meet CCPA requirements. Set up data contracts with product engineering so upstream schema changes don t silently break the warehouse, and write documentation (data dictionary, ERDs, spec docs, column notes) clear enough for people and AI tools to use. Build and improve the curated data products that let stakeholders and customers turn raw data into decisions. Partner with data science, machine learning and AI teams to build and curate the datasets their models and experiments depend on, alongside the broader data products that help stakeholders and customers turn raw data into decisions. Partner with engineers, analysts, business leaders and other stakeholders to prioritize work, manage dependencies and deliver meaningful platform improvements. Mentor other engineers, contribute to architectural decisions, evaluate emerging technologies and grow toward a technical leadership role while using AI thoughtfully to improve productivity and engineering outcomes. Who you are and what you need: Bachelor s degree in computer science, software engineering or a related field is required. 5 years of experience in data engineering, data science or data analytics. Previous experience at a B2B SaaS company is preferred. Hands-on, production-level experience with Databricks, including building and orchestrating pipelines, managing jobs and clusters, and using Unity Catalog for governance is required. Hands-on, production-level experience with dbt, including building and maintaining models, tests and macros in a real production environment is required. Proven experience leading a data platform migration, such as moving off a legacy warehouse onto a modern lakehouse, from planning through delivery, including setting deadlines and owning the outcome. Experience partnering with data science, machine learning, or AI teams to build and curate datasets to support model development and experimentation. Strong proficiency in SQL, Microsoft SQL Server, Python and working with APIs and large, complex datasets. BigQuery or FiveTran experience is a plus! Deep understanding of data modeling, ETL and ELT pipelines, medallion architecture and building analytics and machine learning-ready datasets. Experience writing data tests, setting up freshness and alerting monitors, and building access controls or governance policies in a live production environment (not just in a sandbox or one-off project). Strong communication skills, with the ability to explain technical tradeoffs to both engineers and non-technical stakeholders, especially during a system migration where people need clear, direct answers about what s changing and when. Demonstrated experience mentoring engineers, reviewing technical work and influencing engineering standards. We are giving you: Exceptional health packages, including medical, dental, and vision coverage, plus life insurance and short- and long-term disability benefits A 401(k) plan with Buildertrend matching contributions to help you plan for the future Generous paid time off, 11 paid holidays, plus personal days to make sure you have time to recharge Parental leave and paid sabbaticals to support you during life’s big moments Volunteer time off – because giving back matters Wellness program and onsite fitness center to keep you feeling your best Opportunities for hybrid or remote work to give you the flexibility you need Technology reimbursement to help cover costs for the tech you need to do your job from home Free daily lunches when you re at our HQ office, plus monthly events to connect with your team Who we are: Great builders don’t just manage projects – they run successful businesses. That’s where Buildertrend comes in. As the leading residential construction management platform, we give contractors the power to control their financials, schedules, team workflows and client relationships – all in one system. No more juggling disconnected tools or guessing on profitability. With nearly two decades of industry expertise, Buildertrend helps builders work smarter, scale faster and stay ahead of the competition. If you want to learn more about us, check out: buildertrend.com Working at Buildertrend: At Buildertrend, we fully recognize that we all work so we can live better lives—we appreciate and respect that this is a job and not your whole life. What makes Buildertrend so special is a commitment to ensuring you can have the best job, work with the best people, and live your best life outside of work. Our goal is to create a culture where everyone can make an impact on our customers, communities, and each other. In short: We want you to be who you are, love what you do, and build your best life. Buildertrend Solutions, Inc. is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee based on race, including natural or protective hairstyle, color, religion, creed, national origin or ancestry, ethnicity, sex (including gender, pregnancy and pregnancy-related conditions, childbirth, breastfeeding, sexual orientation, gender identity, gender expression, sexual orientation, reproductive decision-making), age, physical or mental disability, veteran or military status, genetic information, citizenship, marital status, or any other legally recognized protected basis under federal, state, or local law. The information collected by this application is solely to determine suitability for employment, verify identity, and maintain employment statistics on applicants. Applicants with disabilities may be entitled to reasonable accommodation under the Americans with Disabilities Act and certain state or local laws. A “reasonable accommodation” is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Buildertrend Solutions, Inc. Please inform the company s personnel representative if you need assistance completing this application or to otherwise participate in the application process. To see the complete list of Essential Job Functions, visit buildertrend.com

Requirements

Must-haves

Compensation: $130,000-$160,000 per year
Location: United States – Remote or Omaha, NE - Hybrid
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.
Build data quality checks, freshness monitoring and quality metrics using dbt tests, Unity Catalog and Fivetran metadata, so stakeholders can trust the numbers without double-checking them.
Build and improve the curated data products that let stakeholders and customers turn raw data into decisions.
Partner with engineers, analysts, business leaders and other stakeholders to prioritize work, manage dependencies and deliver meaningful platform improvements.
Mentor other engineers, contribute to architectural decisions, evaluate emerging technologies and grow toward a technical leadership role while using AI thoughtfully to improve productivity and engineering outcomes.
Bachelor s degree in computer science, software engineering or a related field is required.
5 years of experience in data engineering, data science or data analytics.
Hands-on, production-level experience with Databricks, including building and orchestrating pipelines, managing jobs and clusters, and using Unity Catalog for governance is required.
Hands-on, production-level experience with dbt, including building and maintaining models, tests and macros in a real production environment is required.
Proven experience leading a data platform migration, such as moving off a legacy warehouse onto a modern lakehouse, from planning through delivery, including setting deadlines and owning the outcome.
Experience partnering with data science, machine learning, or AI teams to build and curate datasets to support model development and experimentation.
Deep understanding of data modeling, ETL and ELT pipelines, medallion architecture and building analytics and machine learning-ready datasets.
Experience writing data tests, setting up freshness and alerting monitors, and building access controls or governance policies in a live production environment (not just in a sandbox or one-off project).
Demonstrated experience mentoring engineers, reviewing technical work and influencing engineering standards.
Volunteer time off – because giving back matters
Wellness program and onsite fitness center to keep you feeling your best
Opportunities for hybrid or remote work to give you the flexibility you need
Technology reimbursement to help cover costs for the tech you need to do your job from home
Free daily lunches when you re at our HQ office, plus monthly events to connect with your team

Nice-to-haves

Previous experience at a B2B SaaS company is preferred.
Strong proficiency in SQL, Microsoft SQL Server, Python and working with APIs and large, complex datasets. BigQuery or FiveTran experience is a plus!

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaimachine learningpython

Platform: workday
Effort: long

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Parental Leave

Wellness