Warehousing & Distribution

Junior Systems Optimization Analyst

Scarborough, ON, Canada - Full Time

Role Summary
We are looking for a Junior Systems Optimization Analyst who is early in their career but ready to take on high ownership and real impact.
This role sits at the intersection of systems, operations, and data, and is ideal for someone who enjoys solving real business problems—not just writing code in isolation. You will work closely with cross-functional teams to understand how the business operates end-to-end, identify gaps, and develop solutions that improve efficiency, accuracy, and scalability.
This is not a siloed development role. Success in this position requires strong systems thinking, curiosity about operations, and the ability to translate business needs into practical, scalable solutions.

Key Responsibilities
  • Manage and support data entry and reporting workflows across operational systems
  • Analyze and evaluate existing reporting systems, data pipelines, and workflows
  • Research, design, configure, and maintain automated reporting and operational processes
  • Monitor data integrity and system outputs, ensuring accuracy and reliability
  • Troubleshoot system issues and implement sustainable fixes—not just quick patches
  • Identify gaps in workflows and recommend process and system enhancements
  • Assist in building structured performance reporting frameworks tied to business metrics
  • Develop and maintain clear SOPs and documentation for systems and processes
  • Support ongoing maintenance, updates, and improvements of internal tools
  • Collaborate cross-functionally to understand needs and deliver solutions wholistically
  • Maintain strict confidentiality and integrity of data and systems

Technical Requirements

Core Tools & Technologies:
  • MS Access VBA (RMA system support)
  • SQL (development, querying, and automation scripts)
  • Power BI (DAX, dashboards, reporting)
  • Power Automate (workflows integrating SharePoint and SQL)
  • Power Apps (operational tools such as pick/pack systems)

Programming & Development:
  • C# and/or Python (working knowledge)
  • Experience with rapid development tools (e.g., Replit or similar)

Emerging Technologies:
  • Practical understanding of AI tools, LLMs, and automation agents
  • Ability to identify opportunities to apply AI to improve workflows

Soft Skills & Mindset
  • Systems thinker: Able to see how processes connect across teams—not just individual tasks
  • Business-aware: Takes time to understand how the company operates before building solutions
  • Data-driven: Uses data to validate assumptions and guide decisions
  • Detail-oriented: Strong focus on accuracy, consistency, and data integrity
  • Ownership mindset: Takes responsibility for outcomes, not just assigned tasks
  • Problem solver: Focuses on root causes and scalable fixes rather than quick workarounds
  • User-focused: Builds solutions that work for the business—not just what is easiest to develop
  • Adaptable and action-oriented: Comfortable working in a fast-paced, evolving environment
  • Strong communicator: Able to document clearly and collaborate across technical and non-technical teams
     
Preferred Qualifications (Nice to Have)
  • Familiarity with SharePoint-based workflows and database integrations
  • Exposure to automation tools (Power Platform, Zapier, etc.) and AI implementations
  • Experience working in a lean or process-driven organization
  • Basic understanding of reporting frameworks and performance metrics
Apply: Junior Systems Optimization Analyst
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*
Resume*

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

This position pays $55,000-$65,000/year. Is this pay rate within the range you are looking for? **
Which of the following have you used in a practical setting?*
How would you rate your SQL ability?*
Which type of work do you prefer most?*
When you encounter a recurring issue in a system, what is your typical approach?*
Have you ever built an automated workflow (e.g., Power Automate, Zapier, scripts)?*
How have you used AI tools (e.g., ChatGPT, Copilot) in a work or project context?*
Briefly describe one process or workflow you improved.
What changed and what was the result? (3–5 sentences max)*
A report is manually created daily using exported data and Excel.
In 3–5 sentences, how would you improve this process?*
This is a fully on-site position located in Scarborough (Monday–Friday, 9am-6pm). Are you comfortable commuting daily and working on-site full-time?*
Human Check*