Business Intelligence Specialist - Senior

Toronto, ON, Canada

Contract

Workspace

On-Site

Start Date

2026-04-15

APPLICATIONS FOR THIS POSITION ARE NOW CLOSED

Job Type

Client

Central Agencies Cluster

Hourly Wage

77-89

End Date

2027-03-31

Job Description

This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location

Responsibilities:

Deliver the rewrite of the SPP Outlook report

Supports the Client’s enterprise business information and reporting requirements by designing, developing, implementing, and supporting Business Intelligence solutions using OBIEE and Oracle Analytics Cloud (OAC).

Develops and supports OBIEE RPD semantic models that accurately reflect the Client’s dimensional warehouse structures, including facts, dimensions, hierarchies, conformed dimensions, aggregates, and subject areas.

Develops and supports BI Publisher solutions (mandatory), including pixel‑perfect reporting using multiple template types (e.g., RTF, Excel, PDF), data models, scheduling, bursting, delivery, and troubleshooting.

Develops and supports customized query and reporting solutions that analyze key business and operational data, ensuring alignment between business definitions and underlying data structures.

Develops and supports guided analysis, drill‑downs, dashboards, alerts, and notifications to enable operational monitoring and strategic decision‑making.

Implements and supports routine scheduling, distribution, and notification processes for report generation, delivery, and alerting (including failure monitoring and remediation).

Provides stakeholders with solution options and recommendations for managing and analyzing business data, including approach options to measure progress and quantify the impact of operational actions on business objectives.

Investigates and resolves incidents and defects related to BI solutions, including data discrepancies, security/access issues, performance bottlenecks, scheduling failures, and report rendering/output issues.

Performs structured root cause analysis and implements corrective and preventative actions to reduce recurring reporting and data issues.

Collaborates with ETL, database, and application teams to understand upstream transformations, refresh schedules, dependencies, and data lineage to ensure reporting accuracy.

Works in a process-driven delivery environment using Azure DevOps, including creating and refining user stories, estimating work, tracking tasks, documenting acceptance criteria, and maintaining traceability from requirements to delivered outputs.

Supports report and content lifecycle management, including archive and unarchive procedures, promotion across environments, versioning, and appropriate documentation/knowledge transfer.

General Skills:

Experience analyzing data in source systems and downstream layers to identify data cleanliness and integrity issues (e.g., missing values, duplicates, invalid values, inconsistent business definitions).

Experience developing feedback processes to address data quality issues at the source and/or within ETL processes, including reconciliation checks and audit controls.

Experience understanding and working with ETL processes and schedules that populate reporting repositories, including:

Initial loads and incremental loads

Dependency logic and orchestration

Monitoring, logging, and error notification

Incident response and recovery procedures

Experience developing, maintaining, and troubleshooting BI reports and dashboards in production environments, including:

Data discrepancies (source vs. report)

Performance issues (slow dashboards/reports)

Security/access problems (row-level/object-level)

Report scheduling and bursting failures

BI Publisher layout/output rendering issues

Proven troubleshooting and analytical experience, including a structured approach to root cause analysis and documenting fixes to prevent recurrence.

Experience in process decomposition/mapping and understanding business processes to ensure reporting outputs align to business operations and measurement needs.

Experience developing and maintaining documentation such as technical specifications, mapping documents, runbooks, and knowledge transfer artifacts.

Experience in working within defined SDLC / governance practices, including change management, environment promotion, and release support.

Desirable Skills:

Hands-on experience with ETL tools such as SSIS, Azure Data Factory, or Oracle-based ETL tooling.

Experience developing monitoring and error notification processes to ensure data is updated as designed and issues are proactively identified.

Hands-on experience working with stakeholders to develop and document interface specifications between BI solutions and external systems.

Experience with conceptual, logical, and physical data modelling tools such as PowerDesigner and Visio.

Knowledge and unde