Purchasing Analyst

D; Caldwell (ID); On-site; USD 45,000 - 55,000; Full time

Job summary

D&B Supply, a farm and ranch lifestyle retailer headquartered near Caldwell, Idaho, seeks a data analyst to provide cross-department insights. You will analyze sales, inventory, profitability and other business metrics, primarily with the Purchasing team, and share findings to guide decisions.

The position is salaried, starting at $50,000 per year, with compensation based on experience and qualifications. Proficiency in SQL and BI tools is encouraged.

Qualifications

• Requires excellent written and oral communication skills along with strong analytical, organizational and computer skills.
• Experience in SQL querying/database language is preferred, not required.
• Experience in visualization tools/platforms such as Domo, Power BI, or Tableau is preferred, not required.

Responsibilities

• Maintain, analyze, and provide established recurring reports used by the Purchasing team, other departments, and management.
• Gather, clean, interpret data and present findings to relevant purchasing team members and management.
• Provide and present recommended forecasts to buyers and management.
• Monitor and analyze margin and sales data.
• Identify trends and patterns in data.
• Collaborate with purchasing team members to communicate findings, discuss recommendations, and identify opportunities for action.
• Support buyers and management with established needs and goals.
• Review processes and offers to ensure accurate and successful pricing and event development for marketing flyers and promotional events.
• Other analytical duties pertaining to the procurement of products, goods or services as assigned by area manager/director.

Skills

Data analysis

SQL

Data visualization

Power BI

Tableau

Domo

Education

Associate or Bachelor’s in business or related field

High School Diploma or equivalent

Tools

Power BI

Tableau

Domo

Job description

Description

Who We Are:

We are a leading farm and ranch lifestyle retailer headquartered in the Caldwell, Idaho area with stores in Idaho and Oregon. We are passionate about our customers in providing products to enhance their lifestyle and experience. Whether they have a 100-acre ranch or a small garden in their backyard, we take pride in providing them with solutions for their needs. We carry a large depth of product categories allowing us to best serve our customers. In our stores you will find products from pet food and supplies, power tools and accessories, to lawn and garden and almost everything in between. D&B Supply is a company built to serve those that live and love the northwest, including ranchers, farmers, and suburbanites who feel a real connection to the land, their animals, and the outdoors.

Job Summary:

Provide data analysis and insights for departments across the company to help teams make informed decisions that support company success and meet our customers’ needs. This position primarily works with the Purchasing team members to analyze sales, inventory, profitability, and other business metrics. The position will work closely with the team and communicate findings and recommendations. This is a salary position starting at $50,000 per year, with compensation based on experience and qualifications.

Essential Functions/Duties:

• Maintain, analyze, and provide established recurring reports used by the Purchasing team, other departments, and management.
• Gather, clean, interpret data and present findings to relevant purchasing team members and management.
• Provide and present recommended forecasts to buyers and management.
• Monitor and analyze margin and sales data.
• Identify trends and patterns in data.
• Collaborate with purchasing team members to communicate findings, discuss recommendations, and identify opportunities for action.
• Support buyers and management with established needs and goals.
• Review processes and offers to ensure accurate and successful pricing and event development for marketing flyers and promotional events.
• Other analytical duties pertaining to the procurement of products, goods or services as assigned by area manager/director.

Requirements

Required Knowledge and Skills:

Requires excellent written and oral communication skills along with strong analytical, organizational and computer skills. Report writing and presentation experience preferred, not required. Experience in SQL querying/database language preferred, not required. Experience in visualization tools/platforms such as Domo, Power BI, or Tableau preferred, not required. Technical expertise in data mining, data segmentation, solid reporting techniques, and communications preferred.

Required Experience:

At least 2 years' experience as an analyst in an established organization is preferred.

Required Education/Certification:

Associates or bachelor’s degree in business or related field; or equivalent experience preferred, not required. High School Diploma or equivalent required.

Other Requirements:

Must be able to spend many hours a day working at a computer.

This description is intended to indicate the kinds of tasks and levels of work difficulty that will be required of positions that will be given this title and shall not be construed as declaring what the specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of any supervisor to assign, direct, and control the work of employees under his or her supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty.