Pricing Tool Architect

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 steadily 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 hands-on Pricing Tool Architect to build, scale, and modernize the complex estimation engines used by our Sales and Engineering teams. At our core, we are an engineered-to-order manufacturer with intricate, custom product configurations. This is not a reporting or dashboard role. We need a builder who can interpret our foundational Excel-based pricing tools, scale their underlying logic, and architect robust, user-friendly calculation systems. Working closely with our Subject Matter Experts (SMEs) and engineering teams, you will translate deep manufacturing rules into structured, scalable pricing infrastructure, paving the way for future platforms like CPQ or web-based applications without losing sight of custom engineering realities.

Job Duties:

• Architect & Scale Pricing Engines: Take full ownership of our existing suite of Excel-based pricing and estimating tools, transforming them into robust, scalable, and version-controlled calculation engines using advanced formulas, dynamic arrays, VBA, and Power Query.
• Translate Engineering Logic: Partner directly with Subject Matter Experts (SMEs), Engineering, and Sales to decode complex custom manufacturing workflows, design-to-order options, and product specifications into automated pricing logic.
• Build User-Centric System Architecture: Design clean, intuitive front-ends that hide massive configuration complexity from users while safeguarding underlying business rules and engineering constraints.
• Engineer Guardrails & Error-Proofing: Build input validation, controlled selections, and engineering rule checks (e.g., incompatible options, out-of-range ratings, missing required components) so users cannot produce an invalid, incomplete, or underpriced quote.
• Drive Long-Term Roadmap: Evaluate and guide the future migration of legacy Excel models toward modern, scalable platforms (such as CPQ, web-based applications, or integrated ERP/CRM pricing configurators). Drive out manual entry while improving data quality and speed to quote.
• Maintain Data & Model Integrity: Manage rigorous testing, validation, and version control for all pricing updates to ensure absolute accuracy on custom quotes.
• Provide Technical Support & Training: Serve as the primary technical resource for estimators and sales teams, troubleshooting pricing logic, simplifying workflows, and onboarding new users to best practices.

Minimum Qualifications:

• Bachelor’s degree in Business, Engineering, Finance, Information Systems, Industrial Engineering, or related field (or equivalent experience).
• 3+ years of experience building complex calculation models, pricing tools, or product configuration systems (with heavy emphasis on advanced Microsoft Excel architecture, including VBA and/or Power Query).
• Strong systems-thinking approach with the ability to translate ambiguous, highly customized manufacturing requirements into structured logic.
• Demonstrated experience designing tools that prevent user-entry errors (data validation, locked inputs, dependent selections, rule-based checks).
• Clear communicator capable of working seamlessly between engineering, sales, and finance.

Preferred Qualifications:

• Hands-on experience with engineered-to-order (ETO) physical manufacturing products (e.g., switchgear, control enclosures, power distribution equipment).
• Experience with CPQ (Configure, Price, Quote) software, low-code platforms, or database integration.
• Experience with relational data structures, SQL, or database design.

Success Measures:

• Improved speed and accuracy of quotations.
• Successful modernization and scaling of legacy Excel applications.
• Reduced maintenance effort for pricing tools and reduction in manual pricing errors.
• High user adoption and satisfaction across Estimating and Sales teams.
• Clear, actionable path toward CPQ and digital transformation initiatives.
• 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