Senior Systems Analyst - Warehouse Data & Dashboards

recrutement bee link; Montreal (administrative region); Remote; CAD 83,000 - 117,000; Full time

Benefits offered by this job

Work from Home

Competitive Salary

4 weeks paid vacation

6 sick days

2 personal days

Job summary

Rebus is seeking a Systems Analyst to design, build, and maintain metrics, dashboards, and data pipelines powering clients' warehouse operations. You will work with client data, write and optimize SQL across SQL Server, Oracle, MySQL, and NoSQL, and configure solutions while guiding QA to meet requirements and drive adoption.

The role focuses on remote work within Canada, with collaboration across teams to scope client needs and ensure SOC2 compliance.

Qualifications

• 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 to speed up SQL writing, debugging, and documentation.
• Nice to have: experience building automation workflows with AI/LLM tools.
• Comfortable in Windows and UNIX environments and with MS Office.
• Strong problem-solving and analytical skills; able to translate ambiguous requirements into design.
• Self-starter, independent, multitask, flexible hours.

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 and NoSQL systems.
• Configure client solutions and lead QA to ensure implementations meet requirements and drive user adoption.
• Participate in peer review of queries, metrics, and visualizations; maintain 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 and documentation of customer setups, metric design, and SQL development.
• Retrieve, clean, and manage client data throughout implementation.
• Collaborate with team to scope and implement client requirements.
• Comply with SOC2 policies and practices.

Skills

SQL

APIs

NoSQL

WMS knowledge

AI-assisted tooling

Windows/UNIX

English communication

Customer success

Data analysis

SQL optimization

Education

Bachelor's degree in Computer Science/Analytics

Tools

SQL Server

Oracle

MySQL

MongoDB

Job description

Rebus is seeking a Systems Analyst to design, build, and maintain metrics, dashboards, and data pipelines powering clients' warehouse operations. You will work with client data, write and optimize SQL across SQL Server, Oracle, MySQL, and NoSQL, and configure solutions while guiding QA to meet requirements and drive adoption.

The role focuses on remote work within Canada, with collaboration across teams to scope client needs and ensure SOC2 compliance.