The Home Depot

Staff Software Engineer – Enterprise Data Warehouse

The Home Depot

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $120,000 - $190,000 per year

Job Level

Lead

Tech Stack

AirflowBigQueryCloudGoogle Cloud PlatformJenkinsPythonSQL

About the role

  • Design, build, and support large-scale backend data pipelines on cloud data platforms (GCP/BigQuery)
  • Lead development and evolution of semantic layers, including universal / reusable semantic models that support multiple business domains and analytics tools
  • Design and maintain Analytical Data Store (ADS) data structures optimized for analytics, reporting, and advanced modeling.
  • Partner with multiple EDW product teams to ensure consistent data modeling, metric definitions, and access patterns
  • Drive platform reliability, scalability, and operational excellence across data products
  • Lead query performance tuning and cost optimization efforts (slot usage, partitioning, clustering, aggregates, workload management)
  • Support and modernize data orchestration frameworks
  • Implement and enforce data quality, validation, and monitoring frameworks
  • Perform deep root-cause analysis of data issues, pipeline failures, and performance regressions
  • Contribute to technical roadmaps, refactoring strategies, and platform modernization initiatives
  • Mentor and grow other engineers through design reviews, code reviews, and technical guidance
  • Create and maintain architecture diagrams, standards, and technical documentation

Requirements

  • 5+ years of experience in backend data engineering or analytics platform engineering
  • Strong hands-on experience with cloud data warehouses (BigQuery strongly preferred)
  • Advanced SQL expertise and strong working knowledge of Python
  • Proven experience designing enterprise-grade data models, including curated/ADS datasets
  • Experience building and supporting semantic layers (AtScale preferred, but not required)
  • Experience with CI/CD and orchestration frameworks, including Jenkins and Airflow
  • Strong understanding of performance tuning and cost optimization techniques in large data environments
  • Experience designing systems for high availability, resilience, and scalability
  • Ability to work across teams and influence architectural decisions without direct authority.
Benefits
  • Health insurance
  • 401(k) matching
  • Flexible work arrangements
  • Paid time off
  • Professional development opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
backend data engineeringanalytics platform engineeringcloud data warehousesSQLPythondata modelingsemantic layersperformance tuningcost optimizationdata orchestration
Soft skills
leadershipmentoringcollaborationinfluencecommunication