RQ11883 – Systems Analyst – Intermediate
- Toronto, ON, Canada
Internship
Applications open in a new tab.
Job details
- Job type
- Internship
- Apply by
- Posting language
- English
- Posted
Original job description
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11883
We are seeking an experienced Systems Analyst – Intermediate with strong expertise in Systems Analysis and Design, System Architecture, Database Modelling, SQL Development, and Object-Oriented Programming. The ideal candidate will have hands-on experience with Java (required), Angular, relational and multidimensional databases, technical documentation, system integration, and the Software Development Life Cycle (SDLC). The successful candidate will be responsible for leading technical analysis, designing system solutions, translating business requirements into technical specifications, coordinating development and testing activities, and ensuring the delivery of cost-effective I&IT solutions aligned with Ontario Public Service (OPS) standards and business objectives.
Role Snapshot
Responsibilities
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Monday, November 16, 2026, at 11:00 AM EST.
Mandatory Documents
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Additional Information
5 days per week onsite
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
We are seeking an experienced Systems Analyst – Intermediate with strong expertise in Systems Analysis and Design, System Architecture, Database Modelling, SQL Development, and Object-Oriented Programming. The ideal candidate will have hands-on experience with Java (required), Angular, relational and multidimensional databases, technical documentation, system integration, and the Software Development Life Cycle (SDLC). The successful candidate will be responsible for leading technical analysis, designing system solutions, translating business requirements into technical specifications, coordinating development and testing activities, and ensuring the delivery of cost-effective I&IT solutions aligned with Ontario Public Service (OPS) standards and business objectives.
Role Snapshot
- Job Title: RQ11883 – Systems Analyst – Intermediate
- Client: Ministry of Public and Business Service Delivery and Procurement
- Work Location: 20 Dundas Street West, Toronto, Ontario, M5G 2C2, Canada
- Work Arrangement: Onsite – 5 Days per Week
- Estimated Start Date: December 7, 2026
- Estimated End Date: March 31, 2027
- Business Days: 85.00
- Extension: Probable after the initial mandate
- Hours: 7.25 hours per day
- Security Level: No Clearance Required
- 5+ years of System Analysis and Design experience, preferably in a large, complex business environment.
- Experience preparing and delivering design documents.
- Strong knowledge of System Architecture.
- Experience in database modelling, including logical, physical, and conceptual modelling.
- Experience developing SQL scripts in databases.
- Experience programming with object-oriented programming languages:
- Java (Required)
- Angular
- Strong communication skills, including verbal communication and presentation skills.
Responsibilities
- Provide senior technical expertise, project leadership, and coordination of activities in the development, implementation, and maintenance of a diverse range of cost-effective I&IT solutions.
- Provide technical advice to clients and leverage OPS I&IT solutions and applications to meet program/service goals and objectives while ensuring efficiency.
- Provide specialized technical expertise in the overall analysis of the design and architecture of systems solutions.
- Evaluate recommendations and ensure all recommended solutions for improvement are congruent with project goals and objectives.
- Identify short-term and long-term project goals/objectives and, as a senior technical expert, define and identify program and service delivery requirements in support of the development and/or acquisition of client applications.
- Lead the analysis, development, and documentation of the design and architecture of systems solutions.
- Lead the development of testing, integration, and implementation of systems solutions into clients' applications.
- Guide feasibility studies and cost-effective analyses of proposed client I&IT initiatives and ensure all studies and analyses are documented.
- Lead 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 and coordination; monitoring progress; and providing management with project status updates.
- Demonstrate experience gathering requirements and translating business documents into technical specifications.
- Demonstrate experience leading development/support teams supporting multidimensional and relational databases and their applications for effective planning, budgeting, strategizing, and forecasting procedures.
- Demonstrate experience designing and developing complex applications utilizing relational and multidimensional databases.
- Provide implementation and post-implementation support as required.
- Oversee the research and evaluation of technical components in the acquisition of software, hardware, technology, systems, and products.
- Recommend and direct the measurement and improvement of tools, techniques, standards, and performance criteria to control the quality of application development initiatives.
- Provide 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.
- 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 and 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 on business requirements.
- Systems Analysis Experience – 40%
- 5+ years of System Analysis and Design experience, preferably in a large, complex business environment.
- Expert knowledge in reverse engineering Physical Data Models and creating Entity Relationship Models (ERD) and Metadata Reports.
- Demonstrated experience across all project cycles, from Analysis and Design to Development, Testing, and Implementation.
- Knowledge and experience related to the TRA (Threat, Risk, Assessment) process and preparation of appropriate documents.
- Experience preparing architecture artifacts, including TRA artifacts.
- Business, Testing & Integration Experience – 20%
- 5+ years of Business Analysis experience, including conducting JAD sessions, UAT, and gathering requirements.
- 5+ years of system testing and integration testing experience.
- Demonstrated experience with system integration, including the ability to understand different systems and quickly learn new technologies.
- Extensive experience in Quality Assurance, preparing Test Plans and 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.
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Monday, November 16, 2026, at 11:00 AM EST.
Mandatory Documents
- Updated Resume in Word format (Mandatory)
- References (Mandatory)
- Expected Hourly Rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Additional Information
5 days per week onsite
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
More about this job
Responsibilities
Lead technical analysis and design of system solutions, translating business requirements into technical specifications and coordinating development, testing, integration, and implementation. Provide technical leadership and advice throughout the SDLC, ensuring solutions meet client objectives, quality standards, and OPS requirements.
Requirements
Requires at least five years of systems analysis and design experience, including database modeling, SQL development, Java programming, architecture documentation, and work across the full project lifecycle. Also requires business analysis, requirements elicitation, system and integration testing, and strong communication skills; experience with OPS standards and AODA/WCAG accessibility is specified.
Skills
- Systems Analysis and Design
- System Architecture
- Database Modeling
- SQL Development
- Java
- Angular
- Object-Oriented Programming
- Requirements Gathering
- Technical Documentation
- System Integration
- Quality Assurance
- System Testing
- User Acceptance Testing
- Relational and Multidimensional Databases
- Accessibility Compliance
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Government & Public Sector
- Management & Leadership
Keywords
- Systems Analysis
- Systems Design
- System Architecture
- Database Modeling
- SQL
- Java
- Angular
- Object-Oriented Programming
- Relational Databases
- Multidimensional Databases
- Entity Relationship Diagrams
- Physical Data Models
- Metadata Reports
- Requirements Elicitation
- JAD Sessions
- User Acceptance Testing
- Integration Testing
- Quality Assurance
- Test Plans
- Test Cases
- System Integration
- Threat Risk Assessment
- GO-ITS Standards
- Enterprise Architecture
- AODA
- WCAG 2.0 Level AA
- Rapid Application Development
- Middleware
- Information Management