Intermediate Systems Analyst

We are seeking an experienced Intermediate Systems Analyst to deliver technical expertise in systems analysis, solution design, and data modeling for complex enterprise applications. In this role, you will act as a key liaison between business stakeholders and technical teams, translating business needs into detailed technical specifications, architecture blueprints, and data models. Working across the full Systems Development Life Cycle (SDLC), you will leverage your expertise in conceptual, logical, and physical database modeling, SQL scripting, and object-oriented architectures (Java and Angular) to guide application development, coordinate testing and integration, and ensure high-quality, cost-effective solutions.

Location: Toronto, ON (Fully Onsite – 5 days/week required)

Duration: 4-month contract



Advantages
End-to-End Analysis: Lead system design and analysis from requirements elicitation through to final deployment.

Modern Full-Stack Scope: Work hands-on with Java, Angular, and multi-tier database architectures.

Direct Stakeholder Engagement: Drive collaboration between business clients, development teams, and architecture groups.

Central Location: Full-time onsite engagement in a dedicated Toronto office environment.



Responsibilities
Conduct end-to-end systems analysis, technical requirements gathering, and system design across all stages of the SDLC.

Author detailed technical design documents, system architecture artifacts, and functional specifications.

Develop, reverse-engineer, and maintain conceptual, logical, and physical data models, including Entity Relationship Diagrams (ERDs) and metadata reports.

Write, test, and optimize complex database SQL scripts to support application functionality and backend structures.

Collaborate with software development teams to guide implementation utilizing object-oriented programming languages, specifically Java and Angular frameworks.

Facilitate Joint Application Design (JAD) sessions, user interviews, and workshops to translate business requirements into technical system solutions.

Plan, coordinate, and execute system integration testing, manual functional testing, and User Acceptance Testing (UAT) with clients.

Develop comprehensive QA artifacts including test plans, test cases, and requirement traceability matrices.

Assist in evaluating architecture components, technical feasibility studies, and threat and risk assessment (TRA) documentation.

Provide implementation and post-implementation support, troubleshooting technical issues across multi-tier environments.



Qualifications
Systems Analysis & Design: 5+ years of dedicated system analysis and design experience, preferably in a large, complex business environment (Strictly Required).

Technical Documentation: Demonstrated experience authoring detailed design documents, technical specifications, and system architecture blueprints (Strictly Required).

Database Modeling: Proven experience in conceptual, logical, and physical database modeling, including reverse-engineering physical data models and creating ERDs (Strictly Required).

Database SQL Scripting: Strong hands-on experience developing and executing database SQL scripts (Strictly Required).

Object-Oriented Programming (Java & Angular): Practical programming background with object-oriented languages, with mandatory experience in Java and Angular web frameworks (Strictly Required).

Communication & Facilitation: Excellent verbal communication and presentation skills with demonstrated ability to lead technical sessions and engage diverse stakeholders (Strictly Required).

Nice-to-Have Assets:
Prior systems analysis experience within the public sector or government enterprise environments.

Practical knowledge of Threat, Risk, Assessment (TRA) processes and documentation.

Familiarity with digital accessibility standards (AODA / WCAG 2.0 Level AA).

Experience working with multi-dimensional data models, cubes, and data warehouse concepts.



Summary
If you're interested in the "Intermediate Systems Analyst" role based in Toronto, we encourage you to apply online at www.randstad.ca.

Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.