08/28/2025

Role: Project Manager/Leader RQ: RQ09648 Rate: $107/h inc Client: Ministry of Public and Business Service Delivery and Procurement Location: Onsite, 595 Bay Street, Toronto Duration: 208 business days, 7.25 hours per day Anticipated Start Date: Sept 2025 Description A Note on Assignment Type: This position is currently listed as "Onsite", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. ?These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Scope To provide integrated project management leadership and expertise on a large scale, highly complex, high profile and high-risk initiative that is enterprise wide. The role will be responsible for project management of workstreams, deliverables and milestones across multiple units.   To ensure accountability for the project’s centralized group of units and their successful full life cycle delivery. To ensure the project is delivered on time, effectively and efficiently. Project management in the preparation and implementation of long-term business, functional and technical capability roadmaps for both product and process evolution as a result of modernization projects. Provide and maintain a comprehensive project plan that considers and includes dependencies on other projects and initiatives across the Ministry and OPS. The project plan developed will be responsive to agile project delivery, while achieving day-to-day tracking of voluminous tasks, milestones, workstreams, complex risks and issues, while managing multiple intricate dependencies across a diverse, integrated project team whose resources are not directly reporting to a single entity. Deliver coordination and tracking of tasks, milestones, workstreams and complex risks and issues using modern and proven project management tools. The integrated project manager is required to work across all units to drive cohesion within the CDT project, including key stakeholders to maintain an overarching, integrated and robust project plan. Project Manager role to ensure tracking of activities and milestones specific to an IT vendor and their delivery of the digital justice solution. Assignment Deliverables Preparation and maintenance of an integrated, detailed project plan to deliver a digital and business transformation for Office of the Public Guardian and Trustee (OPGT). Preparation of weekly, bi-weekly, and ad-hoc project reporting to support the modernization and transformation initiative and presenting to internal and external stakeholders. Preparation and maintenance of a Project Plan that aligns to modernization and transformation initiative initiatives currently underway.   Risk and issues management. Skills Experience and Skill Set Requirements The start date is subject to change based on security clearances and contract signing timelines. Experience and Skillset Requirements Mandatory Requirements Certified Project Manager At least 8 years Project Management experience in delivering complex digital/I&IT projects using agile, waterfall and hybrid methodologies Proven experience with Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operation (F&O) and Azure DevOps Desired Skills and Experience Knowledge of Project Management, best practices, tools and organizational structures to support two-way communication with a large group of project partners. Technical, functional knowledge of project management tracking tools (i.e. MS project).   Ability to develop visually appealing products that can depict short, medium, and long term project milestones and timelines. Ability to proactively identify potential risk events and issues before they occur so that proper mitigating strategies can be developed. Articulates and prioritizes issues and risks at senior executive levels and recommends mitigation strategies for decision makers. Able to comprehend business process and technology to lead and facilitate discussions and feedback to prepare a transformation roadmap; Deliver high level options analysis and recommendations to management on workplans to ensure compliance to timelines and project goals; Assist in the detailed evaluation and development of workplans to remove or mitigate project delays, specifically due to dependencies.   Resumes Evaluation/Criteria: Criteria 1: Project Management, Leadership, and Skills - 60 Points Hands-on experience with functional testing in Microsoft Dynamics 365 Customer Engagement (CE) and specifically across Finance & Operation (F&O) modules Proficiency in using Azure DevOps (ADO) for defect tracking, test case management, and test execution workflows. Strong capability in designing, developing, and executing test cases, as well as analyzing test results to ensure alignment with business and functional requirements. Ability to perform in a large, complex organization, leading a cross-functional and diverse team of managers and professional staff to deliver results on time. Ability to develop, manage and implement a large-scale digital/I&IT project supporting both the technology implementation and business process transformation using multi-faceted strategies and tools that are comprehensive and effective in accomplishing project goals, milestones and outcomes. Ability to work and integrate with cross competency teams including (but not limited to) business, IT, infrastructure, vendors and 3rd party applications Demonstrated success leading a large-scale, complex digital and business transformation project, including working with executive and senior management to set objectives, secure consensus on approaches, execute delivery, and evaluate results. Ability to create and maintain an integrated project plan that aligns with other Ministry modernization initiatives Ability to prepare and provide status reports, briefing notes, and visually appealing communication products for all levels of project governance, as well as stakeholder forums.   Ability to exercise appropriate strategies related to change management, during all stages of projects – concept, definition, planning, implementation and close-out. Ability to manage the implementation activities and timelines associated with large, complex projects to coordinate I&IT, people and change management, and business process changes to support this large digital and business transformation.   Knowledge of and ability to use project management software and methodologies in a dynamic environment. Demonstrate analytical, problem-solving and decision-making skills Criteria 2: Risk and Issues Management - 15 Points Demonstrate experience in identifying potential organizational and project risks in advance and developing plans with the support of collaborative partner representatives to develop plans to remove or mitigate those risks. Demonstrate appropriate discretion in escalating risks and issues to Senior Leadership.   Ability to communicate risk and recommendations for mitigating strategies and ownership to be endorsed through project governance which includes multiple levels of executive leadership.   Ability to manage and support incidents that pose risk to the organization and project, including reputational.   Criteria 3: Communication and Stakeholder Management - 15 Points Demonstrate oral and written communication skills to conduct internal consultations, collaborate with senior management and various project leads, develop reports, proposals and associated communications regarding the project plan, risks and issues. Demonstrate networking and consultation skills to develop and maintain effective partnerships with project leads, senior management, and other stakeholders. Ability to lead and facilitate communications functions to connect a cross-functional and diverse range of partners, often with competing priorities, to deliver consistency in representation while driving consensus needed for delivery of project milestones on time.   Demonstrate presentation and reporting skills to provide reports, briefings, advice, strategies and recommendations. Demonstrate proficiency with different computer applications (MS office suite, Adobe, online engagement tools), to develop presentations of the project plan, risk, issues and other documents or topics as required.   Criteria 4: Project Management Best Practices - 10 Points Prior experience in Project Management delivery using agile, waterfall and hybrid methodologies.   Prior experience in complying with best practices, policies and procedures in a highly regulated and legislated environment.   Prior experience of quality assurance, demonstrated by the identification of standards and criteria to be set in each phase of the project life cycle for both the product and the process. Prior experience in making and meeting agreed to commitments with a constant eye for improvement.   Knowledge Transfer What needs to be KT Project Plans, Consultations and findings, project background documentation. Integrated project team membership and representation. Project specific Presentations, reports, status decks. To whom Team Members / Project Lead When 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc. ?This position is currently listed as "Onsite", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. ?These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Must have: Proven experience with Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operation (F&O) and Azure DevOps ·        At least 8 years Project Management experience in delivering complex digital/I&IT projects using agile, waterfall and hybrid methodologies ·        Certified Project Manager

