What are the responsibilities and job description for the WMS and SQL Applications Analyst position at PositecUSA?
The WMS & SQL Analyst is responsible for maintaining, configuring, and optimizing the warehouse management system, SQL databases in an effort to support efficient distribution operations and order to cash processes.
The analyst will work to support data integrations, analysis and reporting as well as to identify business requirements. This role combines system administration with hands-on data analysis, leveraging SQL Server to troubleshoot issues, maintain data integrity, and drive operational insights.
This role works closely with warehouse, IT, and supply chain teams to ensure system accuracy, troubleshoot issues, and implement process improvements.
The ideal candidate will have experience with customer data analysis, WMS software, warehouse operations, Order to Cash processes and SQL server database maintenance.
Primary Responsibilities:
- Understand business needs and objectives, and how they relate to the use of WMS and SQL Server.
- Administer and support the WMS, including user setup, permissions, and configuration
- Write, optimize, and maintain SQL Server queries, stored procedures, and reports to support operations
- Strong understanding of warehouse operations (receiving, picking, shipping, cycle counts, physical inventory)
- Troubleshoot system and inventory issues using both WMS tools and direct database analysis
- Investigate and resolve data discrepancies (inventory, transactions, order flows) at the database level
- Maintain item, location, and inventory master data integrity
- Monitor system performance and identify opportunities for optimization using SQL-based insights
- Support integrations between WMS and ERP systems, SQL Server and ETL tools including data validation and error handling
- Assist with system upgrades, testing, and data validation
- Manage projects related to the implementation, upgrade, or customization of business applications.
- Stay up to date on new technology, systems features and functionality, and how it can be leveraged to meet business needs.
Education and Experience:
- Bachelor’s degree in business, computer science, or related field
Benefits: You can count on our standard healthcare benefits, including medical, dental, and vision coverage, to keep you and your loved ones healthy.
Work/Life Balance: We get it— finding work-life balance is key. You'll have the option to work from home one day a week, which can help you better balance your professional and personal life.
Education Assistance: Positec is passionate about helping employees reach their full potential. We offer assistance with degree and certification programs to empower your career growth and development.
Professional Development: We promote ongoing learning and growth. Our support includes covering the costs of conferences and webinars that match professional interests.
Disability Coverage: Your well-being is our priority. We provide disability coverage to give you peace of mind during unexpected challenges.