CPQ Administrator II

Springs Window Fashions and Affiliated Companies; Town of Middleton (WI); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with company match (up to 5%)

Life insurance

Long-term disability insurance

Short-term disability insurance

Paid sick time

Paid vacation time

Paid holidays

Volunteer day

Job summary

Springs Window Fashions and Affiliated Companies is seeking a Product Configuration Business Analyst (Modeler) to translate customer design choices into configurable window coverings. You will work across product management, engineering, IT, and operations to configure, document, and maintain product rules that drive ordering accuracy, pricing, and manufacturability.

The ideal candidate is detail-oriented, with experience in product-based rules and structured data, and enjoys collaborating with

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
• 3+ years in a manufacturing environment.
• Strong analytical and logical reasoning skills.
• Ability to interpret product specifications, BOM structures, and engineering requirements.
• High attention to detail and ability to manage complex rule sets.
• Proficiency in Excel and comfort working with structured data.
• Strong written and verbal communication skills with the ability to collaborate across teams.

Responsibilities

• Build and maintain product configuration models using internal tools (e.g., Magic Tool, Frontier/FRN platforms, PCM workbench).
• Translate business and engineering requirements into rules, validations, option logic, segment structures, and dynamic behavior.
• Configure model options, families, select tables, matrices, color lists, and dependent attributes for new and existing products.
• Maintain dynamic SKU or single-SKU logic depending on product strategy.
• Partner with product managers, engineers, and internal customers to document requirements and ensure accurate model behavior.
• Support manufacturing, purchasing, and customer service by ensuring configuration outputs match operational needs and production flows.
• Participate in product introduction planning and model setup for new launches (e.g., Roman shades, awnings, power shades).
• Conduct testing to ensure correct rule execution, error handling, and compatibility logic.
• Troubleshoot issues in production ordering or manufacturing systems related to configuration defects.
• Validate configuration lists, matrices, retrieval tables, BOM-related logic, and display behavior for end-users.
• Create and maintain documentation for configuration rules, logic flows, product behavior, and change logs.

Skills

Analytical thinking

Logical reasoning

Communication

Excel skills

Collaboration

Education

Bachelor's degree in CS/IT or equivalent

Tools

Frontier 2.x

Magic Tool

PCM

Job description

Description

The Best Experience Company

Our tagline is “The Best Experience Company.” More than just a set of words, itrepresentsthe essence of who we are at Springs Window Fashions. As North America’s premier window covering company,we’recommitted to creating the Best Experience for our associates, consumers and end users, business partners, and communities. We want you to join our team of passionate self-starters who believe the world is full of Best Experience opportunities. So, ifyou’reexcited about the thought of a Best Experience career with a team focused on creating Best Experiences for all, we want to hear from you!

The Product Configuration Business Analyst (Modeler) translates customer design choices into custom window coverings. This role ensures that dealers, end users, and manufacturing systems interact with product information that is clear, validated, and production ready. Working across product management, engineering, IT, and operations, the modeler configures, documents, and maintains electronic product rules that drive ordering accuracy, pricing, and manufacturability.

The ideal candidate is detail-oriented, logically minded, and experienced with product-based rules, conditional logic, and structured data. They should enjoy collaborating with business teams, solving ambiguity, and turning product knowledge into clean, reliable configuration logic.

Key Responsibilities

Product Modeling & Configuration

• Build and maintain product configuration models using internal tools (e.g., Magic Tool, Frontier/FRN platforms, PCM workbench).
• Translate business and engineering requirements into rules, validations, option logic, segment structures, and dynamic behavior.
• Configure model options, families, select tables, matrices, color lists, and dependent attributes for new and existing products.
• Maintain dynamic SKU or single‑SKU logic depending on product strategy.

Cross‑Functional Coordination

• Partner closely with product managers, engineers, and internal customers to document requirements and ensure accurate model behavior.
• Support manufacturing, purchasing, and customer service by ensuring configuration outputs match operational needs and production flows.
• Participate in product introduction planning and model setup for new launches (such as Roman shades, awnings, power shades, etc.).

Data & Rule Quality Assurance

• Conduct testing to ensure correct rule execution, error handling, and compatibility logic.
• Troubleshoot issues in production ordering or manufacturing systems related to configuration defects.
• Validate configuration lists, matrices, retrieval tables, BOM-related logic, and display behavior for end‑users.

Documentation & Standards

• Create and maintain documentation for configuration rules, logic flows, product behavior, and change logs.
• Follow established naming conventions, configuration standards, and modeling processes as outlined in internal modeling guides (e.g., MagicToolTaskNotes).
• Contribute to process improvements and best practices for configuration modeling across the organization.

Requirements

Education and Experience

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
• 3+ years in a manufacturing environment.
• Strong analytical and logical reasoning skills.
• Ability to interpret product specifications, BOM structures, and engineering requirements.
• High attention to detail and ability to manage complex rule sets.
• Proficiency in Excel and comfort working with structured data.
• Strong written and verbal communication skills with the ability to collaborate across teams.

Preferred Qualifications

• Experience in window treatments or other highly configurable product industries.
• Experience with product configuration systems (Frontier 2.2 / 3.2 / 4.2, Magic Tool, PCM, or similar).
• Familiarity with scripting logic, matrices, or rule-driven systems.
• Experience supporting both ordering and manufacturing configuration flows.
• Ability to work with IT teams on integrations, data mapping, or tool enhancements.

How We Work to Deliver a Best Experience: Our Culture

• Our Core Value: We do the right thing, always
• Our Seven Cultural Behaviors
  • Empowerment - We trust our people.
  • Ownership - We take 100% responsibility for our roles actions, and results.
  • Leadership - We all lead by example and talk direct with respect (DWR).
  • One Team - We are One Springs Team.
  • Customer First -We consider our customers' needs before every decision.
  • Continuous Innovation - We are constantly learning, innovating, and improving.
  • Speed - We define priorities and operate with a sense of urgency and agility.

Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan with up to 5% company match of eligible contributions, life insurance, long-term disability insurance, short-term disability insurance, paid sick time at an amount that meets or exceeds all local requirements, paid vacation time (pro-rated for current year based on start date), paid holidays per year, and one paid volunteer day off per year.