08/26/2025

Role: Business Analyst RQ: RQ09672 Rate: $87/h inc Client: Ministry of Public and Business Service Delivery and Procurement Location: Hybrid,  21 College Street, Toronto Duration: 250 business days, 7.25 hours per day Anticipated Start Date: September 2025 Description A Note on Assignment Type: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Scope • Gather and document configuration, functional and non-functional requirements. • Collaborate with cross-functional teams to gather requirements and align configuration data with business needs. • Translation of business and functional requirements into system configuration specifications. • Work with various stakeholders to elicit business and reporting requirements for various legacy solutions and product streams. • Prepare questionnaire and conduct information sessions with the vendor to understand functional and configuration capabilities of the vendor solution. • Evaluate business processes, anticipate requirements, uncovering areas for improvement, • Analyze requirements and help project team in solution configuration and implementation. • Work with the project team in completing all relevant and required documentation in alignment with OPS standards. • Handle project co-ordination and end to end project management activities with the project team and with external stakeholders. • Work with the architecture team in completing project gating documentation and related gating requirements (e.g., business processes, program services, business requirements mapping, etc.) . • Perform quality assurance and user acceptance testing Assignment Deliverables ?• Conduct JAD sessions with stakeholders to create, review, document and validate any or all of the following for the Courts Digital Transformation: • Configuration Requirements • Reporting Requirements • Business Requirements • Functional Requirements • Non-Functional Requirements • System Specifications • Data Mapping • Journey Maps • Process Flow/Mapping and Modelling • Requirements Traceability Matrix • Options Analysis • Costing analysis • Business Case • Conduct, assess, evaluate and document stakeholder interests and business needs. • Create and validate use cases, user stories. • Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures. • Current State / GAP Analysis • Final specification and documentation of all reporting requirements for the solution • Final Logical/Physical Data Model, Data Dictionary and CRUD Matrix documentation • Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as needed. • Assist with system and user interface design and modifications (data & screen) as required. • Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output. • Assist testing team in the resolution of test defects. • Ensure alignment and adherence to Ministry processes and standards. • Research and document comparisons of existing Ontario Government, or COTS systems that will meet the client requirements. • The consultant resource will interface directly with the program area staff and management and is accountable for ensuring customer satisfaction related to the contracted work items. • Develop workplan and outline of effort to completion. • The consultant will provide a detailed list of all work/artifacts completed on the project. • Track project activities in the project plan, and requirements throughout the project. • Handle solution design activities with the development team, lead internal team reviews and negotiation with customer on design activities, design issues and design gaps. • Attend any meetings related to the resolution of any request as required. • Create Enterprise Architecture documentation (as required), Presentations (as required), Briefing Notes (as required), Status reports (as required) Skills Experience and Skill Set Requirements The start date is subject to change based on security clearances and contract signing timelines. Experience and Skillset Requirements Desired Skills and Experience • Create detailed specification documents, business analysis documents, user stories, business case. • Knowledge of courts business processes for criminal justice, family, and civil line of business • Hands on experience in implementing solutions for criminal justice, family, and civil court case management solutions. • Knowledge of native capabilities of the system that needs to provide the functionality of courts case management. • Hands on experience with documenting reporting requirements • Business Analysis experience at the specified level in large IT organizations, preferably within a Public Sector environment • Hands on experience in various project and product delivery methodologies such as Agile, Waterfall, Iterative Agile, Product management Mandatory Requirements • Knowledge of courts business processes for criminal justice, family, and civil lines of businesses • Hands on experience in implementing solutions for criminal justice, family and civil court case management solutions. • Knowledge of native capabilities of the system that needs to provide the functionality of courts case management. • Experience in structured methodologies for the design, development, implementation and maintenance of applications. • Excellent facilitation and presentation skills • Excellent analytical, problem-solving, and decision-making skills • Excellent verbal and written communication skills. • Highly developed interpersonal and negotiation skills • A team player with a track record for meeting deadlines • Proficiency with Microsoft suite including, Word, Excel, Visio, and PowerPoint • Experience with OPS I&IT Processes, Standards and artifacts. • Hands on experience in various project and product delivery methodologies such as: o Agile o Waterfall o Iterative Agile o Product management • Experience in using technical solution design and prototyping tools to assist in JAD and design sessions with stakeholders Resumes Evaluation/Criteria: Criteria 1: Technical Skills - 35 Points • Demonstrated experience with technical solution design and prototyping tools to facilitate JAD and design sessions. • Hands on experience working with DevOps for requirements tracking and defect management • Demonstrated experience in developing documentation towards production readiness such as support model, SLAs and checklists . • Demonstrated experience in working with technology, solution design, data, databases, applications and networking techniques, tools and practices. • Demonstrated experience with creating SQL queries for data analysis and solving data gaps. • Demonstrated experience with data mapping, documenting business rules and processes and developing business process maps • Working knowledge of system concepts and development methodologies to support business applications. • Demonstrated experience in defect identification and documentation using defect management tools. • Demonstrated experienced in system testing and user acceptance testing. • Hands on experience in various project and product delivery methodologies such as Agile, Waterfall, Iterative Agile, Product management Criteria 2: Business Analysis Skills - 30 Points • 8+ years’ experience in business analysis • Knowledge of courts business processes for criminal justice, family, and civil line of business • Hands on experience in implementing solutions for criminal justice, family and civil court case management solutions. • Demonstrated experience, both remotely as well as in-person, facilitating JAD sessions, conducting interviews, and facilitating workshops to elicit, review and confirm business requirements, business process re-engineering, business models, business rules and user interface design. • Demonstrated knowledge with the key BABOK concepts, tasks, techniques, and skills (e.g., business analysis planning and monitoring, elicitation, and collaboration). BABOK (Business Analysis Body of Knowledge) certification an asset. • Demonstrated experience in creating user stories/business requirements, personas, customer journey diagrams, business cases, fit-gap analysis, current state business diagrams, and other business requirements artefacts and testing documentation. • Demonstrated experience working on large case systems implementation. Previous experience working on an implementation of a COTS solution an asset. • Demonstrated experience in project co-ordination and project management activities. • Demonstrated experience reviewing and ensuring submitted documentation is complete and accurate. • Demonstrated experience documenting and analyzing existing business processes, metrics, and measures in order to recommend process improvement opportunities. • Demonstrated experience working collaboratively with the subject matter experts, managers, staff of business and other groups as required to identify issues and clarify business needs. • Demonstrated experience ensuring compliance with a defined change management process is followed for any change from agreed scope, schedule, or quality. • Demonstrated experience conducting research to identify industry best practices, as well as making process improvement recommendations based on findings. • Demonstrated analytical, problem-solving, and decision-making skills Criteria 3: Communication Skills - 30 Points • A team player with the ability to coordinate multiple project activities with competing priorities and strict deadlines. • Demonstrated experience in negotiating with business stakeholders on functional design issues and detailed solution design sessions, negotiating on issues for production. • Demonstrated experience establishing effective relationships with project stakeholders who are both technical and non-technical. • Demonstrated experience working with both the business users and IT team; bridging with the IT Project teams to ensure that solution align strategically with client goals, acting on behalf of the client to best communicate the business needs to IT solution teams. • Demonstrated experience completing work and achieving milestones within the assigned deadlines. • Demonstrated verbal and written communication skills; interpersonal and negotiation skills; consensus building skills, facilitation skills. • Demonstrated experience with formal deliverable approval processes. • Experience in documenting project status reports, project tracking, progress, issues and risks, and presenting to executives and other stakeholders Criteria 4: Public Sector Experience - 5 Points • Demonstrated experience working within an organization of equivalent size and complexity to the Ontario Public Service • Demonstrated experience in working in accordance with policies and procedures of Ontario Public Service would be an asset Knowledge Transfer What needs to be KT • Ensures knowledge transfer to internal staff – that is, upon leaving the project, the consultant will transfer over all information/research/documents to the client. • All related documentation about the application which will include, design, components, process flows, other documentation that was developed/ updated To whom Project Manager / Team members When 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle. This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Must haves: • Knowledge of courts business processes for criminal justice, family, and civil lines of businesses • Hands on experience in implementing solutions for criminal justice, family and civil court case management solutions. • Knowledge of native capabilities of the system that needs to provide the functionality of courts case management. • Experience in structured methodologies for the design, development, implementation and maintenance of applications. • Excellent facilitation and presentation skills • Excellent analytical, problem-solving, and decision-making skills • Excellent verbal and written communication skills. • Highly developed interpersonal and negotiation skills • A team player with a track record for meeting deadlines • Proficiency with Microsoft suite including, Word, Excel, Visio, and PowerPoint • Experience with OPS I&IT Processes, Standards and artifacts. • Hands on experience in various project and product delivery methodologies such as: o Agile o Waterfall o Iterative Agile o Product management • Experience in using technical solution design and prototyping tools to assist in JAD and design sessions with stakeholders

