Online Senior BI Engineer

Home Depot; United States; Remote; USD 90,000 - 180,000; Full time

Job summary

Join a leading company as a Sr Data Engineer, where you'll be key in developing and maintaining data solutions that enhance decision-making. You'll collaborate across teams, and leverage your in-depth knowledge of data analytics and engineering to optimize data pipelines. Bring your experience in Python, SQL, and ETL processes to this critical role that supports business intelligence initiatives.

Qualifications

• 4+ years of relevant work experience in data engineering.
• Experience with Python and SQL for data extraction and analysis.
• Knowledge of ETL processes and tools.

Responsibilities

• Develop and maintain data pipelines using advanced analytical methodologies.
• Collaborate with cross-functional teams to drive data solutions.
• Mentor junior engineers in best practices for coding and data handling.

Skills

Predictive modeling

Data mining

Data analysis

Project management

Communication

Education

Bachelor's degree in a related field

Master's degree in a related field

Job description

With a career at The Home Depot, you can be yourself and also be part of something bigger.

Position Purpose:

Online Data Engineer teams at The Home Depot translate business requirements and build the infrastructure needed to capture customer data. They acquire datasets that align with business needs and develop algorithms to transform data into useful, actionable information. Additionally, they build, test, and maintain database pipeline architectures. They create new data validation methods and data analysis tools. Data Engineers develop application programming interfaces (APIs) to retrieve data. Our Data Engineers develop, host, and maintain in-house enterprise solutions to improve reliability and confidence through monitoring, continually testing, and validating the products we support. These associates use big-data 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 software, systems and applications development to ensure compatibility and operability of data connections, flows and storage requirements. Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs.

Key Responsibilities:

• 20% - Business Collaboration - Leverage extensive business knowledge into solution approach; Effectively develop trust and collaboration with internal customers and cross-functional teams; Provide general education on advanced analytics to technical and non-technical business partners; Deep understanding of IT needs for the team to be successful in tackling business problems; Actively seek out new business opportunities to leverage data science as a competitive advantage.
• 30% - Project Management & Team Support - Work with project teams and business partners to determine project goals; Provide direction on prioritization of work and ensure quality of work; Provide mentoring and coaching to more junior roles to support their technical competencies; Collaborate with managers and team in the distribution of workload and resources; Support recruiting and hiring efforts for the team.
• 35% - Solution Development - Execute tasks with high levels of efficiency and quality; Make appropriate selection, utilization and interpretation of advanced analytical methodologies; Effectively communicate insights and recommendations to both technical and non-technical leaders and business customers/partners; Prepare reports, updates and/or presentations related to progress made on a project or solution; Clearly communicate impacts of recommendations to drive alignment and appropriate implementation.
• 15% - Technical Exploration & Development - Guide and direct project teams in the requirements gathering, design, and development of complex applications/programs; Seek further knowledge on key developments within advanced analytics, technical skill sets, and additional data sources; Participate in the continuous improvement of predictive and prescriptive analytics by developing replicable solutions.

Direct Manager/Direct Reports:

• This Position typically reports to Manager or Above.
• This role has 0 direct reports.

Travel Requirements:

• Typically requires overnight travel 5% to 20% 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 18 years of age or older.
• Must be legally permitted to work in the United States.
• 4 years of relevant work experience

Preferred Qualifications:

• Masters in a quantitative field (Analytics, Computer Science, Math, Physics, Statistics, etc.) or relevant work experience
• 5+ years of relevant work experience
• Demonstrated experience in predictive modeling, data mining and data analysis
• Demonstrated experience developing and testing ETL jobs/pipelines, configuring orchestration, automated CI/CD, writing automation scripts, and supporting the pipelines in production
• Experience in high-level programming languages such as Python
• Experience defining and capturing metadata and rules associated with ETL processes
• Experience building Batch and Streaming pipelines
• Prior direct experience writing analytical SQL queries and performance-tuning queries
• Ability to stich and maintain data from multiple sources
• Ability to use JavaScript, Front-end development frameworks (React, Nucleus), and QA apps (Retina, KPI Shield, Alert Goose)
• Ability to produce tags for site data
• Ability to code in Python, Google BigQuery to stitch and enrich the raw data from multiple sources
• Proven ability to use PySpark, AirFlow, and DataProc to engineer and automate data flows pipelines
• Ability to optimize the pipelines run time and lower the cost on slots/storage consumption
• Ability to prioritize requests and manage a product roadmap
• Coaching junior engineers to help improve their code, best practices, and understanding of data engineering principles.
• Strong verbal and written communications skills at all levels
  

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:

• The knowledge, skills and abilities typically acquired through the completion of a master's degree program or equivalent degree in a field of study related to the job.
  

Minimum Years of Work Experience:

• 4
  

Preferred Years of Work Experience:

• 5
  

Minimum Leadership Experience:

• No previous leadership experience

Preferred Leadership Experience:

• No previous leadership experience
  

Certifications:

• None

Competencies:

• Action Oriented
• Collaborates
• Drives Engagement
• Communicates Effectively
• Customer Focus
• Drives Results
• Manages Conflict

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 - $180,000