SC BI Manager

Home Depot; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as a Business Intelligence Manager, where your expertise in data analysis and reporting will drive actionable insights across the supply chain. You will design and deploy comprehensive BI solutions, collaborate with various functional groups, and create impactful dashboards that enhance decision-making. This role offers the opportunity to mentor junior associates while contributing to a culture of accountability and best practices in data management. If you're passionate about leveraging data to make a difference, this is the perfect opportunity for you.

Qualifications

• 5+ years of experience in business intelligence and data analysis.
• Proven ability to develop scalable reporting solutions.
• Strong knowledge of ETL processes and data modeling.

Responsibilities

• Analyze data independently and prepare actionable reports.
• Create impactful reporting and dashboards for diverse audiences.
• Grow and develop junior associates in technical knowledge.

Skills

Business Intelligence

Data Analysis

ETL Operations

Data Modeling

Interpersonal Skills

Education

Bachelor's Degree

Master's in Industrial Engineering

Tools

Tableau

Microsoft SQL Server

Oracle

Microsoft BI Solutions

R

Visual Basic for Applications

JavaScript

VB.NET

XML

Job description

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

Position Purpose:

The SC BI Manager designs, architects, develops, tests, and deploys comprehensive Business Intelligence solutions for use throughout numerous subject matter areas within the Supply Chain. This individual is responsible for partnering closely with Distribution, Transportation, and Inventory Planning functional groups to provide actionable visibility to data.

Key Responsibilities:

• 25% Demonstrates the consistent ability to analyze data independently and draw actionable conclusions. Should be able to prepare executive level and operational level reporting that is easily understood and acted upon based on findings.
• 25% Coordinates across cross-functional barriers to integrate disparate datasets in a compelling and accurate fashion.
• 25% Creates impactful reporting (both distributed and dashboards) for diverse audiences that scales from record sets containing hundreds of millions of rows.
• 15% Grows and develops junior associates in both technical and functional knowledge areas.
• 10% Drives accountability throughout the supply chain to ensure data best practices are being followed.

Direct Manager/Direct Reports:

• This position reports to Sr Manager or Director.
• This position has 0-4 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:

• * Masters in Industrial Engineering, Logistics, Advanced Analytics, or related field with 3 years experience
• * Typically requires interpersonal skills for dealing with sensitive or controversial situations.
• * Typically faces situations that are unstructured and require original approaches.
• * Typically considers new approaches within general policies and short-term goals when solving problems.
• * Typically expected to provide infrequent status reports to management as needed.

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:

• 5

Preferred Years of Work Experience:

• No additional years of experience

Minimum Leadership Experience:

• None

Preferred Leadership Experience:

• None

Certifications:

• None

Competencies:

• Strong business intelligence and data analysis skills with proven ability that has resulted in scalable and actionable reporting solutions:
• 1. Gathering comprehensive requirements from users and developing strategies to align the requirements within the scope of the deliverable.
• 2. Identifying critical and key data sources across numerous and disparate data sources.
• 3. Experience with conducting complex ETL (Extract-Transform-Load) operations in a scalable fashion.
• 4. Designing and developing both distributed reports and interactive dashboards.
• 5. Data modeling and creating new databases from previously unstructured data sources.
• 6. Experience with the following Business Intelligence dashboard and reporting platforms: Tableau Desktop and Tableau Server
• 7. Experience with the following databases: Microsoft SQL Server and Oracle
• 8. Experience with the following programming languages: R, Visual Basic for Applications in Excel, JavaScript, VB.NET, Visual Basic, and XML.
• 9. Experience with the Full Suite of Microsoft BI Solutions: MS SQL Server, MS SQL Server Integration Services (SSIS), MS SQL Server Analytics Services (SSAS), MS SQL Server Reporting Services (SSRS).