Sr Data Engineer -- Assortment and Space Planning

With a career at The Home Depot, you can be yourself and also be part of something bigger.Position Purpose:Data Engineers within the Assortment and Space Planning Data Science team translate business requirements and build the infrastructure needed to structure and deliver the data that powers self-service analytics and hardened business applications. They acquire datasets that align with business needs and develop pipelines to transform data into useful, actionable information. Additionally, they build, test, and maintain data pipeline architectures, create data validation methods and data quality tooling, and develop, host, and maintain data products to improve reliability and confidence through monitoring, testing, and validation. These associates use modern data engineering techniques to cleanse, organize, and transform data, and to maintain, defend, and update data structures and integrity on an automated basis.The Sr. Data Engineer position creates and establishes design standards and assurance processes for data pipelines and applications to ensure compatibility and operability of data connections, flows, and storage, and reviews internal and external business and product requirements to recommend changes and upgrades to systems and storage. Beyond this technical ownership, the role mentors and coaches less experienced engineers, partners closely with data science, analytics, and application engineering teams to align on pipeline design, and communicates pipeline decisions and data quality tradeoffs clearly to both technical and non-technical partners. These responsibilities require strong technical judgment, effective communication at all levels, and the ability to balance durable design standards with the business's near-term data needs.Key Responsibilities:40% Data Validation, ETL, Infrastructure Development: Coding validation and ETL to ensure successful data integration30% Data Infrastructure Maintenance: Backup and optimization activities to maintain performance; code, configure, test, etc data to ensure integrity20% Data Architecture Design and Analysis: Create and maintain optimal data pipeline architecture; Develop data architecture to meet business requirements10% Planning/Requirements Analysis: Collaborate with team leads and cross functional partners to assess business requirements and communicate opportunitiesDirect Manager/Direct Reports:This position reports to the Technology Leader.This position has 0 direct reports.Travel Requirements:Typically requires overnight travel less than 10% of the time.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:Bachelor's or Master's in a quantitative or technical field (Computer Science, Engineering, Statistics, etc.) or relevant work experience6+ years of relevant work experienceDemonstrated experience in data architecture, data warehousing, and dimensional modelingDemonstrated experience developing and testing ETL/ELT jobs and pipelines, configuring orchestration, automated CI/CD, writing automation scripts, and supporting pipelines in productionExperience with Dataform or dbt for data transformation and pipeline orchestrationExperience in high-level programming languages such as PythonExperience defining and capturing metadata and rules associated with ETL processesExperience building batch and streaming pipelinesPrior direct experience writing analytical SQL queries and performance-tuning queries (preferably Google BigQuery)Ability to stitch and maintain data from multiple sourcesAbility to optimize pipeline runtime and lower cost on slot/storage consumptionAbility to prioritize requests and manage a pipeline roadmapCoaching junior engineers to help improve their code, best practices, and understanding of data engineering principlesStrong verbal and written communication skills at all levelsMinimum 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 educationMinimum Years of Work Experience:5Preferred Years of Work Experience:No additional years of experienceMinimum Leadership Experience:NonePreferred Leadership Experience:NoneCertifications:NoneCompetencies:Collaborates - Building partnerships and working collaboratively with others to meet shared objectivesCommunicates Effectively - Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiencesCultivates Innovation - Creating new and better ways for the organization to be successfulDrives Engagement - Creating a climate where people are motivated to do their best to help the organization achieve its objectivesInstills Trust - Gaining the confidence and trust of others through honesty, integrity, and authenticityNimble Learning - Actively learning through experimentation when tackling new problems, using both successes and failures as learning fodderOptimizes Work Processes - Knowing the most effective and efficient processes to get things done with a focus on continuous improvementPlans and Aligns - Planning and prioritizing work to meet commitments aligned with organizational goalsTech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.SummaryLocation: STORE SUPPORT CENTER, ATLANTA - 9090Type: Full time