Software Engineer II - Enterprise Data Warehouse (Remote)
The Home Depot · Atlanta, GA
- On site
- Full-time
- $100,000 / year
- Atlanta, GA
Job highlights
- Build and maintain enterprise data pipelines.
- Develop curated datasets and semantic layer logic.
- Ensure reliability of data products.
- Collaborate on secure, scalable software solutions.
- Focus on data integrity and performance.
About the role
Software Engineer II - Enterprise Data Warehouse (Remote)
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 experiments 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 reports 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
Key skills/competency
- Software Engineer II - Enterprise Data Warehouse
- Data Pipelines
- Data Structures
- Enterprise Analytics
- Curated Datasets
- Semantic Layer
- Data Integrity
- Performance
- Scalability
- SQL
- Python
Skills & topics
- Software Engineer
- Data Warehouse
- Data Engineering
- SQL
- Python
- Data Modeling
- BigQuery
- Data Pipelines
- Cloud Data Warehouse
- ETL
- Remote
How to get hired
- Tailor your resume: Highlight SQL, Python, data modeling, and cloud data warehouse experience for Software Engineer II - Enterprise Data Warehouse roles.
- Showcase relevant projects: Detail experience with data pipelines, curated datasets, and data validation in your application.
- Prepare for technical interviews: Be ready to discuss data transformation, automation, and cloud data warehouse concepts.
- Emphasize collaboration: Discuss your experience working with cross-functional teams in agile environments.
- Demonstrate problem-solving: Share examples of how you've addressed data pipeline failures and ensured data integrity.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the core technical skills required for the Software Engineer II - Enterprise Data Warehouse role at The Home Depot?
- The role requires proficiency in SQL and Python for complex data transformation and automation. Experience with Cloud Data Warehouses (BigQuery preferred), Data Modeling, and Orchestration/CI/CD tools like Airflow, Jenkins, and Git is highly preferred for this Software Engineer II position at The Home Depot.
- What is the typical career path for a Software Engineer II at The Home Depot?
- As a Software Engineer II - Enterprise Data Warehouse, you can expect to grow into more senior engineering roles. The Home Depot encourages continuous learning and provides opportunities to work on challenging projects within the EDW ecosystem, leading to roles like Senior Software Engineer or specialized data architect positions.
- How does The Home Depot approach data integrity and quality in their EDW?
- The Home Depot emphasizes data integrity, performance, and scalability. For the Software Engineer II - Enterprise Data Warehouse role, this means rigorous data validation, unit testing, root cause analysis for pipeline failures, and proactive monitoring through dashboards and alerting systems.
- Is this Software Engineer II - Enterprise Data Warehouse role a remote position?
- Yes, this Software Engineer II - Enterprise Data Warehouse position is a remote role, offering flexibility while still requiring collaboration within the product team.
- What kind of projects will a Software Engineer II work on at The Home Depot?
- As a Software Engineer II - Enterprise Data Warehouse, you will focus on building and maintaining data pipelines, developing curated datasets, managing semantic layer logic, and ensuring the reliability of data products that power enterprise analytics.
Similar roles
Open positions we recommend based on this role.