Staff Software Engineer - Enterprise Data Warehouse (Remote)

Job description

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: 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 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.00 - $190,000.00