Client: Ministry of Public and Business Service Delivery and Procurement Work Location: 595 Bay Street, Toronto, Ontario, Onsite Estimated Start Date: 2025-10-20

Estimated End Date: 2026-03-31

Business Days: 215.00

Extension : Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC + Credit Check

Must Have

• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.
• Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.
• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.

Nice to have

• Azure cloud certifications (e.g. Azure fundamentals, Azure Power BI Data Analyst Associate)
• Experience with PowerApps platform, Power Automate, Dynamics CE and F&O

Description

• The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer to help build a new data warehouse/lakehouse and deliver the reporting MVP (minimum viable product).

Assignment Deliverables

• As a member of the data team, you will be responsible to help define the MVP for reporting, build the new data warehouse/lakehouse and deliver the required reporting. A high-level list of deliverables for the data migration team follows:
• Data Warehouse Design: analyze business requirements and design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure
• Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse/lakehouse (bronze/silver/golden layers). Help integrate data from diverse sources into the new data warehouse.
• Data Modeling: create logical and physical data models that align with the project’s reporting and analytical needs.
• Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse.
• Reporting and Visualization: develop reports, dashboards and visualizations as per reporting MVP. Ensure the quality, accuracy and integrity of reports.
• Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
• Other duties as assigned.

The Vendor’s Personnel Will Also Be Required To

• 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
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

Experience And Skill Set Requirements Criteria 1: Data Warehouse - 25 Points

• Demonstrated experience developing reports in a Data Warehouse/ Lakehouse. Experience with supporting a data warehouse in a production environment
• Demonstrated experience working with Azure Synapse workspaces, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Demonstrated experience with data warehousing modelling concepts such as star and snowflake schemas and data modelling tools.

Criteria 2: PowerBI - 25 Points

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

Criteria 3: SQL / DB

20 Points

• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning
• Demonstrated experience with SQL Server, Oracle, Azure SQL Databases
• Experience with SSIS, SSRS

Criteria 4: Dynamics 365

20 Points

• Strong understanding of the Dynamics 365 data model, entities, and relationships.
• Experience developing reports from source data from Dynamics 365 CE or F&O.
• Familiarity with Dataverse and Power Platform application development.

Criteria 5: Azure Platform

10 Points

• Experience with Azure Data Factory (ADF) and Synapse Workspaces
• Demonstrated experience Azure data management tools, DevOps,
• Azure cloud certifications

Note

• 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.
• 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.

Eligibility and Application Steps If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role! If you have any questions or need further clarification, feel free to call or text at (647) 408-1348.