Staff Software Engineer - Enterprise Data Warehouse (Remote)

Home Depot; Georgia; Hybrid; USD 120,000 - 190,000; Full time

Job summary

The Home Depot is seeking a Staff Data Engineer to lead the design, build, and operation of enterprise-scale data platforms within the EDW. You will shape architectural standards, drive platform modernization, and mentor engineers while staying hands-on in backend data engineering.

This role emphasizes scalability, performance, and cost efficiency across the EDW ecosystem, with collaboration across teams to deliver reliable data products for analytics consumers.

Qualifications

• 5+ years of 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.

Responsibilities

• 50% Delivery and Execution - Develops, tests, deploys, and maintains software with value delivery in mind; ensures robust test suites and rapid production deployment.
• 10% Learns and Grows - Actively pursues formal and informal development opportunities; learns from experiments tackling new problems.
• 20% Plans and Aligns - Proposes better ways to enable organizational success; communicates clearly to diverse audiences; aligns with Product Team to prep developer-ready user stories; collaborates in agile processes.
• 20% Supports and Enables - Answers product/engineering questions; mentors junior engineers; identifies gaps and suggests team improvements.

Skills

Advanced SQL

Python

BigQuery

Data Modeling

Semantic Layers

CI/CD

Airflow

Jenkins

Performance Tuning

Cross-team Collaboration

Education

Bachelor's degree in a related field

Tools

Jenkins

Airflow

AtScale

Job description

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

• 50% Delivery and Execution - Develops, tests, deploys, and maintains software, with a clear understanding of the value the software is to provide; Takes a broad view when approaching issues; using a global lens; Consistently achieves results, even under tough circumstances; Develops test suites (functional, destructive, etc) to enable success, rapid deployment of code to production; Takes on new opportunities and tough challenges with a sense of urgency, high energy and enthusiasm; Consistently achieves results, even under tough circumstances
• 10% Learns and Grows - Actively seeks ways to grow and be challenged using both formal and informal development channels; Learns through successful and failed experiment when tackling new problems
• 20% Plans and Aligns - Creates new and better ways for the organization to be successful; Delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences; Works the Product Team to ensure user stories are developer ready, easy to understand and testable; Collaborates with other team members in agile processes; Relates openly and comfortably with diverse groups of people; Adapts approach and demeanor in real time to match the shifting demands of different situations
• 20% Supports and Enables - Fields questions from product and engineering teams; Helps grow junior engineers by providing guidance on modern software development frameworks, and leading technical discussions; Notes gaps on the team and provides suggestions for changes to make the team more productive

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

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

- $120,000.00 - $190,000.00