08/07/2025

Role: Systems Testing/QA Specialist RQ: RQ09617 Rate: $75/h inc Client: Ministry of Public and Business Service Delivery and Procurement Location: Hybrid, 40 St. Clair Ave. West, Toronto (2 days onsite, 3 days remote) Duration: 260 business days, 7.25 hours per day Anticipated Start Date: August 2025 Description To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis. Responsibilities Quality Lead is responsible for overseeing and managing the quality assurance (QA) processes for both manual and automated testing efforts. This role involves leading a team of QA engineers, developing and implementing testing strategies, and ensuring the delivery of high-quality software products. The ideal candidate will have extensive experience in both manual and automated testing, strong leadership skills, and a deep understanding of software development life cycles (SDLC) and QA methodologies. As a Test Lead you will Collaborate with product managers, product owners, and technical team to develop test strategies and test plans Plans and organizes testing efforts for large systems in Graphical User Interface (GUI) and non-Graphical User Interface (GUI) environments, including the execution of systems integration tests, specialized tests, and user acceptance testing (e.g., stress tests) Develop of test plans, test scripts and test cases and execute these against the various components. Design, develop, and maintain automated test scripts for functional, regression, and integration testing Use automation tools and frameworks such as Selenium, Appium, Katalon or similar to create robust and reusable test scripts. Provides advice on the testing strategy, test plans, the selection of testing tools, and the identification of resources required for testing. Assist with planning and creating test data as it relates to each test phase Executes quality assurance and testing activities for various types of testing such as integration testing, functional testing, regression testing, unit testing, load testing, performance testing and accessibility testing Plans and organizes testing efforts in both front-end and back-end application components/environments Communicate test results regularly through reports that summarize test completion and defects found Help with the implementation of the project technical testing strategy and methodology. This includes testing of integration points and interfaces and non-functional requirements (e.g. fail-over, component response times, data integrity, security) Evaluate test results against acceptance criteria to determine successful completion of the sprint increment Defines and measures acceptance criteria for test cases Record all defects/issues in the Cluster’s defect reporting tool (Jira), including detailed descriptions, screenshots, and steps to re-produce Participate in elicitation and business requirement workshop sessions, sprint reviews and/or walkthrough meetings Work with cross-functional teams to ensure quality throughout the agile / iterative solution development lifecycle Conducts post-release / post-implementation testing Supports clients with user acceptance testing (UAT) activities Creates traceability matrix to ensure testing outcomes align with business requirements Coordinate and facilitate regular defect review meetings with Business Analysts and Business stakeholders Provide testing and defect status updates in daily scrum stand-ups, team meetings as required Provide weekly report confirming status of assigned tasks Knowledge Transfer Requirements Knowledge transfer is expected to occur throughout the duration of the assignment through regular meetings, touchpoints, and working sessions with LRC staff All design, development, artefacts, and source code, including all relevant and complete documents must be transferred to the ministry in the designated repositories provided Dedicated knowledge transfer sessions will be scheduled to ensure completeness of knowledge transfer and all documentation is shared, and allow LRC staff to ask clarification and/or follow up questions Skills Experience and Skill Set Requirements Evaluation Criteria: Testing Skills/Experience - 50% 10+ years of experience in process, planning, organizing and implementing testing efforts Demonstrates working knowledge of the testing process and the Software development life cycle (SDLC), including Agile & DevOps Experience with creating, reviewing, and executing test strategy, test plans and test cases Executes quality assurance and testing activities for various types of testing such as integration testing, functional testing, regression testing, unit testing, load testing, performance testing and accessibility testing Experience with providing identification and resolution of problems/issues Plans and organizes testing efforts in both front-end and back-end application components/environments Communicate test results regularly through reports that summarize test completion and defects found Automation Testing, Technical Skills/Experiences-30% Hands-on experience with automation tools like Selenium, Appium, Katalon etc. Ability to write clean, maintainable, and reusable code for test automation Proficiency in programming languages such as Java, Python, C#, or JavaScript. Familiarity with testing frameworks such as TestNG, JUnit, NUnit, or PyTest. Experience with API testing tools like Postman, SoapUI, or RestAssured. Knowledge of RESTful and SOAP web services. Ability to write and execute SQL queries for database validation and data-driven testing. Ability to debug and troubleshoot automation scripts and identify root causes of failures. Ability to adapt to changing requirements and technologies. Experience with AODA Compliance Audit tools, AXE, WAVE etc. Familiarity with performance testing tools like JMeter or LoadRunner (optional) Leadership Skills - 20% Collaborate with cross-functional teams, including development, product management, and operations, to ensure a unified approach to quality. Drive initiatives to enhance testing tools, frameworks, and processes to improve overall efficiency and effectiveness. Communicate testing progress, results, and risks to stakeholders, providing actionable insights and recommendations. Act as a key point of contact for QA-related issues and escalations. Promote a culture of quality and continuous improvement within the organization. Excellent analytical, problem-solving and decision-making skills. Strong organizational, creativity and perseverance skills. Strong verbal and written communication skills; interpersonal skills. Proven track record for building strong working relationships. Hybrid model- 40 St. Clair Ave. West, Toronto (2 days onsite, 3 days remote) Must haves 10+ years of experience in process, planning, organizing and implementing testing efforts Experience with creating, reviewing, and executing test strategy, test plans and test cases Hands-on experience with automation tools like Selenium, Appium, Katalon etc. Knowledge of RESTful and SOAP web services Ability to write clean, maintainable, and reusable code for test automation Collaborate with cross-functional teams, including development, product management, and operations, to ensure a unified approach to quality.

