Staff Software Engineer- Enterprise Data Warehouse (Remote)
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. Key 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
- Direct Manager/Direct Reports:
- This position typically reports to Software Engineer Manager or Sr. Manager
- This position typically has 0 Direct Reports Travel Requirements:
- No travel required. Physical Requirements:
- Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles. Working Conditions:
- Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable. Minimum Qualifications:
- Must be eighteen years of age or older.
- Must be legally permitted to work in the United States. Preferred Qualifications:
- 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 Minimum Education:
- 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. Preferred Education:
- No additional education Minimum Years of Work Experience:
- 3 Preferred Years of Work Experience:
- No additional years of experience Minimum Leadership Experience:
- None Preferred Leadership Experience:
- None Certifications:
- None Competencies:
- Global Perspective
- Manages Ambiguity
- Nimble Learning
- Self-Development
- Collaborates
- Cultivates Innovation
- Situational Adaptability
- Communicates Effectively
- Drives Results
- Interpersonal Savvy For California, Colorado, Connecticut, Rhode Island, Nevada, New York City, Ithaca (NY), Westchester County (NY), and Washington residents: The pay range for this position is between $120,000 - $190,000 Apply tot his job
Apply tot his job Apply To this Job