Pricing Systems Specialist

Panelmatic; Houston, Northern (TX, KY); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) matched

Paid holidays

Educational reimbursement

Career advancement opportunities

Job summary

Panelmatic, Inc. is seeking a dedicated Pricing Systems & Analytics Specialist to own and maintain pricing applications used by Sales and Estimating to produce accurate quotes.

You will drive automation, integrations, and modern interfaces, partnering across Estimating, Sales, Finance and IT to ensure accuracy and efficiency. The role requires advanced Excel skills and experience with pricing methodologies, CPQ, and ERP-integrated tools, with opportunities to modernize legacy pricing systems and

Qualifications

• Bachelor’s degree in Business, Engineering, Finance, Information Systems, Industrial Engineering, or related field (or equivalent experience).
• 2-5 years supporting pricing, estimating, sales operations, or business systems.
• Expert-level Microsoft Excel skills.
• Strong analytical and problem-solving abilities.
• Detail-oriented and customer-focused, with a systems-thinking approach.
• Ability to translate business requirements into technical solutions.
• Clear communicator with technical and non-technical users.

Responsibilities

• Own and maintain all pricing and estimating tools.
• Keep pricing models accurate and aligned with engineering standards and commercial strategy.
• Manage version control, testing, and rollout of pricing tool updates.
• Provide day-to-day troubleshooting and support to estimators and sales.
• Simplify complex pricing workflows.
• Build enhancements that improve usability, speed, and accuracy.
• Build advanced Excel solutions using: Power Query, Power Pivot, VBA (where appropriate), Dynamic arrays, Advanced formulas.
• Evaluate migrating Excel tools to more scalable platforms such as Power Apps, Web-based applications, CPQ platforms, Salesforce integrations, ERP-connected pricing applications.
• Partner with IT and developers on simple user interfaces that hide pricing complexity without changing business rules.
• Learn the company’s products, manufacturing processes, options, and commercial offerings.
• Translate engineering and product requirements into pricing logic.
• Work with Engineering and Product Management to add new products and design changes to pricing tools.
• Learn estimating workflows and recommend improvements.
• Act as the go-to resource for pricing tool questions.
• Train new users on pricing applications and best practices.
• Help with complex pricing and quoting scenarios.
• Support standardization across estimating teams.
• Build dashboards and reports covering: Tool performance, Output and accuracy, Use data to identify process improvements.
• Document pricing methodologies and system logic.
• Recommend changes that cut manual effort and improve data quality.
• Support pricing systems, CPQ, CRM, and digital transformation initiatives.

Skills

Excel expert

Power Query

Power Pivot

VBA

Dynamic arrays

Advanced formulas

Power Apps

Web-based apps

CPQ

Salesforce integrations

ERP integrations

Education

Bachelor’s degree or equivalent experience

Tools

CPQ software

Power BI

SQL

Job description

About Us:

Panelmatic, Inc. was founded in 1957 in Youngstown, OH to serve manufacturing industries with the design and build of custom electrical, instrument, and pneumatic control panels. Our business has sufficiently grown over the years to support expansion for our clients. We have produced control packages for many of America's top corporations in the chemical, environmental, food, pulp and paper, rubber, petroleum, pharmaceutical, glass, metals, and utilities industries. We also deliver equipment for use worldwide. Our rigorous methodology assures compliance with domestic and international standards. We can meet the needs of our diverse clientele from start to finish through sales, design, fabrication, testing, and delivery.

Since 1957, we have been known for our high-quality, custom-built control packages, our comprehensive service, and our technological and manufacturing expertise. This expertise assures you of our ability to handle the largest and most complex packages quickly and efficiently.

Job Summary:

Panelmatic, Inc. is seeking a dedicated and skilled Pricing Systems & Analytics Specialist to build and maintain the pricing tools that Sales and Estimating use to produce accurate, consistent quotes.

This individual owns the company’s pricing applications and drives their move toward more scalable, user-friendly solutions through automation, integrations, and modern interfaces. Success requires advanced technical skill plus working knowledge of estimating methods and commercial processes.

The role works most closely with Estimating, Sales, Finance and partners across functions to keep pricing tools accurate, efficient, and aligned with business objectives.

Job Duties:

• Own and maintain all pricing and estimating tools.
• Keep pricing models accurate and aligned with engineering standards and commercial strategy.
• Manage version control, testing, and rollout of pricing tool updates.
• Provide day-to-day troubleshooting and support to estimators and sales.
• Simplify complex pricing workflows.
• Build enhancements that improve usability, speed, and accuracy.
• Build advanced Excel solutions using:
• Power Query
• Power Pivot
• VBA (where appropriate)
• Dynamic arrays
• Advanced formulas
• Evaluate migrating Excel tools to more scalable platforms such as:
• Power Apps
• Web-based applications
• CPQ platforms
• Salesforce integrations
• ERP-connected pricing applications
• Partner with IT and developers on simple user interfaces that hide pricing complexity without changing business rules.
• Learn the company’s products, manufacturing processes, options, and commercial offerings.
• Translate engineering and product requirements into pricing logic.
• Work with Engineering and Product Management to add new products and design changes to pricing tools.
• Learn estimating workflows and recommend improvements.
• Act as the go-to resource for pricing tool questions.
• Train new users on pricing applications and best practices.
• Help with complex pricing and quoting scenarios.
• Support standardization across estimating teams.
• Build dashboards and reports covering:
• Tool performance
• Output and accuracy
• Use data to identify process improvements.
• Document pricing methodologies and system logic.
• Recommend changes that cut manual effort and improve data quality.
• Support pricing systems, CPQ, CRM, and digital transformation initiatives.

Minimum Qualifications:

• Bachelor’s degree in Business, Engineering, Finance, Information Systems, Industrial Engineering, or related field (or equivalent experience).
• 2-5 years supporting pricing, estimating, sales operations, or business systems.
• Expert-level Microsoft Excel skills.
• Strong analytical and problem-solving abilities.Detail-oriented and customer-focused, with a systems-thinking approach.
• Ability to translate business requirements into technical solutions.
• Clear communicator with technical and non-technical users.

Preferred Qualifications:

• Manufacturing or engineered-to-order product experience including switchgear, control enclosures, relays, or other power distribution equipment.
• Pricing or estimating software experience
• Power BI, Power Apps, SQL, or Power Automate.
• Salesforce, CPQ, or ERP.
• Basic VBA or low-code development.
• Improved speed and accuracy of quotations.
• Reduced maintenance effort for pricing tools.
• Increased user adoption and satisfaction.
• Reduction in manual pricing errors.
• Successful modernization of legacy Excel applications.
• Delivery of actionable sales analytics.
• Standardization of pricing methodologies across the organization.

• Medical, dental, vision, HSA, term life, AD&D, STD, LTD
• 100% medical premium paid for by Panelmatic for the employee-only level medical coverage
• 80% paid for by Panelmatic and 20% paid for by the employee on all other level medical coverage (i.e. employee plus child, employee plus spouse, family)
• 401(k) contributions matched 100% up to 4%
• Scholarships, educational reimbursement, paid volunteerism, and paid personal and professional development provided
• PTO and paid holidays provided
• Career advancement opportunities
• Competitive wages