WMS Software Developer 1

## Overview 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 SOPs, 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. Lacey, WA onsite/hybrid options are available, with regular check-ins with the Director of ERP Systems and/or Senior WMS Software Developer. Occasional travel for site visits and remote site work may be required, as well as occasional after-hours support to resolve processing disruptions. Remote candidates outside Harbor HQ in Lacey, WA must be in the US Pacific Northwest time zone. ## Responsibilities A Level I WMS Developer has foundational skills and understanding of database design, query building, development and administration, but has less than 3 years of professional experience with warehouse operations or WMS systems. Responsibilities include maintaining database and WMS configurations, report and query building, and functional enhancements to processes that keep warehouse operations running efficiently. This position works 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. - Design, develop, optimize and deploy SQL solutions, stored procedures, functions, views, SQL Jobs, and data models that support warehouse operations. - Write and maintain 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. - Automate 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 - Foundational knowledge of SQL and relational database concepts, both on-premises and cloud. - Understanding of tables, joins, views, indexes, stored procedures and basic query optimization. - Familiarity with Microsoft SQL Server, SQL Server Management Studio, Visual Studio Code (VSCode), Page Editor, and Advantage Architect. - Demonstrated strong analytical and problem-solving skills and ability to follow procedures and resolve exceptions. - Familiarity with database tools such as SQL Management Studio and Integration Architecture, and related best practices. - Excellent written and verbal communication and interpersonal skills, with a 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 - A 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. ## Compensation and Benefits Compensation: $70,000–$85,000, depending on experience. Benefits include medical, dental, vision, life and disability insurance; a 401(k) retirement program with company match; vacation, sick time, floater, holidays, and more.