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, particularly with advanced Microsoft Excel (VBA and/or Power Query).
Strong systems-thinking ability to translate complex manufacturing requirements into structured logic.
Experience designing tools that minimize user-entry errors through validation and rule-based checks.
Effective communicator, able to collaborate across engineering, sales, and finance teams.
Responsibilities
Architect and scale existing Excel-based pricing tools into robust, scalable calculation engines using advanced Excel features.
Translate complex manufacturing workflows and specifications into automated pricing logic in collaboration with SMEs and engineering teams.
Design user-friendly system architecture that simplifies complex configurations while maintaining business rules.
Implement guardrails and error-proofing measures to ensure accurate and valid quotes.
Drive the modernization of legacy Excel models towards scalable platforms like CPQ or web-based applications.
Maintain data integrity through rigorous testing, validation, and version control of pricing updates.
Provide technical support and training to estimators and sales teams, enhancing workflows and onboarding processes.
Benefits
Medical, dental, vision, HSA, term life, AD&D, STD, LTD coverage.
100% of employee-only medical premium covered by Panelmatic.
80% of other medical coverage premiums paid by Panelmatic.
401(k) contributions matched 100% up to 4%.
Scholarships, educational reimbursement, and paid volunteerism opportunities.
Paid time off (PTO) and holidays.
Career advancement opportunities available.
Competitive wages offered.
Full Job Description
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.
Requirements
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.
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.
Benefits
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
