RQ11244 - Specialized IT Consultant - Senior

The Modernized Investigation Case Management System went Live in September 2025. Further enhancements/refinements are being made to the Modernized Investigation Case Management System Application subsequent to Go Live as per client needs.

Major scope of this enhancement is the development of APIs to handle both inbound and outbound data flowing between ICMS and CCLS. Data includes details of inbound referrals, tombstone information of the Licensee being referred in, and outbound results of the investigation (if any) being returned to CCLS. Including the previewing and publication of enforcement actions (EAs) taken as a result of the investigation.

Deliverables  to be provided by the Resource include the following:

Analysis

• Analyze Business Requirements to identify gaps along with recommended solution.
  


• Update/Create Functional Design Documentation for the Solution
  


• Update/Create Technical Design Documentation for the Solution
  

IT Solutions Enhancement / Sustainment

• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Case Management System
  


• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Data Activity and Auditing Tool
  

Systems Integration

• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Integration with OPS Service(s) & Other Systems
  


• Development of APIs to handle both inbound and outbound data flowing between ICMS and CCLS.
  

Testing and Quality Assurance (QA)

• Contribute to the Quality Assurance Activities
  

Implementation

• Collaborate and Coordinate with all Project Stakeholders involved to ensure smooth and timely completion of Activities & Deliverables
  


• Ensuring Compliance with
  


• Accessibility for Ontarians with Disabilities Act (AODA)
  


• Ontario Digital Service Design Guidelines
  


• OPS Security Directive (GO-ITS 25.0 General Security Requirements)
  

Systems Deployment Operations and Management

• Provide Packaging, Deployment and Migration Strategy for all Cloud Based Environment(s)

Knowledge Management

• Conduct Knowledge Transfer Session(s) for the CSC Internal Project Team
  


• All Other Tasks as assigned by the Cluster Manager, Project Manager & Technical Lead.
  


• Work Location is 3rd Floor, 777 Bay Street, Toronto, ON
  

Requirements

Experience and Skill Set Requirements

The skills and competencies required for the assignment include:70%

A. More than 8 years of experience with technical hands-on solutions development, configuration

B. Experience with the following Technologies on Microsoft Cloud (MS):

• MS Dynamics 365 CRM
  


• MS Power App Flows
  


• MS Power Automate
  


• MS Power Pages
  


• MS Azure Services 
  


• MS Azure Attachment Storage
  


• MS Azure Active Directory
  


• MS Azure DevOps
  


• MS Azure KeyVault
  


• MS Azure API Management
  


• MS Logic Apps
  


• MS Power BI
  

C. Hands-on experience in architecting, designing and implementing case management system by using Microsoft dynamic CRM 365 on cloud, Azure, Azure AD, Power, Power App Flows and Power Platform technology.

D. Hands-on Experience in designing, developing, integrating and implementation of Azure Storage for Attachment Management with MS Dynamics 365 on cloud.

E. Hands-on Experience in Designing, Configuring and Implementation of Case Management System , Including experience with:

• User Access and Profile Management
  


• Role Based Data Access Control
  


• Authentication and Authorization Integration
  


• Document Management
  

F. Hands-on Experience in designing, developing Azure Logic Apps/Function Apps

G. Hands-on Experience in designing, developing Power BI Dashboard and Reports.

H. Knowledge of and Experience with Accessibility for Ontarians with OPS Digital Accessibility Standard (ODAS) Testing compliance guidelines.

I. Experience with end-to-end integration of Third-Party / OPS Identity and Access Management (IAM) provider, security, authentication, and encryption tools / services.

30%

J. Strong knowledge of and experience with Testing and Quality Assurance Methodologies and best practices.

K. Strong ability to work under pressure, work with aggressive timelines and be adaptive to change.

L. Superior verbal and written communication skills.

M. Ability to develop and present new ideas and conceptualize new approaches and solutions.

N. Excellent interpersonal relations and demonstrated ability to work with others effectively in teams.

0. Demonstrated ability to work with functional and technical teams.

P. Demonstrated experience with facilitating workshops and meetings.

Q. Demonstrated ability to participate in a large team and work closely with other individual team members.

R. Demonstrated experience with OPS Quality Assurance Activities.

Must Have:

More than 8 years of experience with technical hands-on solutions development, configuration

Experience with the following Technologies on Microsoft Cloud (MS):

• MS Dynamics 365 CRM
  


• MS Power App Flows
  


• MS Power Automate
  


• MS Power Pages
  


• MS Azure Services 
  


• MS Azure Attachment Storage
  


• MS Azure Active Directory
  


• MS Azure DevOps
  


• MS Azure KeyVault
  


• MS Azure API Management
  


• MS Logic Apps
  


• MS Power BI
  

Hands-on experience in architecting, designing and implementing case management system by using Microsoft dynamic CRM 365 on cloud, Azure, Azure AD, Power, Power App Flows and Power Platform technology.

Hands-on Experience in designing, developing, integrating and implementation of Azure Storage for Attachment Management with MS Dynamics 365 on cloud.

Hands-on Experience in Designing, Configuring and Implementation of Case Management System , Including experience with:

• User Access and Profile Management
  


• Role Based Data Access Control
  


• Authentication and Authorization Integration
  


• Document Management
  

Hands-on Experience in designing, developing Azure Logic Apps/Function Apps

Hands-on Experience in designing, developing Power BI Dashboard and Reports.

Knowledge of and Experience with Accessibility for Ontarians with OPS Digital Accessibility Standard (ODAS) Testing compliance guidelines.

Experience with end-to-end integration of Third-Party / OPS Identity and Access Management (IAM) provider, security, authentication, and encryption tools / services.

Nice to Have:

• Excellent interpersonal relations and demonstrated ability to work with others effectively in teams.