WMS Software Developer I

Harbor Wholesale; Lacey (WA); Hybrid; USD 70,000 - 85,000; Full time

Benefits offered by this job

Medical insurance

401k with match

Paid time off

Job summary

Harbor Wholesale is seeking a Level I WMS Software Developer to troubleshoot, maintain, and extend software that manages warehouse operations. You will gather requirements, analyze processes, design and develop solutions, and train warehouse staff. Occasional travel and after-hours support may be required.

Lacey, WA onsite/hybrid options available with regular check-ins. Compensation ranges from $70,000 to $85,000 DOE, with a full benefits package including medical, dental, vision, life,

Qualifications

• Bachelor’s degree preferred; equivalent experience considered.
• Experience with SQL query optimization and data modeling is expected.
• Familiarity with warehouse operations and ERP integrations is a plus.

Responsibilities

• Design, develop, optimize and deploy SQL solutions for warehouse operations.
• Write and maintain queries, views, and stored procedures for reporting and operations.
• Assist with data validation and data quality improvements across systems.
• Collaborate with business users and cross-functional teams to translate requirements into data solutions.
• Document database objects, report logic and recurring data processes.

Skills

SQL

Relational databases

Data analysis

Problem solving

Analytical thinking

Team collaboration

Agile practices

Education

Bachelor’s degree in Computer Science or related field

Certifications / coursework in SQL or data analytics

Tools

Microsoft SQL Server

SQL Server Management Studio

Visual Studio Code

Page Editor

Advantage Architect

Job description

Overview

Washington State local resident candidates only.

The WMS Software Developer’s primary responsibilities are to troubleshoot, maintain, enhance and extend software applications that manage warehouse operations within the organization. Developers at each level must be capable of gathering user requirements, analyzing warehouse processes and workflows, designing and developing custom solutions in accordance with development standards and internal SOP’s, documenting enhancements and training warehouse personnel. Developers in this role will also provide technical guidance and support to other technical, analytical, systems or warehouse operations teams as well as collaborate with vendor partners that provide external support.

*Occasional travel for site visits and remote site work may be required as well as occasional after-hours support to resolve processing disruptions.

*Lacey, WA onsite/hybrid options available with regular check-ins with the Director of ERP Systems and/or Senior WMS Software Developer.

Compensation: $70K - 85K DOE

BenefitsSummary:Full line of benefits including medical, dental, vision, life and disability insurance; 401k retirement program with company match; vacation, sick time, floater, and holidays; and much more.

Responsibilities

Level I WMS Developer

A Level I WMS Developer has foundational skills and understandings of database design, query building, development and administration but has less than 3 years of professional experience with warehouse operations or WMS systems. Responsibilities at this level include maintaining database and WMS configurations, report and query building, and functional enhancements to processes that keep warehouse operations running efficiently. This position will work closely with Level II and Level III developers, analysts, and business users to troubleshoot issues, gather requirements, improve data quality, support reporting needs, document processes and enhancements and assist with integrations across ERP, warehouse, and customer facing systems.

Essential Job Functions

• Design, develop, optimize and deploy SQL solutions, stored procedures, functions, views, SQL Jobs, and data models that support warehouse operations.
• Writing and maintaining queries, views, and stored procedures to support reporting and day-to-day operations.
• Support data validation and cleanup efforts to improve the accuracy of customer, product, logistics and transactional data.
• Analyze root causes of data issues affecting customer orders, inventory availability, shipments, and financial transactions, and implement durable fixes.
• Partner with business stakeholders to translate operational requirements into scalable reporting and data solutions.
• Document database objects, report logic, recurring data processes and custom enhancements.

• Learn and follow best practices for SQL development, database security, and performance optimization.
• Automating warehouse processes to reduce redundancy and improve data quality and operational efficiency.
• Lead database performance tuning initiatives for high-volume transactional systems, including order management, purchasing, inventory, and warehouse execution.

Qualifications

Knowledge, Skills, and Abilities

• Foundational knowledge of SQL and relational database concepts (on-prem and cloud).
• Understanding of tables, joins, views, indexes, stored procedures and basic query optimization.
• Familiarity with Microsoft SQL Server, SQL Server Mgmt Studio, Visual Studio Code (VSCode), Page Editor, and Advantage Architect.
• Demonstrated strong analytical/problem solving skills and ability to follow procedures and resolution exceptions.
• Familiarity with database tools such as SQL Management Studio; Integration Architecture, and best practices.
• Excellent written/verbal communication and interpersonal skills with strong sense of customer service.
• Strong organizational skills and ability to perform multiple tasks simultaneously, set priorities, and work in a team with diverse cultural backgrounds.
• Strong familiarity with agile software development practices and tools.

• Demonstrated ability to design and document software solutions.
• Team player who is also able to work independently and handle conflicting priorities while maintaining consistent, quality performance standards.
• Ability to manage multiple tasks within tight deadlines and prioritize effectively, while delivering high-quality work.
• Solution oriented with a high sense of quality, attention to detail, accuracy, efficiency, and meeting tight deadlines.

Education and Experience

• Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, or a related field is preferred. Equivalent combinations of technical training, internship experience, or demonstrated project work may also be considered.
• For entry-level candidates, certifications may help demonstrate foundational knowledge. Coursework or exposure in SQL, relational databases, reporting, systems analysis, supply chain systems, or business applications is beneficial.