Analyste Des Systèmes D'affaires (BSA) / Business Systems Analyst (BSA)

TEKsystems; Montreal; Remote; CAD 116,000 - 194,000; Full time

Benefits offered by this job

Work from Home

4 weeks paid vacation

6 paid sick days

2 paid personal days

Health and dental benefits

RRSP/401k match

Work/life balance

Job summary

Rebus is seeking a Systems Analyst to join our end-to-end warehousing strategy team. You will work directly with client data: writing and optimizing SQL, configuring solutions, and troubleshooting across relational and non-relational systems, to turn raw data into decisions clients can act on.

The role involves designing metrics and dashboards, building data extractions, and collaborating to scope and implement client requirements. Remote in Canada with up to 30% travel.

Qualifications

• 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.

Responsibilities

• Write and optimize SQL; configure solutions; troubleshoot across relational and non-relational systems to turn raw data into decisions.
• Design and implement metrics and dashboards based on client requirements; build data extractions.
• Provide technical training to clients and maintain documentation; ensure QA and user adoption.

Skills

SQL

NoSQL

APIs

AI tools

English

Education

Bachelor's degree

Tools

MongoDB

Job description

CA$65.00 hourly

Permanent

Full-time

Full-time

CA$116,300.00–CA$193,800.00 yearly

Full-time

Full-time

Full-time +1

CA$80.00 hourly

Full-time +1

Systems Analyst Rebus is an end-to-end warehousing strategy company that uses real-time data to manage people, processes, and warehouses through The Rebus® Platform and WMS consulting services purpose-built to expand and enhance warehouse technologies.

We take a holistic approach to warehousing strategy, understanding that technology is only one piece in the solution process.

Our warehouse experts work with customers to understand challenges and goals, developing a recommendation that’s aligned to the customer’s business objectives and supply chain initiatives.

What to expect!

1. You'll work directly with client data: writing and optimizing SQL, configuring solutions, and troubleshooting across relational and non-relational systems, to turn raw data into decisions clients can act on.
2. Design and implement metrics and dashboards based on client requirements, leading configuration end to end Build data extractions through data mining and analysis.
3. Write, optimize, and troubleshoot SQL queries across relational (SQL Server, Oracle, MySQL) and NoSQL (e.g., MongoDB) systems.
4. Configure client solutions and lead quality assurance to ensure implementations meet requirements and drive user adoption.
5. Participate in peer review of queries, metrics, and visualizations; give feedback and maintain clear documentation.
6. Troubleshoot data issues and resolve architecture problems across relational and non-relational databases.
7. Provide technical training to clients as needed.
8. Maintain the team's code repository, including documentation of customer setups, metric design, and SQL development.
9. Retrieve, clean, and manage client data throughout implementation.
10. Collaborate with team members to scope and implement client requirements.
11. Comply with Rebus SOC2 policies and practices.

This role is Remote in Canada.

What You’ll Bring…

• 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
• Nice to have: experience building or configuring automation workflows that incorporate AI/LLM tools for data extraction, cleansing, or 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

Why Join Rebus?

• Supportive work environment
• Work/life balance
• Competitive Salary
• 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

Rebus is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

We are not able to assist with relocation or work permit applications for this role.

All your information will be kept confidential according to EEO guidelines.