Junior Systems Optimization Analyst

Scarborough, ON, Canada

Full Time

Mid Level

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 for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

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

What is your expected salary (annual or hourly)?*

Which of the following have you used in a practical setting?* SQL (writing queries)Power BI (building dashboards, DAX)Power Automate (flows)Power AppsMS Access / VBAPython or C#None of the above

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?*

Human Check*

Submit Application