Pricing Analyst

Data Analytics Countryside, Illinois Orange, Connecticut Nashville, Tennessee Grand Prairie, Texas


Description

Life at Colony: 
Colony Hardware is the leading distributor of Tools, Equipment, Fasteners, Supplies, and Safety Products to commercial construction and industrial accounts throughout our markets. 
 
At Colony, our people are our most valuable asset. Success as a Colony Associate means being reliable, conscientious, and passionate. With our direction centered on teamwork, every employee at Colony will not only find their work to be meaningful, but will have the opportunity to grow alongside Colony, both professionally and personally. 
 
If you possess a will to win and would like to join a culture where integrity and collaboration are integral to success, apply to Colony Hardware today to join our growing family! 
 
Position Overview 
The Pricing Analyst ensures that pricing is accurate and updated, from adjusting price classes, sending out daily cost change reports, and logging changes, to running monthly and quarterly reports, comparing and reviewing standard price lists, and reviewing all manual cost changes. We are open to remote candidates but prefer candidates who are located near one of our branches. 
 
A Little About Your Day: 
 
Daily Duties
  • Review new items and adjust pricing as needed.
  • Review and update any A-Z cost adjustments from the log.
  • Apply any one-off cost changes sent from the category managers and buyers.
  • Apply customer contracts as they come in.
Weekly Duties
  • Review cost change log and work with buyers and category managers on missing data.
  • Check, review, and update Prophet 21 MAP item discounts.
Monthly Duties
  • Run new Item Defined Cost reports from Facts, NetSuite, and Prophet 21
  • Match Price Family Codes between the (3) ERP’s and correct / adjust pricing.  
  • Run and compare /review and update current MAP pricing for key vendors.
  • Customer contract reviews
This might be the opportunity for you if you: 
  • Are a self-starter, with the ability to work with minimal direct supervision.
  • Have the ability to communicate technical concepts effectively to a broad group of stakeholders.
  • Enjoy having deep expertise and being a subject matter expert on IT.
 
What You’ll Need to Have for success: 
  • Undergraduate degree in a related field or the equivalent combination of training and experience.
  • 3+ Years of experience with pricing.
  • Very good understanding of Excel including various LOOKUPS, Text functions, and PivotTables. Some experience with PowerQuery is a bonus.
  • Exceptional attention to detail and communication abilities.
 
We Can Offer You: 
We value performance that exhibits a high sense of urgency, coupled with attention to detail and a strong customer service orientation! We also care about the welfare of our employees, which is why our salary and benefits are competitive. Colony’s benefits include:  
  • Medical, Dental, Vision, STD/LTD, Life Insurance (company paid!)
  • 401k with generous match
  • HSA/FSA
  • Competitive PTO and paid holidays
  • Company-provided PPE as required
  • Industry leading training and development
  • Generous discounts on the best products from leading industry vendors
 
Colony’s Commitment to Equal Opportunity 

Colony Hardware Corporation is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, sexual orientation, national origin, citizenship, religion, marital status, victim of domestic violence, familial status, genetic predisposition or information, disability, Family and Medical Leave, military or veteran status, citizenship, pregnancy, childbirth and related medical conditions, or any  other classification protected by federal, state, and local laws and ordinances. Our management is dedicated to ensuring the fulfillment of this policy with respect to hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment advertising, pay, and other forms of compensation, training, and general treatment during employment.