Job descriptionClient: Ministry of Public and Business Service Delivery and Procurement
Work Location: 222 Jarvis St, Toronto, Ontario, Onsite
Estimated Start Date: 2026-05-04
Estimated End Date: 2027-10-05
Business Days: 476
Extension: Probable after the initial mandate
Hours per day: 7.25 hours per day (8:00‑5:00 PM weekdays)
Security Level: No Clearance Required
Role Overview
Analysis of business requirement documents and liaison with clients.
Facilitating IT development, design, construction, testing, promotion, implementation of web-based/n-tier, cloud-based and mainframe applications.
Define standards for the integration and governance of enterprise data.
Design metadata management programs and scripts.
Define and evaluate conceptual, logical, and physical BI solution architectures.
Design healthcare business information structures (cubes, dimensions, facts, tables, etc.).
Perform data quality assessments, data transformation, and data cleansing.
Develop test scripts and perform testing of BI solutions.
Responsible for Java based development utilizing a combination of WebSphere, JDBC, Oracle, DB2, DataPower and associated Web technologies including JavaScript and JSP.
Responsible for integration of Open‑Source Software (OSS) products into new and existing systems.
Creation and walk‑through of Systems Response documents, Technical Specifications, Application Inventory, and Implementation Plans.
Preparation of test plans, test data, and unit‑testing of programs.
Preparation of implementation plans and promotion of programs.
System Support/Documentation.
As assigned, response to client queries and troubleshooting of production incidents.
Conduct/participate in design walkthroughs as well as test case and test results walkthroughs.
Support testing of the changes by other team members.
Provide recommendations to the Project Manager as to the acceptance or rejection of any changed system components.
Weekly reporting on status, progress, and key issues/concerns as directed by the Project Lead or Sr. Project Manager.
Transfer skills and knowledge to selected OPS staff.
The resource may be required to do similar work related to the role, for other initiatives within PRS, as directed by the manager.
Experience and Skill Set Requirements Public Sector Experience (5%)
Experience working in the public sector on a mid‑tier cloud and/or legacy platform.
Technical Skills (50%)
5+ years of business intelligence experience.
5+ years of Cognos experience.
5+ years in Framework Manager and Report Studio.
5+ years in Active Reports, Transformer and dashboarding.
5+ years in Report Studio (including being a trainer/mentor).
3+ years in Metrics Studio.
5 years data analysis experience.
IBM Certified Designer – Cognos 11.2.1 BI Reports.
IBM Certified Developer – Cognos 11.2.1 BI Metadata Models.
IBM Certified Administrator – Cognos 11.2.1 BI.
Experience facilitating workshops with diverse groups of stakeholders (technical, clinical, executive).
Experience evaluating design options to support system implementation.
Preparation of automated deployment builds (Jenkins).
Experience in structured, agile and DevOps methodologies for development, design, implementation, and maintenance of applications.
Experience with one or more platforms, including operating systems, database technology, communication protocols, middleware, and gateways.
Experience developing or maintaining large scale IT systems, including high‑volume public facing programs.
Development and design of new programs or enhancements to existing ones.
Integration of service APIs and micro‑services to existing or new web services.
Ability to understand and analyze business requirements, and design structured programs that efficiently satisfy these requirements.
Ability to write programs that are modular, well‑structured, and easy to maintain.
Demonstrated success writing system design and implementation documents.
Experience with, and understanding of, relational databases (DB2, Oracle, MS‑SQL).
Preparation of test plans, test data, and unit‑testing of programs.
Preparation of implementation plans and promotion of modules.
Participation in business requirements walkthroughs.
Conduct/participate in design walkthroughs.
Conduct/participate in testing walkthroughs.
Analytical Skills (30%)
Analysis of business requirement documents and liaison with clients.
Experience adopting and adhering to unified IT project management methodologies (waterfall, agile, and DevOps), enterprise architecture and gating frameworks, and standard systems development methodologies.
Respond to client queries and troubleshoot production incidents with proven and demonstrable analytical experience.
Communications Skills (15%)
Strong verbal and written communication skills.
Strong interpersonal and negotiation skills.
Strong consulting skills to engage with all stakeholders.
Demonstrated teamwork and meeting deadlines.
Demonstrated experience reporting status, progress, and key issues/concerns to project managers and leads.
#J-18808-Ljbffr