Systems Analyst Senior

MUST HAVES:

• Post-secondary education in Computer Science Information Systems or a related discipline
• Minimum 3 years of experience in systems analysis DevOps or QA roles
• Experience is reviewing and writing system change request for C# Oracle PL/SQL and framework environment
• Experience with CI/CD tools and scripting languages (e.g. Git Actions DevOps Test Planner)
• Demonstrated experience conducting system gap analysis and evaluating technology alternatives
• Strong analytical communication and documentation skills
• Excellent communication skills with the ability to clearly articulate technical concepts and decisions.
• Strong self learning skills with proven ability to troubleshoot perform root cause analysis and present solution options.
• Experience working with and supporting legacy systems.

Description

• The Systems Analyst supports the modernization and integration of the legacy AERO education system. This role combines systems analysis DevOps pipeline management release coordination quality assurance requirements development and strategic evaluation of legacy system gaps and alternatives. The incumbent will work cross-functional across the team to ensure digital solutions meet ministry objectives adhere towards Ontario Public Service (OPS) standards and support equitable accessible and secure education services for students educators and administrators.
• The Alternative Education Resources for Ontario (AERO) system is a custom-built legacy application that supports request management processing workflows catalog administration and production operations. Initially developed in 1995 AERO has undergone numerous enhancement cycles led by different development teams resulting in a heterogeneous codebase and varied architectural approaches.
• The current system comprises components written in C# Framework and VBScript. Over time inconsistencies have emerged between the Oracle database logic and the user interface layer increasing the complexity of maintenance troubleshooting and change implementation.
• To sustain operational service levels and meet the evolving needs of staff and stakeholders AERO requires ongoing updates to both its server infrastructure and application code. While preserving current functionality is essential the system also demands continuous evaluation of change requests risk assessments and proactive stability management.
• The application is maintained using Visual Studio 2019 and depends on legacy technologies including Framework 2.#. These dependencies must be addressed and modernized ahead of the Windows Server end-of-support deadline in January 2027 to ensure long-term compatibility and security compliance.
• The Systems Analyst will play a critical role in balancing operational support with strategic modernization. This includes managing change requests addressing system deficiencies evaluating the risks of proposed changes and identifying structured development options and modernization pathways to guide future enhancements and long-term sustainability.

Key Responsibilities

DevOps & Release Management

• Design implement and maintain CI/CD pipelines for C# and applications using Azure DevOps
• Manage Git branching strategies pull requests and release workflows across development staging and production environments
• Coordinate software releases in alignment with OPS change management protocols and enterprise architecture guidelines

Testing & Quality Assurance

• Collaborate with business analysis and developer to define test strategies and acceptance criteria for legacy and modernized systems
• Support automated and manual testing efforts; ensure compliance with OPS security accessibility and privacy standards
• Document and report defects; participate in defect triage and resolution

DevOps Test Planning

• Develop and maintain test plans integrated into CI/CD pipelines
• Define test coverage requirements for unit integration system and regression testing
• Monitor test execution within pipelines and analyze results to identify trends and bottlenecks
• Collaborate with developers and QA engineers to optimize test environments and data sets

Requirements Analysis & Development

• Lead requirements gathering sessions with ministry stakeholders and education partners
• Document detailed functional and non-functional requirements use cases and user stories
• Translate business needs into technical specifications compatible with C# Oracle and environments
• Maintain requirements traceability and support stakeholder reviews and acceptance testing
• System Gap Analysis & Alternatives
• Conduct comprehensive gap analysis between legacy systems and proposed digital solutions
• Identify functional technical and operational limitations in current AERO system architecture
• Evaluate and compare system alternatives including commercial off-the-shelf (COTS) cloud-native and custom-built options
• Recommend modernization strategies that align with ministry goals OPS standards and long-term sustainability
• Prepare documentation and presentations to support decision-making and stakeholder engagement
• Legacy System Integration
• Analyze legacy system architecture and dependencies across ministry platforms
• Design integration strategies between legacy framework systems and modern platforms
• Recommend modernization approaches that preserve critical business logic and data integrity

General Skills:

