Insurance Data Analyst Jobs in Madison, WI (NOW HIRING)

The Best Experience Company 

Our tagline is “The Best Experience Company.” More than just a set of words, it represents the essence of who we are at Springs Window Fashions. As North America’s premier window covering company, we’re committed 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, if you’re excited 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 IT 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 singleSKU logic depending on product strategy.

CrossFunctional 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 endusers.

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.

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.