Pricing Optimization Analyst

Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you’re empowered to make decisions, find solutions and receive rewards for your hard work.

This position will be located in: Fargo, ND

Job Summary

Maintains and enhances pricing optimization cycles through data analysis and market research to determine optimal prices for products, aiming to maximize revenue and profitability while meeting customer demand. Responsible for monitoring the performance of the optimization cycle decisions and their impact on revenue, profitability, and margins through insightful tracking. Provide support to the Strategic Pricing team through key process automation to improve efficiency and decision-making. The ideal candidate will have a strong background in data analysis, pricing strategy, and process automation.

Responsibilities

Essential functions

Oversees and executes pricing optimization cycles for customer matrix and base matrix levels.

Examines historical sales data and analyze market trends, customer behavior, and competitive positioning to refine pricing strategies.

Develops and implements strategies to improve pricing accuracy and responsiveness to market changes.

Reviews pricing performance and adjusts models to maximize ticket margin and gross profit.

Develops and maintains detailed tracking and reporting for ticket margin and gross profit impacts.

Monitors exceptions and trends related to price erosion and price adherence and drives improvement through root cause analysis, provides recommendations and support of improvement plans and/or activities

Provides actionable insights to the pricing and sales teams to enhance profitability and competitive positioning.

Automates key pricing cycle processes to enhance efficiency and minimize errors.

Develops automated reports and dashboards for real-time insights into pricing performance and margin impact.

Optimizes data collection and analysis workflows to improve decision-making speed and accuracy.

Stays updated on emerging technologies and recommend automation solutions to drive process improvements.

Creates and automates templates for analyzing margin erosion, floor and target pricing, cluster analysis, pricing expiry and other pricing-related insights.

Delivers regular and ad-hoc reporting on pricing performance, profitability, and market trends.

Collaborates with cross-functional teams to align pricing strategies within business objectives.

Non-essential functions

Assists both open market and alliance strategic pricing team with reporting as needed

Coordinates Customer Price List review with strategic pricing team

Performs other duties as assigned by supervisor or designate.

Qualifications

Bachelor’s degree in finance, economics, business, data science, or related field or the equivalent of years of experience, required.

Minimum of three years’ of experience in pricing, financial analysis, or a similar analytical role.

Strong proficiency in data analysis tools (e.g., Excel, SQL, Power BI, Tableau).

Experience with process automation, machine learning, AI, and reporting development (e.g., RStudio, Python).

Experience in managing and analyzing large datasets, with a strong attention to detail

Excellent problem-solving and critical-thinking skills, with the ability to identify trends and patterns in complex datasets.

Strong communication and presentation skills, with the ability to convey complex information in a clear and concise manner.

Ability to work collaboratively in a team environment and manage multiple priorities and deadlines.

Must be able to read, write and speak in English.

Prefer strong working knowledge of PC for Windows, Microsoft Office (Excel, Access, Word and PowerPoint, and Outlook), Internet, and SAP software.

Skills and Abilities

Strong organizational skills.

Excellent interpersonal, written and verbal communication, and presentation skills.

Strong reporting and data analysis skills.

Pricing strategy and systems knowledge.

Excellent customer service skills include being competent, accurate, responsive and engaged.

Ability to drive goal setting and performance.

Physical Requirements

Frequency at which you would carry/lift in a typical day:

Occasionally 0 – 33% Frequently 34 – 66% Continuously: 67 – 100%

Lift from Waist:

< than 10 lbs. - Not at all

10 to 25 lbs. - Not at all

26 to 50 lbs. - Not at all

51 to 75 lbs. - Not at all

75 to 100 lbs. - Not at all

100+ lbs. - Not at all

Lift from Floor:

< than 10 lbs. - Frequently

10 to 25 lbs. - Frequently

26 to 50 lbs. - Occasionally

51 to 75 lbs. - Not at all

75 to 100 lbs. - Not at all

100+ lbs. - Not at all

Carried for Distance:

< than 10 lbs. - Not at all

10 to 25 lbs. - Not at all

