Software Engineer II - 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 Software Engineer II - EDW is responsible for building and maintaining the data pipelines and structures that power our enterprise analytics. Working within the EDW ecosystem, you will develop curated datasets, maintain semantic layer logic, and ensure the reliability of data products. You will work alongside senior engineers to implement architectural standards, helping to transform raw data into actionable insights while focusing on data integrity, performance, and scalability. Key Responsibilities: 60% Delivery and Execution - Collaborates and pairs with other product team members (UX, engineering, and product management) to create secure, reliable, scalable software solutions; Documents, reviews and ensures that all quality and change control standards are met; Works with Product Team to ensure user stories that are developer-ready, easy to understand, and testable; Writes custom code or scripts to automate infrastructure, monitoring services, and test cases; Writes custom code or scripts to do destructive testing to ensure adequate resiliency in production; Program configuration/modification and setup activities on large projects using HD approved methodology; Configures commercial off the shelf solutions to align with evolving business needs Creates meaningful dashboards, logging, alerting, and responses to ensure that issues are captured and addressed proactively 20% Learning - 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 - Collaborates with other team members in agile processes; Assists in creating new and better ways for the team to be successful; Relates openly and comfortably with diverse groups of people; Builds partnerships and works collaboratively with others to meet shared objectives Direct Manager/Direct Reports: This position typically repots to Software Engineer Manager or Sr. Manager This position 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: 1–3 years of experience in data engineering or a backend-heavy technical role. Proficiency in SQL & Python for complex data transformation and automation. Hands-on experience with Cloud Data Warehouses (BigQuery preferred). Experience in Data Modeling, specifically building curated or ADS (Analytical Data Store) layers. Exposure to Orchestration & CI/CD tools such as Airflow, Jenkins, and Git. Experience in Data Validation, including unit testing and root cause analysis for pipeline failures. 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: 2 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 $90,000.00 - $170,000.00 Apply To This Job