• Provides specialized technical expertise in the overall analysis of the design and architecture of systems solutions.
• Ability to evaluate recommendations and ensures all recommended solutions for improvement are congruent with the project goals and objectives
• Identifies short and long-term project goals/objectives and as a senior technical expert defines and identifies program and service delivery requirements in support of the development and/or acquisition of client applications
• Leads the analysis development and documentation of design and architecture of systems solutions.
• Leads the development of testing integration and implementation of systems solutions into the clients applications
• Guides the feasibility studies and cost effective analyses of proposed client I&IT initiatives ensures all studies and analyses are documented
• Leads the technical aspects of projects related to the development and/or acquisition of a diverse range of client applications through all stages of the Systems Development Life Cycle (SDLC). This includes planning scheduling and estimating resources providing technical expertise co-ordination monitoring progress and providing management with project status updates
• Demonstrated experience gathering requirements translating business documents into technical specifications
• Experience leading development/support teams supporting multi-dimensional and relational databases and their applications for effective planning budgeting strategizing and forecasting procedures
• Demonstrated experience designing and developing complex applications utilizing relational and multi-dimensional databases
• Ability to provide implementation and post implementation support as required
• Oversees the research and evaluation of the technical components in the acquisition of software hardware technology systems and products
• Recommends and directs the measurement and improvement of tools techniques standards and performance criteria to control the quality of application development initiatives
• Provides coaching and direction to junior analysts throughout the project related to the development and/or acquisition of a diverse range of client applications through all stages of the Systems Development Life Cycle

Desirable Skills:

• Knowledge and experience in rapid application development (RAD) methodologies
• Knowledge and experience with middleware and gateways
• Knowledge and understanding of Information Management principles concepts policies and practices
• Experience with development/maintenance of documentation as per Methodology
• Good working knowledge of Dimensions and Facts
• Knowledge of multidimensional structures (cubes)
• Ability to gather review and provide feedback to business requirements

Experience and Skill Set Requirements

Mandatory

• Post-secondary education in Computer Science Information Systems or a related discipline
• Minimum 3 years of experience in systems analysis DevOps or QA roles
• Experience is reviewing and writing system change request for C# Oracle PL/SQL and framework environment
• Experience with CI/CD tools and scripting languages (e.g. Git Actions DevOps Test Planner)
• Demonstrated experience conducting system gap analysis and evaluating technology alternatives
• Knowledge of OPS IT standards SDLC Agile methodologies and release cycles
• Strong analytical communication and documentation skills

Assets

• Experience working in a public sector or government environment
• Familiarity with Ontario education systems student information platforms or digital learning tools
• Development experience with C# Oracle PL/SQL and framework environment
• Certifications such as CBAP Microsoft Certified: Azure DevOps Engineer or Oracle Certified Professional
• General Systems Analyst with Quality Control experience
• Release and Environment Coordination
• Demonstrated experience with gathering documenting and analyzing the current business processes and requirements at the system and infrastructure level and identify gaps
• Demonstrated experience providing clarification to designers developers and testers at various stages of Software
• Demonstrated experience supporting change management processes within the agreed scope schedule and project expectations
• Development Life Cycle (SDLC) to ensure that any changes or enhancements are fully regression tested and validated
• Demonstrated experience documenting code changes as per existing documentation standards;
• Demonstrated experience performing unit testing of code
• Demonstrated experience working with design team to clarify suggest and recommend implementation approach
• Demonstrated experience working with testers to identify the source of defects and resolve issues
• Demonstrated experience performing daily tracking reporting and facilitating resolution of issues and risks for all project activities

Technical Skills

• Knowledge of platform (C# java CORE) in Visual Studio 2019 HTML CSS Jquery other emerging web technologies and deployment models to implement application enhancements as per design documents
• Knowledge of Oracle 11.x 12.x 19c database objects and scripting
• Knowledge of Crystal 2020 reports development
• Knowledge of Atlassian server installation and configuration (JIRA Confluence and related supporting application and plugins)
• Knowledge of Alfresco CMS server installation configuration and integration

QA Skills

• Demonstrated experience with documenting test scenarios testing results testing artifacts and tickets
• Demonstrated experience in writing test scripts test cases and test scenarios testing web applications and reporting defects
• Demonstrated experience with the use of various types of software testing and testing methodologies in manual and automated testing
• Demonstrated experience with testing tools such as JIRA testbed Quick Test pro v10.0 and HP quality Center to create automated test scripts
• Demonstrated experience identifying data quality issues

Communication Skills

• Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• Proven knowledge and experience in written and oral communication with a large number of stakeholders
• Participate in planning activities; complete all required change request assessment tasks; participate in release management activities
• Demonstrate ability to work with ambiguous and conflicting requirements and finding pragmatic solution which can be acceptable to all stakeholders

Evaluation Criteria - 100%

Relevant Experience - 20%

• Relevant work history aligns with job requirements and industry context.

Technical/Job-Specific Skills - 15%

• Required tools systems certifications and technical capabilities are demonstrated.

Education and Training - 10%

• Meets/Exceeds required education; relevant coursework; ongoing development

Resume Quality and Professionalism - 5%

• Clear layout; minimal errors; professional tone; logical structure

Achievement and Impact - 15%

• Quantified accomplishments and outcomes (metrics improvements efficiencies)

Soft Skills Indicators - 5%

• Communication teamwork initiative problem solving evidenced in descriptions

Cost - 30 %