Note: The job is a remote job and is open to candidates in USA. Longbow Advantage's Rebus platform provides real-time data and consulting services for warehouse operations. The Systems Analyst will design and maintain metrics, dashboards, and data pipelines, analyze and troubleshoot client data, configure solutions, and support quality assurance, documentation, training, and implementation of warehouse technology solutions.
Responsibilities
- Design and implement metrics and dashboards based on client requirements, leading configuration end to end
- Build data extractions through data mining and analysis; write, optimize, and troubleshoot SQL queries across relational (SQL Server, Oracle, MySQL) and NoSQL (e.g., MongoDB) systems
- Configure client solutions and lead quality assurance to ensure implementations meet requirements and drive user adoption
- Participate in peer review of queries, metrics, and visualizations; give feedback and maintain clear documentation
- Troubleshoot data issues and resolve architecture problems across relational and non-relational databases
- Provide technical training to clients as needed
- Maintain the team's code repository, including documentation of customer setups, metric design, and SQL development
- Retrieve, clean, and manage client data throughout implementation
- Collaborate with team members to scope and implement client requirements
- Comply with Rebus SOC2 policies and practices
Skills
- Bachelor's degree in Computer Science, Business Analytics, or a related field
- 3+ years of experience with SQL Server, Oracle, or MySQL
- Experience with MongoDB (aggregation pipeline) or another NoSQL database
- Experience working with APIs
- Knowledge of at least one major supply chain/WMS platform (Blue Yonder/JDA, HighJump, Manhattan, SAP, etc.)
- Knowledge of supply chain and distribution/warehousing processes
- Experience using AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, Claude) to speed up SQL writing, debugging, and documentation
- Comfortable working in both Windows and UNIX environments, and with the Microsoft Office suite
- Strong problem-solving and analytical skills, with the ability to quickly translate ambiguous requirements into design and implementation
- Self-starter who can work independently, multitask, and stay effective under pressure with flexible hours/shifts
- Strong written and spoken English
- Genuine passion for customer success
- Up to 30% travel to customer sites
- This role is Remote in the United States
- We are not able to assist with relocation or work permit applications for this role
- Nice to have: experience building or configuring automation workflows that incorporate AI/LLM tools for data extraction, cleansing, or documentation
Benefits
- Supportive work environment
- Work/life balance
- 4-weeks of paid vacation
- 6 paid sick days, 2 paid personal days per year
- Excellent health and dental benefits, eligible as of your first day!
- Group RRSP/401k Matching
- Work from Home
Company Overview