Staff Software Engineer - Enterprise Data Warehouse (Remote)

The Home Depot is a leading home improvement retailer, and they are seeking a Staff Software Engineer for their Enterprise Data Warehouse team. This role involves designing, building, and operating enterprise-scale data platforms while mentoring junior engineers and ensuring data accuracy and performance across the EDW ecosystem.

Responsibilities:

• 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
• 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
• 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
• 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

Requirements:

• Must be eighteen years of age or older
• Must be legally permitted to work in the United States
• 3 years of work experience
• 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
• 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