Merchandising Project Specialist

L.n.-Curtis-; Walnut Creek (CA); On-site; USD 65,000 - 90,000; Full time

Job summary

L.N. Curtis & sons is seeking a detail-oriented, data-driven professional to manage and maintain product data within our ERP system.

The role covers end-to-end CPQ product setup, pricing integrity, and governance for a large, highly configurable catalog. Based in Walnut Creek, CA, this on-site position requires collaboration across merchandising, procurement, and IT to ensure data accuracy and lifecycle management.

Qualifications

• 2+ years’ experience with complex data management processes; Excel skills verified by exam.
• Exceptional attention to detail with a strong commitment to accuracy.
• Strong written and verbal communication, interpersonal, and customer service skills.

Responsibilities

• Execute new CPQ product builds end-to-end: organize vendor data, calculate SKU pricing, and enter data into templates and system.
• Maintain and update complex product/master data including pricing, options/variations, part numbers, descriptions and other critical product information.
• Process vendor price and cost updates to ensure system accuracy and margin integrity.
• Monitor and update internal ticketing system to meet deadlines for all projects related to products, vendors, and ERP database.
• Support development and execution of quality standards and procedures for CPQ product setup and pricing matrices.
• Assist in merchandising projects and department operations to support product lifecycle management and cross-functional initiatives.

Skills

Data management

Excel

Analytical

Attention to detail

Communication

Education

Bachelor’s degree or equivalent

Tools

NetSuite

Microsoft Office

Job description

Description

This position works within the Merchandising Department and is primarily responsible for creating and maintaining product data in the ERP database of 50,000+ products. The role executes the end-to-end CPQ (Configure, Price, Quote) product setup process, managing product master data, pricing integrity, and quality standards for highly configurable items. The role supports product data governance by ensuring product information is accurate, consistent, and effectively maintained throughout its lifecycle.

This role requires being on-site Monday-Friday in our Walnut Creek, CA office.

Duties and responsibilities to include:

• Execute new CPQ product builds end-to-end: organizing and evaluating vendor data, calculating SKU pricing, and entering/uploading data into templates and the system.
• Maintain and update complex product and item master data including pricing, options/variations, part numbers, descriptions, and other critical product information.
• Process vendor price and cost updates to ensure system accuracy and margin integrity.
• Actively monitor and update internal ticketing system to meet deadlines for all projects: researching and resolving issues related to products, vendors, and the ERP database.
• Support the development and execution of quality standards and procedures for CPQ product setup, pricing tables, and complex SKU matrices, and resolve related issues.
• Assist in executing merchandising projects and department operations to support product lifecycle management, inventory disposition, and cross-functional business initiatives.
• Execute other duties as assigned by management to address and provide effective support for company mission, values and goals.

Prerequisite Core Competencies

• Detail oriented: proven ability to manage complex data and ensure accuracy.
• Analytical: strong aptitude for data analysis and ability to apply retail math concepts.
• Organized: ability to manage multiple priorities in a fast-paced environment.
• Tactical and resourceful: ability to anticipate needs and identify solutions.
• Team-Oriented: ability to build strong cross-functional relationships.
• Self-starter: strong work ethic and history of continuous professional development.
• Eager to develop expertise in the company’s operations, products, and key vendors.
• Demonstrated good judgement and a high degree of integrity.

Required Qualifications

• Bachelor’s degree (BS/BA) or equivalent work experience.
• 2+ years’ experience with complex data management processes; with proven advanced Excel skills – verified by exam.
• 2+ years’ experience working in small teams for a mid-size company.
• Proficient in Microsoft Office Suite; Excel, Outlook, and Word.
• Exceptional attention to detail with a strong commitment to accuracy.
• Strong problem-solving skills with ability to resolve issues and recommend solutions.
• Strong written and verbal communication, interpersonal, and customer service skills.

Preferred Qualifications

• 3-5 years’ related experience within a retail, distribution, wholesale, manufacturing, or eCommerce team responsible for maintaining a product database of 20,000+ products.
• Demonstrated experience learning and troubleshooting technical systems.
• Hands-on experience with product configurators is a plus.
• Previous experience using NetSuite is a plus.

About Us:

L.N. Curtis & sons is a privately owned and operated corporation that provides Tools for Heroes. The company is headquartered in Walnut Creek, California. Operational centers are located in Salt Lake City, Utah; Kent, Washington; Santa Fe Springs, California; and Gilbert, Arizona. Established in 1929, L.N. Curtis & sons is the premier distributor of first responder equipment and actively sells and services in the United States. The company is focused on servicing the thirteen Western states and the U.S. Government worldwide. L.N. Curtis & sons is committed to supplying the fire and law enforcement industry with the most modern, safe and effective products available. L.N. Curtis & sons is a company whose principal product is service, whose principal resource is people, and whose principal purpose is to be a distinguished leader in the field of supplying and servicing emergency responder equipment.

L.N. Curtis & sons is proud to be an Equal Employment Opportunity and Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex (including pregnancy, childbirth, reproductive health decisions, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, genetic information, political views or activity, or other applicable legally protected characteristics. Additionally, L.N. Curtis & sons participate in the E-Verify program as required by law. You may view our Equal Employment, Pay Transparency and E-Verify notices at https://www.lncurtis.com/careers.

We are committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [e-mail].