RQ09208 - Specialized IT Consultant - Senior

Rubicon Path; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading IT consulting firm is seeking a Senior Specialized IT Consultant in Toronto, Ontario. The role involves enhancing and sustaining the ICMS application, analyzing business requirements, and implementing cloud-based solutions using technologies like Microsoft Dynamics 365 and Azure. The ideal candidate will have over 8 years of experience in technical solutions development, with strong skills in configuration, ETL, and quality assurance processes. This position provides significant opportunities for contributing to safety standards in childcare administration.

Qualifications

• More than 8 years of experience with technical hands-on solutions development.
• Experience with Microsoft Cloud technologies including MS Logic Apps.
• Hands-on experience in architecting and implementing case management systems.

Responsibilities

• Analyze business requirements and recommend solutions.
• Contribute to quality assurance activities and collaborate with stakeholders.
• Provide packaging, deployment, and migration strategies for cloud environments.

Skills

Technical hands-on solutions development

Configuration

MS Logic Apps

Microsoft Dynamic CRM 365

Azure

Power BI Dashboard and Reports

ETL

Testing and Quality Assurance

Communication

Interpersonal relations

Job description

About the job RQ09208 - Specialized IT Consultant - Senior

The ICMS application is specifically built to enhance regulatory enforcement oversight concerning both licensed and unlicensed childcare providers. It accurately tracks and monitors every aspect of investigations such as intake, inspection, investigation, prosecution, and trial.

A modernization initiative was undertaken in line with the Governments Digital First Agenda to deliver simpler, faster and better services. This will significantly improve the administration of licensed and unlicensed childcares. This initiative will be a key step towards improving safety standards in childcare facilities, covering regulated and unregulated settings throughout Ontario.

The investigation details for both licensed and unlicensed care providers be stored in an electronic database, offering immediate visibility into ongoing cases. This will continue to facilitate proactive decision-making and enables quicker responses to critical issues encountered in the field.

The ICMS application undergoes regular enhancements & sustainment which includes sustaining the application, providing solutions for enhancements and remediating applications defects.

Deliverables

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

Architecture Design

• Update/Create Architecture Artefacts (Business Architecture, Logical Architecture & Physical Architecture Artefacts)
• Update/Create Functional Design Documentation for the Solution
• Update/Create Technical Design Documentation for the Solution
• Configuration and Setup Cloud Based Environment(s) as required

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 Mobile Inspection Tool developed based on MS Dynamics 365 Field Services App
• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Reporting Tool based on MS Power BI
• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Reusable Administrative Components
• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Data Activity and Auditing Tool
• Selecting, Preparing, Extracting, Transforming and Loading data from source to target
• Updating of Data Migration Documentation (Script Design & Data Mapping)
• Design, Configure and Implement Enhancement(s) / Remediate Defects for the Integration with OPS Service(s)

Testing and Quality Assurance (QA)

• Contribute to the Quality Assurance Activities
• 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)
• 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)
• 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

SkillsExperience and Skill Set Requirements

70%

1. A. More than 8 years of experience with technical hands‑on solutions development, configuration
2. B. Experience with the following Technologies on Microsoft Cloud (MS):
3. MS Logic Apps
4. 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.
5. D. Hands‑on Experience in designing, developing, integrating and implementation of Azure Storage for Attachment Management with MS Dynamics 365 on cloud.
6. E. Hands‑on Experience in Designing, Configuring and Implementation of Case Management System , Including experience with:
7. User Access and Profile Management
8. Role Based Data Access Control
9. Authentication and Authorization Integration
10. G. Demonstrated experience with Kingsway Software for Data Migration from Oracle DB to MS Dynamics 365 Data Verse & Azure Blob Storage. Hands‑on Experience with ETL
11. H. Hands‑on Experience in designing, developing Power BI Dashboard and Reports.
12. I. Knowledge of and Experience with Accessibility for Ontarians with OPS Digital Accessibility Standard (ODAS) Testing compliance guidelines.
13. J. Experience with end‑to‑end integration of Third‑Party / OPS Identity and Access Management (IAM) provider, security, authentication, and encryption tools / services.
14. K. Strong knowledge of and experience with Testing and Quality Assurance Methodologies and best practices.
15. L. Strong ability to work under pressure, work with aggressive timelines and be adaptive to change.
16. M. Superior verbal and written communication skills.
17. N. Ability to develop and present new ideas and conceptualize new approaches and solutions.
18. O. Excellent interpersonal relations and demonstrated ability to work with others effectively in teams.
19. P. Demonstrated ability to work with functional and technical teams.
20. Q. Demonstrated experience with facilitating workshops and meetings.
21. R. Demonstrated ability to participate in a large team and work closely with other individual team members.
22. S. Demonstrated experience with OPS Quality Assurance Activities.

30%

MUST HAVES

1. B. Experience with the following Technologies on Microsoft Cloud (MS):
2. MS Logic Apps
3. 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.
4. G. Demonstrated experience with Kingsway Software for Data Migration from Oracle DB to MS Dynamics 365 Data Verse & Azure Blob Storage. Hands‑on Experience with ETL
5. H. Hands‑on Experience in designing, developing Power BI Dashboard and Reports