Supply Chain Business Analyst

Job Posting:

Ferguson is North America's leading value-added distributor across residential, non-residential, new construction and repair, maintenance, and improvement (RMI) end markets. Spanning 34,000 suppliers and more than one million customers, we deliver local expertise, value-added solutions, and the industry's most extensive portfolio of products. From infrastructure, plumbing, and appliances, to HVAC, fire protection, fabrication, and more, we make our customers' complex projects simple, successful, and sustainable.

We are seeking the right individual to fill an immediate need for a Supply Chain Business 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 and grow with the Supply Chain Planning team!

Location:

This is a Hybrid role based out of Newport News, VA HQ location, in accordance with the Ferguson Flex schedule; 3 days office / 2 days remote

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

• Ownership & responsibilities for various reporting, dashboards, metrics, and automation of processes:

• Effectively mine data from various Enterprise systems (e.g.: Trilogie, SQL Data Warehouse, Logility, Azure).

• Construct, develop, optimize, manipulate, and implement sophisticated SQL database queries.

• Design, build, deploy & maintain PowerBI solutions & dashboards.

• Find opportunities to use PowerAutomate and explore PowerApps.

• Provide analytical & creative problem-solving support for projects such as:

• Market Distribution Center (MDC) openings

• Distribution Center (DC) readiness for acquisitions

• Large-scale product or vendor transitions

• Large-scale branch inventory initiatives/events

• Large-scale branch Instocks initiatives/events

• Maintain collaborative & cross-functional working relationships with business leaders and peers across the various departments & groups in the organization.

• Serve as subject matter expert to business leaders, helping them to solve problems, draw conclusions, plan for the future & drive critical business decisions.

Preferred Qualifications:

• Bachelor's degree in Business, Analytics, Supply Chain Management, or a related field preferred

• Minimum of 1-5 years experience (incl internship) in supply chain, purchasing, or analytics

• Prior experience working in a branch or distribution center is a plus, but not required

• Business insight & 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

• "Forward Thinker" with excellent problem-solving skills

• Excellent communication & presentation skills

• Able to work independently as well as in a highly collaborative environment

• Knowledge of statistical concepts as well as analytical methodologies

• Robust knowledge of and experience with business intelligence tools such as PowerBI or Tableau

• Skilled and experienced in using technologies to mine and/or analyze data (e.g.: Excel, SQL, Azure…)

• Project management experience is a plus, but not required

Ferguson is dedicated to providing meaningful benefits programs and products to our associates and their families-geared toward benefits, wellness, financial protection, and retirement savings. Ferguson offers a competitive benefits package that includes medical, dental, vision, retirement savings with company match, paid leave (vacation, sick, personal, holiday, and parental), employee assistance programs, associate discounts, community involvement opportunities, and much more!

• Pay Range:

• $4,124.70 - $6,783.70

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

• This role is Bonus or Incentive Plan eligible.

• 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