Apply now

First seen by our source: last month

RQ10945 - Sr. Business Intelligence Specialist

@ Source Code

Toronto, Ontario

$71.45–$107.17/hr
Apply now
SIGNALS

Overview

Source Code is hiring a Senior Business Intelligence Specialist on a 10+ month contract, possibly extending beyond one year, for the Office of the Public Guardian and Trustee (OPGT) Modernization initiative. The role builds audit and reporting features on a Microsoft Dynamics 365 MVP, requires five on-site days a week at 595 Bay Street, and requires a CRJMC security clearance plus a credit check. Pay is $89.31 to $107.17 per hour incorporated or $71.45 to $85.74 per hour T4.

Pay:

$71.45–$107.17 an hour

Responsibilities:

  • Define audit and reporting enhancements for the Dynamics MVP
  • Extract, transform and load data into the data warehouse
  • Create logical and physical data models
  • Build reports, dashboards and visualizations
  • Apply data security and governance controls

Requirements summary:

  • Strong data warehousing, ETL and governance knowledge
  • Proficiency in Power BI, including DAX and Power Query
  • Proven experience reporting from Dynamics 365 CE and F&O
  • Experience with Azure Synapse and SQL Server Management Studio
  • Familiarity with Azure Repos and Azure DevOps

Tools & skills

Source and dates

Source type not verified · manatal

Employer posting date
Not provided
First seen by our source
2026-10-12
Source record updated
2026-10-15

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Hours per week36.25
Scheduleday
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
Background checkscredit
Security clearanceOther clearance

Summary and details written by AI from the posting; the employer’s posting is the authority.

Source Code

FieldValue
Open jobs on Jobsy505
Job description

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:

  1. Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modelling, ETL processes, data integration, and data governance.
  2. Power BI: Proficiency in Power BI, including data modelling, creating interactive reports and dashboards and utilizing advanced features
  3. 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
  4. Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).
  5. Experience with SQL Server Management Studio, Azure data management tools, SQL4CDS
  6. 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 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 designated Cluster/Ministry staff.
  • Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

Desired Skills and Experience:

  • Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.
  • 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.
  • 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
  • Data Modeling and Design: Proficiency in designing logical and physical data models, understanding relationships, defining hierarchies, and ensuring efficient data storage and retrieval.
  • Data Visualization: Ability to create visually appealing and informative reports and dashboards using Power BI, understanding best practices for data visualization, and storytelling with data.
  • Analytical and Problem-Solving Skills: Strong analytical thinking and problem-solving abilities to identify business requirements, analyze data, and provide meaningful insights to stakeholders.
  • Communication and Collaboration: Effective communication skills to interact with stakeholders, gather requirements, and present findings. Collaboration skills to work with cross-functional teams, such as data engineers, data analysts, and business stakeholders.
  • 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.
  • Experience with SQL Server Management Studio, Azure data management tools, SQL4CDS
  • Proven experience producing reports from data from Dynamics 365 Customer Experience (CE) and Finance (F&O).

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

  • $89.31/hr - $107.17/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

  • $71.45/hr - $85.74/hr T4

Similar jobs

  • ACCOUNT MANAGER

    Vancouver, BC +1

    Green Shield Canada

    Ensure timely and accurate delivery of solutions aligned with client needs, objectives, and plan requirements; Travel to client locations as required to support relationship management and business development;…

  • HF Programs Specialist Youth

    Toronto, ON
    Full Time

    YMCA OF GREATER TORONTO

    The Health and Fitness Program Specialist (Child, Youth & Family) provides direct leadership in our initiatives to provide a superior experience to our members; The Specialist demonstrates leadership and provides…

  • Team Lead, System Reliability Engineering

    Toronto, ON

    Questrade

    As the Team Lead, System Reliability Engineering within the Questrade Experience Platform Engineering Group, you will balance hands-on architectural leadership with people management; Domain Expertise: Strong…

    Senior System Reliability Engineer

    Toronto, ON

    Questrade

    As a Senior System Reliability Engineer within the Questrade Experience Platform Engineering Group, your playground involves:; Domain Expertise: Strong foundational knowledge of trading systems is desired but not…

  • Dishwasher-Full Time

    Toronto, ON
    Full Time

    Chartwells Higher Education

    You must have a valid Food Handler Certificate or provincial equivalent; Willing to work in a fast-paced environment; Previous dishwashing experience preferred but not required

  • Talent Acquisition Specialist, People and Culture

    Toronto, ON
    $52k–$60k/yrHybridFull Time

    Paladin Security Group

    1+ YOEPartner closely with hiring managers to understand hiring needs, workforce plans, and specific role requirements; Coordinate onboarding requirements and act as a reliable point of contact for new hires to ensure a…

    Recruitment, ATS, Oracle HRIS, Human resource management, Microsoft Office, Microsoft Outlook

    People & Culture Receptionist

    Toronto, ON
    $45k–$52k/yrOn-siteFull Time

    Paladin Security Group

    This role is responsible for ensuring a professional front-office experience, supporting employee lifecycle processes, and contributing to employee engagement initiatives; Customer service experience with a focus on…

    Administrative support, Employee relations, Leadership, Communication skills, Regulatory compliance, CPR

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.