07/14/2025

Role: Oracle Software Developer - Oracle APEX & ORDS RQ: RQ09421 Rate: 95/h Client: Ministry of Public and Business Service Delivery and Procurement Location: Remote, Anywhere in Ontario Duration: 164 business days, 7.25 hours per day Anticipated Start Date: August 2025 Title Oracle Software Developer - Oracle APEX & ORDS Description To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis. Project Description - 'Air Quality Suite Evergreening' - The goal of the Air Quality suite evergreening initiative is to upgrade the full technical stack for Ontario's Mission Critical Air Quality I&IT solutions. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening . Cloud hosting is targeted as part of this evergreening. Skills Experience and Skill Set Requirements Responsibilities • An Oracle APEX and ORDS Developer is needed to design, develop, and maintain web applications using the Oracle APEX platform, with a focus on utilizing Oracle REST Data Services (ORDS) for backend integration and API development. The role requires experience with the full software development lifecycle, including data architecture, development, maintenance, and support. • Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. • Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations. General Skills • Knowledge and understanding of Information Management principles, concepts, policies and practices • Experience with middleware and gateways • Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging • Ability to provide post-implementation support and resolve any post-implementation technical issues • Experience conducting design walkthrough sessions with project team • Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards • Ability to provide user and system documentation as required Evaluation Criteria Technical Knowledge and Skill - 70% 10+ years experience with/related to the following: Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX.  Experience with advanced APEX features like interactive reports, charts, and dynamic actions. Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database.  Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. Database Management: Working with the Oracle database, including data modeling, SQL, and PL/SQL development. Strong knowledge of Oracle databases, including SQL, PL/SQL, and data modeling. Full SDLC: Participating in all phases of the software development lifecycle, from requirements gathering and design to testing, deployment, and ongoing maintenance.  Experience with HTML, CSS, JavaScript, and other web technologies. Security: Ensuring the security of the Oracle APEX platform and the applications built upon it.  Knowledge of security best practices for web applications. Solution Architecture Analysis and recommendations: Ability to assess 'as is' state of legacy applications and assist in providing recommendations to a supported 'to be' state. Performance tuning: Experience with optimizing application performance. Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI). Analytical, Problem Solving, Communication and Collaboration: 30% Working closely with other developers, designers, and stakeholders to build high-quality applications. Strong ability to work with technical and non-technical team mates. Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure. Self starter with ability to track activities and update work/deliverables on team boards Kanban/DevOps Strong verbal, written and interpersonal skills Strong ability to document technical procedures and facilitate transition to operations knowledge transfer sessions. Strong record keeping and documentation skills Assigning Type - Remote (Candidate must be in Ontario) Must Haves: Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX. Experience with advanced APEX features like interactive reports, charts, and dynamic actions. Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database.  Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. Security: Ensuring the security of the Oracle APEX platform and the applications built upon it.  Knowledge of security best practices for web applications. Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI) Strong ability to work with technical and non-technical team mates. Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure.

