Junior Systems Optimization Analyst

Warehousing & Distribution•Scarborough, ON

48d

About The Position

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.

Requirements

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)
C# and/or Python (working knowledge)
Experience with rapid development tools (e.g., Replit or similar)
Practical understanding of AI tools, LLMs, and automation agents
Ability to identify opportunities to apply AI to improve workflows
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

Nice To Haves

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

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