Closed listing
Junior Systems Optimization Analyst
- Scarborough, ON, Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
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
Technical Requirements
Core Tools & Technologies:
Programming & Development:
Emerging Technologies:
Soft Skills & Mindset
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
- 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
More about this job
Responsibilities
The role focuses on managing data entry and reporting workflows while designing automated operational processes to improve efficiency. The analyst will troubleshoot system issues and collaborate cross-functionally to translate business needs into scalable technical solutions.
Requirements
Candidates need proficiency in the Microsoft Power Platform, SQL, and VBA, with working knowledge of C# or Python. A systems-thinking mindset and the ability to apply AI tools to optimize business workflows are essential.
Skills
- MS Access VBA
- SQL
- Power BI
- Power Automate
- Power Apps
- C#
- Python
- Systems Thinking
- Data Analysis
- Process Automation
- DAX
- SOP Documentation
- AI Tools
- LLMs
- Reporting Frameworks
- Troubleshooting
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
- Consulting
Keywords
- MS Access
- VBA
- SQL
- Power BI
- DAX
- Power Automate
- Power Apps
- C#
- Python
- Replit
- AI
- LLMs
- Automation Agents
- SharePoint
- Zapier
- Data Pipelines
- SOP
- Systems Optimization
- Performance Reporting
- Data Integrity
- Business Metrics
- Rapid Development
- Process Improvement
- Scalability
- Operational Tools