Supply Chain Analyst - Integrated Planning

Job Posting:

Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers’ complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson, a Fortune 500 company, is proud to provide best-in-class products, service and capabilities across the following industries: Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in.

We are seeking the right individual to fill an immediate need for a Supply Chain Analyst supporting our Integrated Planning (IP) organization.

Our seasoned team of analysts are skilled in collecting and analyzing data and providing insights from that data that enable us to draw better conclusions, plan for the future and drive critical business decisions.

This is an exciting opportunity to join & grow with the Supply Chain Planning team!

Location: This role is approved to be Remote anywhere in the United States.

Or will be hybrid if located near one of our offices in:

• Newport News, VA
• Raleigh, NC
• Portland, OR
• Nashville, TN

Primary Responsibilities:

• Provide daily support in the execution of all areas of regional network planning including crafting reports, analyzing data, and planning ongoing projects.
• Perform in-depth & insightful analyses, both on a re-occurring and ad-hoc basis that include but are not limited to stock product files, purchasing cycle, inventory, demand & safety stock for assigned branches, districts, regions, and Market DCs.
• Write and maintain complex SQL queries to extract, join, filter, and aggregate data from our data warehouse for both recurring and ad-hoc requests.
• Design and deploy Power BI dashboards and reports:
• Build data models (relationships, calculated tables/columns) and shape data in Power Query (M).
• Create advanced DAX measures and KPIs to surface key insights.
• Configure refresh schedules and alerts in the Power BI Service, leveraging Power Automate where appropriate.
• Maintain collaborative & cross-functional working relationships with business leaders and peers across the various departments & groups in the organization.
• Serve as a go-to analyst for business by translating raw data into clear visualizations, presentations, and actionable recommendations.
• Support major initiatives such as DC openings, vendor/product transitions, and branch-level inventory events with targeted analyses.

Preferred Qualifications:

• Bachelor’s degree in Business, Analytics, Supply Chain Management, or a related field preferred
• 3+ years writing production SQL (e.g., T-SQL, MySQL): complex SELECTs, joins, window functions, CTEs.
• Advanced Power BI skills: data modeling, Power Query (M), DAX
• Business acumen & a good understanding of supply chain processes (i.e.: warehouse management, purchasing, and inventory)
• Strong analytical skills including the ability to collect, organize, and analyze large datasets with attention to detail and accuracy
• Excellent communication & presentation abilities
• Able to work independently as well as in a highly collaborative environment
• Project management experience is a plus, but not required

At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!

#LI-REMOTE

-

Pay Range:

-

Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience.

-

-

Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.

-

This role is Bonus or Incentive Plan eligible.

-

Ferguson complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements.

-

The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.

Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.

Equal Employment Opportunity and Reasonable Accommodation Information