Supply Chain Business Analyst

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 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 Business Analyst supporting our Logistics department. 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 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 logistics 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 final mile, parcel, LTL and Truck Load

• 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: parcel contracts and LTL RFPs

• Deep analysis of LTL and Parcel Freight to better the customer’s experience

• Merging financials with activity performance to drive productivity for Ferguson

• 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 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, domestic logistics, final mile, freight pay)

• 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…)