Merchandising Project Specialist

L.N. Curtis & sons; Walnut Creek (CA); On-site; USD 75,000 - 105,000; Full time

Job summary

L.N. Curtis & Sons in Walnut Creek, CA, is seeking a Merchandising Data Specialist to manage product data in the ERP system and drive CPQ product setups end-to-end.

You will maintain pricing integrity, vendor data, and complex SKU matrices, ensuring accurate master data throughout the product lifecycle in a fast-paced on-site environment.

Qualifications

• 2+ years’ experience with complex data management and advanced Excel (exam verified).
• 2+ years’ experience working in small teams for a mid-size company.
• Proficient in Microsoft Office Suite (Excel, Outlook, Word).
• Exceptional attention to detail with a strong commitment to accuracy.
• Strong problem-solving skills with ability to resolve issues.
• Strong written and verbal communication, interpersonal, and customer service skills.

Responsibilities

• Execute new CPQ product builds end-to-end: organize data, price SKU, and upload into templates.
• Maintain and update complex product master data including pricing, part numbers, and descriptions.
• Process vendor price and cost updates to ensure margin integrity.
• Monitor and update internal ticketing system to meet project deadlines.
• Support quality standards and procedures for CPQ setup and pricing matrices.
• Assist merchandising projects and cross-functional initiatives.

Skills

Detail oriented

Analytical

Organized

Problem-solving

Written and verbal communication

Customer service

Teamwork

Self-starter

Integrity

Education

Bachelor’s degree (BS/BA) or equivalent work experience

Tools

Excel

Outlook

Word

NetSuite

Job description

L.N. Curtis & Sons

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].

Equal employment opportunity, including veterans and individuals with disabilities.

PI286310312