Pricing & Data Analyst

Position Purpose: The Pricing & Data Analyst plays a critical role in driving profitability and pricing accuracy across the organization. This position is responsible for maintaining and optimizing pricing, product, and cost data within the Epicor Prophet 21 ERP system while delivering actionable pricing analysis to Sales, Purchasing, Finance, and regional leadership. The analyst partners closely with Regional Vice Presidents, Sales Managers, and branch leadership to support strategic pricing decisions, margin optimization, and data integrity in a fast-paced, distributed environment. This role requires advanced Excel skills, strong ERP expertise, analytical rigor, and the ability to communicate complex pricing insights clearly across all levels of the organization.

Key Responsibilities:

Pricing & Margin Analysis

• Conduct detailed sales, item, and margin analysis to identify pricing opportunities and margin erosion.

• Evaluate pricing accuracy and competitiveness across regions, customers, and product categories.

• Support quarterly pricing reviews and implement ongoing pricing adjustments aligned with corporate strategy.

• Develop regional and customer-level pricing recommendations for commodities and large-ticket items.

ERP Data Management (Epicor Prophet 21)

• Maintain and update pricing matrices, customer-specific pricing, vendor costs, and product records in Epicor Prophet 21.

• Create and maintain new data sets including products, vendors, pricing groups, and cost files following approved workflows.

• Perform bulk pricing updates, imports, and global changes while ensuring audit compliance and data integrity.

• Investigate and resolve pricing discrepancies, overrides, and system-related margin issues.

• Support ERP enhancements, testing, and pricing-related configuration changes.

Collaboration & Business Support

• Partner with Sales, Purchasing, Finance, Regional Vice Presidents, and branch managers to implement pricing initiatives.

• Serve as a trusted pricing and data resource for field operations and leadership.

• Communicate pricing changes clearly and professionally to all levels of management.

• Generate pricing, margin, and performance reports for leadership review.

Process Improvement & Automation

• Leverage advanced Excel and office automation tools to streamline pricing workflows and reporting.

• Develop macros and automated solutions to improve efficiency and accuracy.

• Maintain documentation for pricing rules, procedures, and change logs.

• Share best practices and process improvements across the team.

Direct Manager/Direct Reports:

• Purchasing Manager

Travel Requirements:

• Twice a year  to Tanner HQ. for in person meetings.

Physical Requirements

• Ability to remain in a stationary office or remote work environment for extended periods.

• Ability to operate standard office equipment.

• Strong problem-solving, multitasking, prioritization, and stress-management skills.

• Ability to analyze information quickly and communicate solutions effectively.

Working Conditions

• Remote/virtual

Minimum Qualifications

• High School Diploma or equivalent

• Minimum of 1 year of experience in pricing analysis, ERP data management, or a related analytical role.

• Hands-on experience with Epicor Prophet 21 (pricing, product, vendor, and customer modules strongly preferred).

• Advanced Excel proficiency, including:

  • Pivot Tables

  • VLOOKUP/XLOOKUP and other lookup functions

  • Multi-sheet data management

  • Macros and automation

• Experience performing sales, cost, and margin analysis.

• Strong attention to detail and ability to manage large datasets.

• Excellent written and verbal communication skills.

• Ability to work independently while collaborating effectively across teams.

Preferred Qualifications

• Experience in distribution, wholesale, manufacturing, construction supply, or landscape distribution industries.

• Familiarity with SQL, data extraction tools, Tableau, or Power BI.

• Experience with contract pricing, rebates, and margin management.

• Strong understanding of financial principles, including profit and loss.

• Project management or change management experience.

• Professional certifications such as Certified Pricing Professional (CPP), CMA, CFA, or advanced Excel certifications

Minimum Education:

• High School Diploma or equivalent

Preferred Education:

• Bachelor’s degree in Business, Finance, Economics, or related field preferred.

Minimum Years of Work Experience:

• Minimum of 1 year of experience in pricing analysis, ERP data management, or a related analytical role

Certifications:

• Certified Pricing Professional (CPP), CMA, CFA, or advanced Excel certifications

Competencies:

• Agility and Resilience

• Business Insights

• Collaboration

• Customer Focus

• Develop Talent

• Drive Results

• Leadership Courage

Work Location:

Remote/Virtual

The base salary for this position typically falls within the range of $73,400.00 to $95,400.00 annually. Starting wage may vary based on a number of factors including, but not limited to, the position being offered, location, education, training, and/or experience. SRS Distribution offers additional competitive and non-financial benefits. Depending on the role, associates may also be eligible for performance-based bonus programs, commissions, profit-sharing programs, car allowance or automobile and fuel program, and reimbursement for travel expenses in accordance with company travel policy.

      

             

Job Location: Above Structure 3 - Brooklyn

      

714 Montauk Ave Brooklyn, NY 11208

‎

As an Equal Employment Opportunity (EEO) employer SRS Distribution Inc., including all its subsidiaries, provides job opportunities to qualified individuals without regard to actual or perceived race, color, creed, religion, national origin, sex, gender, age, disability, gender identity, sexual orientation, citizenship status, uniform service, veteran status, marital status, genetic information, physical or mental disability, or any other characteristic in accordance with applicable federal, state, and local EEO laws. If you are an individual with a disability or a disabled veteran and require a reasonable accommodation in applying for any posted position, please contact Human Resources at US: 855.556.3221, or by email to: HR@Help.SRSDistribution.com with the nature of your accommodation request and include the Business name, location and title of the job opening. Please allow one (1) business day for a reply. All employment offers are contingent upon successful completion of a background check and drug screen, as permitted by law.

‎

Competitive weekly/bi-weekly pay, discretionary bonuses, 401(k) with company match, Employee Stock Purchase Plan, paid time off (vacation, sick, volunteer, holidays, birthday, floating), medical/dental/vision, flexible spending accounts, company-paid life and short-term disability, plus optional long-term disability, and additional life insurance. All benefits subject to eligibility.

‎

‎

Should a Candidate be submitted to fill a position by a recruiting or staffing services agency (“Agency”), the Company has no obligation to pay the Agency any fee for submission, offer, placement or any service without a fully executed contract of service covering the engagement.