Software Engineer II - Enterprise Data Warehouse (Remote)

The Home Depot

18h•Remote

About The Position

The Software Engineer II - EDW is responsible for building and maintaining the data pipelines and structures that power The Home Depot's enterprise analytics. Working within the EDW ecosystem, this role involves developing curated datasets, maintaining semantic layer logic, and ensuring the reliability of data products. The engineer will collaborate with senior engineers to implement architectural standards, transforming raw data into actionable insights with a focus on data integrity, performance, and scalability. This is a remote position.

Requirements

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

Responsibilities

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