Business Intelligence Specialist - Senior
- Pay Rate: Flexible
- Location: Toronto, Ontario
- Contract Length: 12 Months, Onsite
We at Raise are hiring right now for one of our Clients. If you’re interested, apply below for your chance to join a great place to work.
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 understanding of Information Management principles, concepts, policies, and practices.
- Knowledge and understanding of AODA and relat