Staff Software Engineer- Enterprise Data Warehouse (Remote)
About The Position
With a career at The Home Depot, you can be yourself and also be part of something bigger. Position Purpose: The Staff Data Engineer is a senior technical leader responsible for designing, building, and operating enterprise-scale data platforms and data products within the Enterprise Data Warehouse (EDW). This includes foundational data domains, semantic layers and downstream analytics consumers. This engineer will help define architectural standards, drive platform modernization, and mentor other engineers while remaining hands-on in complex backend data engineering efforts. The role emphasizes scalability, performance, cost efficiency, and analytical correctness across the EDW ecosystem.
Requirements
- Must be eighteen years of age or older.
- Must be legally permitted to work in the United States.
- The knowledge, skills and abilities typically acquired through the completion of a bachelor's degree program or equivalent degree in a field of study related to the job.
- 3 Minimum Years of Work Experience
Nice To Haves
- 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 universal or shared semantic modeling across multiple domains or products
- 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
Responsibilities
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
