Title: Senior Systems Analyst (RQ09620)

Location: Toronto, ON M5B 2H7 (Hybrid)

Contract

Organization: Government Services Integration Cluster

Ministry: Ministry of Public and Business Service Delivery and Procurement

Skills

Experience and Skill Set Requirements

• Have excellent knowledge of OO Systems Analysis & Design
• Expert knowledge designing and implementing Java/JEE, HTML5, CSS, Javascript, Angular based enterprise solutions.
• Experience designing solution with cloud platforms such as AWS, Azure or Google Cloud Platform;
• Knowledge of all cloud service models: SaaS, PaaS, and IaaS
• Experience performing S&D for Case Management, Document Management System (DMS), Large Systems of Record
• Proficiency in Security solutions including oAuth2, SAML, Multifactor Factor Authentication (MFA), B2C and B2B Authentication, API Keys, Single Sign On (SSO), Assure AD.
• Experience designing solution components including web and business logic modules, Micro Services, Business Reports
• Experience Analyzing/Designing Systems integration solutions including Session EJB, SOAP WS, RESTFul Web Services, SFTP server integrations.
• Experience performing Solution Gap Analysis, ETL Data transformation requirements, and Data Migration Plans.
• Have excellent DBA experience with database modeling including Conceptual, Logical, and Physical data models.
• Have extensive hands-on experience developing DB objects in Oracle, including Tables, Views, Sequences, Triggers, Store Procedures.
• Excellent practical experience writing and executing SQL queries analyzing
• Expert knowledge in reverse engineering Physical Data Models creating Entity
• Relationship Models (ERD) and Metadata Reports
• Experience with Performance metrics for a DATABASE using Apache JMETER and other Load Testing tools
• In-depth knowledge of Web Design principles
• Sound understanding and experience with AODA and knowledge of Accessibility compliance principles as presented in WCAG 2.0
• Hands-on experience in Quality Assurance preparing Test Plans, Test Cases and executing and monitoring unit, integration and UAT testing while working directly with clients
• Proven experience with JAD facilitation and interpretation of business needs into system design requirements.
• Extensive experience within all project cycles from Analysis, Design to Development,
• Testing and Implementation, including Project Management assignments
• Ability to participate in the TRA process and prepare appropriate documents
• Provide guidance to developers in the initial phases on the implementation of a solution.
• Experience with Figma, Balsamiq and other mock-up design tools
• Experience developing architecture artifacts including: Solution Requirements Document (SRD), Business Architecture Document (BAD), Information Architecture Document (IAD), Solution Architecture Document (SAD), Architecture review presentations; Prepare presentations for Corporate Architecture Committees
• Expertise developing Technology Options Analysis including qualitative and quantitative analysis.

Perform other project related activities as required

• Work independently and is also a Team player
• Excellent analytical and problem solving skills
• Excellent communication skills in both oral and written
• Experience in preparing technical presentations
• Consultant may be asked to work on additional projects/assignments

Desirable Skills:

Systems Analysis Experience - 40%

• 10+ years of System Analysis and Design experience, preferably in a large, complex business environment
• Expert knowledge in reverse engineering Physical Data Models creating Entity
• Relationship Models (ERD) and Metadata Reports
• Demonstrated experience within all project cycles from Analysis, Design to
• Development, Testing and Implementation
• Knowledge and experience related to TRA (Threat, Risk, Assessment) process and prepare appropriate documents
• Experience preparing architecture artifacts, including TRA artifacts

Business, Testing & Integration Experience - 20%

• 10+ years of Business Analysis experience including running JAD sessions, UAT and gathering requirements
• 10+ years of system testing, integration testing experience
• Demonstrated experience with system Integration experience including ability to understand different systems and pick up new technologies quickly
• Extensive experience in Quality Assurance preparing Test Plans, Test Cases and executing and monitoring unit, integration and UAT testing while working directly with clients
• Proven experience with requirement elicitation techniques such as User interviews, Workshops, JAD facilitation and interpretation of business needs into system design requirements.
• Manual system testing and integration testing experience including creating test cases and test plans

Public Sector experience - 5%

• Knowledge of GO-IT Standards(GO-ITS) and Enterprise Architecture within the RGDMS system

AODA Experience - 5%

• Hands on experience with AODA and knowledge of accessibility compliance principles as presented in WCAG 2.0, level AA

MUST HAVE:

• 10+ years of System Analysis and Design experience, preferably in a large, complex business environment
• Exp in delivery design document
• System architecture
• exp in database modeling (logical, physical and conceptual modeling)
• exp in developing in database SQL script
• exp in programing with object oriented programing languages - JAVA (required), Angular
• Strong Communication skills - Verbal and Presentation skills

All your information will be kept confidential according to EEO guidelines.