Staff Software Engineer, Enterprise Data Warehouse (Remote)

The Home Depot; Atlanta (GA); Remote; USD 140,000 - 190,000; Full time

Job summary

The Home Depot is seeking a Staff Data Engineer to design, build, and operate enterprise-scale data platforms within the Enterprise Data Warehouse. You will mentor engineers, define standards, and drive modernization while remaining hands-on in backend data engineering.

Ideal candidates have 3+ years in backend data engineering, strong SQL and Python, and experience with BigQuery and semantic layers. This role emphasizes scalability, cost efficiency, and analytical correctness.

Qualifications

• 3+ years in backend data engineering or analytics platform engineering.
• Strong SQL expertise and Python knowledge.
• Experience designing enterprise-grade data models and curated datasets.
• Experience with semantic layers and data modeling across domains.

Responsibilities

• Designs, builds, and operates enterprise-scale data platforms within the EDW.
• Mentors engineers and guides architectural decisions; stays hands-on.
• Drives platform modernization, performance, and cost efficiency across the EDW.
• Collaborates with product teams to ensure testable, scalable solutions.

Skills

Backend data engineering

Analytics platform engineering

Cloud data warehouses

SQL

Python

Data modeling

Semantic layers

CI/CD

Airflow

Jenkins

Performance tuning

Cost optimization

High availability

Education

Bachelor's degree

Tools

BigQuery

AtScale

Jenkins

Airflow

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+ yearsof experience in backend data engineering or analytics platform engineering
• Strong hands‑on experience with cloud data warehouses(BigQuery strongly preferred)
• Advanced SQLexpertise 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 modelingacross multiple domains or products
• Experience with CI/CD and orchestration frameworks, including Jenkins and Airflow
• Strong understanding of performance tuning and cost optimization techniquesin 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 EffectivelyDrives Results
• Interpersonal Savvy