06/26/2025

Role: Software Developer - ETL RQ: RQ09449 Rate: $95/h inc Client: Ministry of Public and Business Service Delivery and Procurement Location: Hybrid, 595 Bay Street, Toronto Duration: 229 business days, 7.25 hours per day Anticipated Start Date: August 2025 Description A Note on Assignment Type: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Scope The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL to perform activities for interfacing the new Dynamics 365 solution and data warehouse with internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff. Assignment Deliverables As a member of the integrations team, the ETL Developer will be responsible for integrating the new Dynamics 365 solution, the data warehouse, and various internal (OPS) and external systems. This team will comprise both internal staff and vendor resources. A high-level list of deliverables for the ETL Developer includes: • ETL Solution Design and Development: o Design, develop, and implement robust ETL (Extract, Transform, Load) processes for data migration and ongoing integrations between diverse source systems (e.g., internal legacy systems, external vendor platforms) and Microsoft Dynamics 365 Customer Engagement (CE) and Finance & Operations (F&O). o Develop and optimize data transformation logic to ensure data quality, consistency, and adherence to business rules and D365 data models. o Utilize and recommend appropriate ETL tools and technologies (e.g., Azure Data Factory, SSIS, other cloud-based ETL services) to build efficient and scalable data pipelines. o Implement data cleansing, validation, and error handling mechanisms within ETL processes. • Data Migration Planning and Execution: o Lead and execute all phases of data migration activities from legacy systems to D365 CE and F&O, including data profiling, mapping, cleansing, transformation, and loading. o Develop and maintain data migration strategies, cutover plans, and rollback procedures. o Collaborate with data owners and business users to ensure data accuracy and completeness during migration. • Testing and Quality Assurance: o Design, develop, and execute comprehensive test plans, cases, scripts, and test data (e.g., manufactured, obfuscated) based on functional and technical specifications to validate ETL solutions and data integrity. o Create and maintain a full test plan, testing procedures, and an associated library of reusable test cases and scripts, ensuring full traceability from requirements to test outcomes. o Perform both manual and automated testing to validate system and integration functionality, data accuracy, performance, and scalability. This includes unit testing, integration testing, system testing, and performance testing for ETL processes. • Collaboration and CI/CD Integration: o Actively collaborate with stakeholders across business units, development teams, and external vendors to understand integration requirements and ensure proper data flow. o Ensure proper integration of ETL processes and tests into the continuous integration/continuous delivery (CI/CD) pipeline to support automated deployments and efficient release cycles. • Support and Documentation: o Provide analytical, development, and testing support for ETL processes and data integrations throughout the project lifecycle. o Develop and maintain detailed technical documentation for all ETL processes, data mappings, data dictionaries, and integration architectures. o Assist in troubleshooting and resolving data integration issues, providing timely support and solutions. Skills Experience and Skill Set Requirements A Note on the VOR Master Service Agreement: The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2026-27. If the current statement of work expires on March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions, and covenants contained in the SOW.   The start date is subject to change based on security clearances and contract signing timelines. Experience and Skillset Requirements Mandatory Requirements At least 8 years of hands-on experience in enterprise-level data integration and ETL (Extract, Transform, Load) development, with a significant focus on integrating with Microsoft Dynamics 365 (Customer Engagement and/or Finance & Operations) and related Azure data services. Nice to Have Requirements The ideal candidate for this ETL Developer role will possess a strong blend of technical expertise in data integration, a deep understanding of Microsoft's data ecosystem, and excellent collaborative abilities. ETL Tool Proficiency: Mandatory: Proven hands-on experience with Microsoft's primary ETL tools for enterprise data integration, specifically Azure Data Factory (ADF). This includes designing and implementing pipelines, data flows, activities, datasets, linked services, and integration runtimes. Highly Desirable: Experience with SQL Server Integration Services (SSIS) for existing on-premise integrations or migration scenarios. Familiarity with other relevant data integration tools and concepts (e.g., Change Data Capture - CDC, data streaming) is a plus. Database and Data Warehousing Expertise: Strong SQL proficiency: Ability to write complex SQL queries, stored procedures, functions, and views for data extraction, transformation, and loading across various database platforms (e.g., SQL Server, Azure SQL Database). Solid understanding of data warehousing concepts (e.g., dimensional modeling, star/snowflake schemas, data marts) and experience designing and implementing data warehouse solutions. Experience with Azure data services relevant to data warehousing and analytics (e.g., Azure Synapse Analytics, Azure Data Lake Storage). Microsoft Dynamics 365 Data Acumen: Fundamental understanding of Dynamics 365 data models for both Customer Engagement (CRM) and Finance & Operations (ERP). This includes knowledge of key entities, relationships, and common data patterns within D365. Ability to extract data from D365 APIs and OData feeds, and load data effectively into D365 (e.g., using Data Management Framework - DMF, KingswaySoft, or custom integrations). Data Quality and Governance: Experience implementing data cleansing, validation, error handling, and reconciliation processes within ETL pipelines to ensure high data quality. Understanding of data governance principles and best practices for managing data integrity and consistency. Programming/Scripting (Desirable): Proficiency in scripting languages such as Python, PowerShell, or C# for custom data transformations, automation of ETL tasks, and interacting with APIs. Version Control and CI/CD: Experience with version control systems (e.g., Git, Azure DevOps Repos) for managing ETL code and configurations. Familiarity with Continuous Integration/Continuous Delivery (CI/CD) pipelines for automated deployment of ETL solutions. Analytical and Problem-Solving Skills: Excellent analytical and problem-solving skills with a keen eye for detail to identify data discrepancies, troubleshoot complex integration issues, and optimize ETL performance. Ability to translate business requirements into technical data integration solutions. Communication and Collaboration: Strong verbal and written communication skills to articulate technical concepts clearly to both technical and non-technical stakeholders. Ability to collaborate effectively within a multidisciplinary team (internal and vendor staff), including data architects, D365 functional consultants, and business users. Demonstrated ability to document technical designs, data mappings, and ETL processes thoroughly. Resumes Evaluation/Criteria: Criteria 1: Technical Skills - 40 Points Hands-on experience with Microsoft Dynamics 365 cloud environments (both Customer Engagement and Finance & Operations), specifically concerning data extraction, loading, and integration points. • Extensive experience (8+ years) working across various data platforms, database technologies, and integration patterns, including relational databases (SQL Server, Azure SQL), data lakes (Azure Data Lake Storage), and cloud data warehouses (Azure Synapse Analytics). •Proven experience with middleware, integration platforms, and APIs, particularly those used for connecting diverse systems to Dynamics 365 (e.g., Azure Data Factory, Logic Apps, API Management, or other enterprise integration tools). • Deep understanding and practical application of performance optimization techniques for ETL processes, large-scale data migrations, and data synchronization in cloud environments. • Demonstrated experience with structured methodologies for the design, development, and implementation of data integration solutions, including requirements gathering, data mapping, and detailed technical design documentation. • Strong background in data analysis and system design within large-scale, complex enterprise environments, focusing on data flow, data quality, and system interoperability. Criteria 2: Broader Technical Acumen & Methodological Proficiency - 30 Points • Demonstrated experience integrating diverse enterprise systems beyond D365, leveraging various integration patterns, middleware technologies (e.g., Azure Integration Services, Logic Apps), and communication protocols (e.g., REST, SOAP, SFTP). • Proven experience in managing and optimizing the performance of large-scale data migrations and continuous data synchronization processes across heterogeneous systems. • Extensive experience with structured methodologies for the entire data integration lifecycle, from detailed requirements gathering and data mapping to solution design, development, testing, and deployment. • Strong background in data analysis, data quality management, and troubleshooting complex data discrepancies within large, integrated system landscapes. • Familiarity with modern software development practices, including version control (e.g., Git, Azure DevOps Repos) and supporting Continuous Integration/Continuous Delivery (CI/CD) pipelines for automated ETL deployments. Criteria 3: Interpersonal Skill - 30 Points Exceptional Communication and Collaboration: • Articulate and concise communication skills, both verbal and written, capable of conveying complex technical information about data integration, ETL processes, and data quality issues to diverse audiences, including technical teams, D365 functional consultants, and non-technical business stakeholders. • Proven ability to actively participate in and lead technical discussions, offering informed solution recommendations, explaining design choices, and effectively documenting work for clarity and future reference. • Strong negotiation and influencing skills to align stakeholders on data integration strategies, resolve data mapping discrepancies, and gain buy-in for proposed ETL solutions, ensuring project objectives are met. • Demonstrated ability to work effectively within a multidisciplinary team environment (comprising internal staff, vendors, and cross-functional departments), fostering a collaborative atmosphere and successfully integrating individual contributions into a cohesive project outcome. Knowledge Transfer What needs to be KT ETL Solution Design Documentation: • Detailed ETL Process Flows/Pipelines (including end-to-end data flow from source to D365/data warehouse). • Comprehensive Data Mapping Specifications (source-to-target, transformations, data types, cleansing logic). • Integration Architecture Diagrams (showing connections between D365, data warehouse, and other systems). • Documentation of Data Governance & Quality Rules (validation, error handling, reconciliation). ETL Development Artefacts: • Fully commented and version-controlled ETL code and scripts (Azure Data Factory pipelines, SSIS packages, SQL scripts, custom code). • Deployment and Configuration Guides (step-by-step instructions for environments, including environment-specific settings). • Performance Optimization and Monitoring Artefacts (tuning strategies, monitoring queries/dashboards). Testing and Validation Assets: • ETL Test Plans and Test Cases (strategy, unit, integration, data validation test cases). • Sample Test Data and Data Validation Scripts (examples of test data, scripts/queries for integrity validation). Operational Runbooks & Troubleshooting Guides: • Daily Operations Runbook (procedures for routine monitoring, scheduling, common tasks). • Troubleshooting Guides (identifying/resolving job failures, discrepancies, performance bottlenecks, escalation paths). Project-Specific Documentation: • Key Data Integration Decision Logs (rationale for significant design choices). • Technical Presentations & Walkthroughs (materials used for deep-dives, potentially recorded sessions). • Relevant technical aspects of Status and Progress Reports (detailing technical progress, challenges, and resolutions). To whom Project Manager / Team members When 1:1 meetings, team meetings, dedicated knowledge transfer sessions (including hands-on walkthroughs), comprehensive documentation stored on SharePoint site (or other designated knowledge management platform), code repositories (e.g., Azure DevOps Repos) with clear commenting, throughout the duration of the project lifecycle and formally at project milestones/completion. This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to. Must haves: At least 8 years of hands-on experience in enterprise-level data integration and ETL (Extract, Transform, Load) development, with a significant focus on integrating with Microsoft Dynamics 365 (Customer Engagement and/or Finance & Operations) and related Azure data services.