OPGT MOD 2 - 1xSoft. Dev. CRM(Snr) -184 Days [Tech. Support]

Project Overview

The OPGT Modernization initiative is essential to the ongoing provision of services to Ontarians who cannot care for themselves and have no one else able to act on their behalf. Phase 1 implemented a cloud based, fully integrated, Microsoft Dynamics 365 solution to replace end of life case, financial, and document management systems, launched as a minimum viable product. Phase 2 will deliver enhancements to the MVP with additional workflows, automation, and new features, including enhanced audit and reporting functionality.

Key Responsibilities

• Translating technical system specifications to implementation
• Resolving and troubleshooting technical problems which arise during the use and operation of Microsoft Dynamics 365’s Client Experience (CE). This will include technical assistance in the implementation and anticipated future releases of solution design.
• Reporting and Visualization: develop reports, dashboards and visualizations per user requirements.
• Data analysis: analyze and interpret complex data sets to provide valuable insights into business performance and trends.
• Data accuracy: Ensure the quality, accuracy and integrity of reports.
• Support system, integration, and user acceptance testing by resolving defects, validating data accuracy, and addressing technical issues.
• Participate in deployment activities and provide technical support during post go live stabilization to ensure solution reliability.
• Complete work and achieve milestones within the assigned deadlines.
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them.
• Submit Deliverables for the Cluster/Ministry approval as they are completed.
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices.
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices.
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines.
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

Qualifications & Requirements

REQUIRED

• Must be able to work onsite at 595 Bay Street, Toronto
• 5+ years of experience developing and supporting enterprise applications, including Microsoft Dynamics 365 Customer Engagement (CE).
• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards and utilizing advanced features.
• Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
• Experience developing, configuring, and extending Microsoft Dynamics 365 Customer Engagement (CE) solutions.
• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
• SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding of indexing, partitioning, and query execution plans.
• Development experience with Dynamics 365 and understanding of the Common Data Model for Dynamics.
• Report development experience for Microsoft Dynamics 365 Customer Engagement (CE) and/or Finance and Operations (F&O)
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.

NICE TO HAVE

• Azure cloud certifications (e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)
• Dynamics 365 certifications

EVALUATION CRITERIA

Dynamics 365 CE / F&O Development and Reporting Experience - 25 points

• Demonstrated hands on experience designing, developing, configuring, and extending Microsoft Dynamics 365 Customer Engagement (CE) solutions within enterprise IT environments, including:
  • Experience implementing Dynamics 365 CE configurations and customizations, such as:
  • forms, views, and dashboards
  • workflows, business rules, and process automation
  • security roles and data access configurations
  • Development of custom components, plug ins, or extensions within Dynamics 365 CE using appropriate technologies, such as:
  • C# / .NET
  • JavaScript
  • Practical experience working with the Dynamics 365 platform and Dataverse, including:
  • entity structure and relationships
  • data handling, validation, and integrity
  • platform extensibility capabilities
  • Demonstrated ability to translate approved technical designs and user stories into functional, tested solution components in alignment with established architecture, security, and development standards.
  • Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).

Power BI - 25 points

• Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query.

Data Integration and Extraction - 20 points

• Demonstrated knowledge of various data integration techniques, including data extraction from different sources (e.g., databases, APIs, flat files), data transformation, and loading into a data warehouse.
• Familiarity with ETL tools and technologies, such as Azure Synapse
• Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.

Development Practices, Collaboration & Standards Adherence - 15 points

• Demonstrated experience working within structured enterprise delivery environments, adhering to established development practices, standards, and collaborative team models, including:
  • Experience following approved architecture, coding, and security standards when implementing solution components, rather than defining those standards.
  • Familiarity with CI/CD and DevOps practices in enterprise environments, such as:
  • participating in build and release pipelines
  • using version control systems
  • supporting automated deployment or testing processes
  • Experience working collaboratively within cross functional delivery teams, including:
  • developers, solution architects, business analysts, and testers
  • internal staff and external/vendor resources
  • Ability to contribute effectively within iterative or enhancement driven delivery approaches, including:
  • adapting to evolving requirements
  • supporting ongoing refinements post MVP
  • Demonstrated ability to document technical work, follow delivery processes, and communicate implementation details to support team alignment and operational sustainability.

Data Warehouse/Lakehouse - 15 points

• Demonstrated experience developing reports in a Data Warehouse/ Lakehouse.
• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.

Key Skills & Competencies

Microsoft Dynamics 365 CE, Microsoft Dynamics 365 F&O, Power BI, DAX, Power Query, SQL, Query Optimization, Data Modeling, Azure Synapse, ETL, Azure Repos, Azure DevOps, C#, .NET, JavaScript, Dataverse, Common Data Model, Data Warehouse, Lakehouse, CI/CD, Version Control, Data Gateway