About this role
RQ10945 - Sr. Business Intelligence Specialist 10+ month contract - possible extenion of 1+ year ONSITE 5 days - 595 Bay Street
Security Level: CRJMC + Credit Check Must-haves: • Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modelling, ETL processes, data integration, and data governance. • Power BI: Proficiency in Power BI, including data modelling, creating interactive reports and dashboards and utilizing advanced features • Data Integration: 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. Proven experience with ETL tools and technologies, such as Azure Synapse • Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O). • Experience with SQL Server Management Studio, Azure data management tools, SQL4CDS
• 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. Project Details: 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 of this IT project implemented a cloud based, fully integrated, Microsoft Dynamics 365 solution to replace end of life case, financial, and document management systems. Phase 1 of the solution was launched in April 2026 as a minimum viable product (MVP). The Phase 2 project will deliver enhancements to the MVP with additional workflows, automation, and new features and functionality. Scope: The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Intelligence Specialist to help enhance the audit and reporting functionality in a Microsoft Dynamics MVP (minimum viable product). Assignment Deliverables: As a member of the PGTIMS Support and Data Reporting team, you will be responsible for helping to define enhancements to MVP audit and reporting functionality. A high-level list of deliverables for audit and reporting follows: • Collaborate with cross-functional teams: work with teams across departments to understand business requirements and deliver data-driven solutions. • Database management: work with databases and the data warehouse to extract, transform, and load data for analysis. • Data analysis: analyze and interpret complex data sets to provide valuable insights into business performance and trends. • Data Modeling: create logical and physical data models that align with the organization's reporting and analytical needs. • Data Security and Governance: apply security controls to protect sensitive data. • Reporting and Visualization: develop reports, dashboards and visualizations per user requirements. • Data accuracy: Ensure the quality, accuracy and integrity of reports. • Performance Optimization: fine-tune data warehouse and reporting processes to optimize query performance and overall system efficiency. • Other duties as assigned. You 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 you become aware of them • Submit Deliverables for Cluster/Ministry a