26 to 50 lbs. - Not at all

51 to 75 lbs. - Not at all

75 to 100 lbs. - Not at all

100+ lbs. - Not at all

Physical Activity

Frequency at which you would do the following in a typical day:

Sitting (a continuous period of being seated) - Continuously

Standing (for sustained periods of time) - Frequently

Walking (moving about on foot to accomplish tasks) - Frequently

Bending/stooping (downward and forward) - Occasionally

Crawling (moving about on hands and knees or hands and feet) - Not at all

Climbing/Walking Stairs (ascending or descending) - Frequently

Reaching (extending arms in any direction) - Frequently

Crouching/squatting (bending the body downward and forward by bending leg and spine) - Occasionally

Kneeling (bending legs at knee to come to rest on knee(s)) - Occasionally

Balancing (maintaining body equilibrium to prevent falling) - Occasionally

Repetitive motion (substantial movement (motions) or the wrists, hands, and/or fingers) - Continuously

Pivoting (movement in any direction with one foot, keeping the other in contact with the floor) - Occasionally

Pushing/Pulling (using upper extremities to press against or draw or tug) - Occasionally

Grasping (Applying pressure to an object with the fingers and palm) - Continuously

Fingering (picking, pinching, typing; working with primarily fingers and not whole hand) - Continuously

Talking (expressing or exchanging ideas by means of the spoken word) - Frequently

Driving (the control and operation of a motor vehicle) - Occasionally

Desk work (work usually performed at a desk) - Continuously

Use of a computer - Continuously

Use of a telephone - Frequently

Hearing (Perceiving the nature of sounds at normal speaking levels) - Continuously

Exposure (to adverse weather & temperature conditions) - Not at all

Travel (travel needed to perform job duties) - Occasionally

Additional Information

This job description is a summary of the job duties and responsibilities and is not intended to cover all possible job duties and is subject to change at the employer’s discretion. Employees must be able to perform the essential job duties and satisfy job requirements either with or without a reasonable accommodation.

Our History

Border States is a leader in the electrical supply distribution industry with over 120 locations in 31 states. Our employee-owners are second to none in delivering top-notch customer service and in demonstrating extra-ordinary people skills. We are one of the largest independent electrical distributors in the United States providing products and services to the construction, industrial and utility industries. Border States has a competitive benefit package and is a 100 percent employee-owned company. Employee-ownership is a significant part of our culture and our success stems from the dedication of our employee-owners. We practice open-book management and our employee-owners are empowered with clearly defined levels of authority to be innovative and decisive, allowing us to respond quickly to the needs of customers. Employee-owners understand their roles in the success of the company and care about customers’ needs, which drives our focus on adding value to everything we do. We recognize that not all customers are the same and each has specific requirements. Our employee-owners understand these diverse needs and have the commitment, resourcefulness and flexibility to outperform all others.

Values

As a Border States employee-owner, you’re responsible for living our mission, service philosophy and service standards.

Our Purpose

We believe unstoppable businesses shouldn't go it alone. We are owners - of relationships, of outcomes, of every moment these unstoppable businesses need to deliver.

Service Philosophy

We earn customer loyalty and confidence by caring about their needs and adding value to everything we do.

Service Standards

Border States employee-owners are competent, accurate, responsive, and engaged .

Your career

Join an experienced team at one of the largest electrical distributors in the United States. What are you waiting for?

Border States has a competitive benefits package which includes but is not limited to:

Health, Dental and Vision Benefits

Accident, Critical Illness, Hospital Indemnity

FSA & HSA

Employee Stock Ownership Plan (ESOP)

Disability Benefits

401(k) Retirement Plan

Life Insurance

Employee Assistance Program

Paid Holidays

Paid Volunteer Time

Personal Leave time and more!

Border States provides bonuses to their employee-owners upon the achievement of branch and company goals.

Equal Opportunity For All

It’s not just the law. It’s something we’ve believed in since our founding. We value the diversity of all of our employee-owners and will always be an equal opportunity employer.

Drug Free/Smoke Free workplace