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 related regulations and standards.
- Exposure to Power BI (asset; primary focus remains OBIEE/OAC/BI Publisher).
Skills
Experience and Skill Set Requirements
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 related regulations and standards.
- Exposure to Power BI (asset; primary focus remains OBIEE/OAC/BI Publisher).
Evaluation Criteria
Technical Proficiency – 40%
- Demonstrates advanced hands‑on expertise in OBIEE, OAC, and BI Publisher, including semantic modeling (RPD), reporting, dashboards, and production support.
- Demonstrates strong understanding of dimensional modeling and how it drives correct reporting outcomes and OBIEE semantic layer design.
- Demonstrates working knowledge of ETL processes and the ability to assess upstream impacts on downstream reporting and analytics.
- Demonstrates proficiency in SQL and performance troubleshooting of reporting solutions.
Data Analysis Skills – 30%
- Exhibits strong analytical ability to validate data, reconcile metrics, interpret results, and derive meaningful insights.
- Demonstrates structured troubleshooting skills to resolve data discrepancies, report defects, scheduling failures, and performance issues.
- Demonstrates ability to perform root cause analysis and implement corrective and preventative actions.
Business Acumen – 20%
- Understands business processes and can translate business requirements into effective BI solutions aligned with operational and strategic outcomes.
- Demonstrates a process-oriented delivery mindset, including documentation, change management, and lifecycle practices (including archive/unarchive).
Communication Skills – 10%
- Effectively communicates technical concepts, design decisions, and troubleshooting findings to both technical and non‑technical stakeholders.
- Demonstrates ability to collaborate with cross‑functional teams and provide clear status updates, risks/issues, and recommendations.
MUST HAVES:
- BI Publisher is mandatory: you have hands‑on experience designing, developing, and supporting BI Publisher reports and delivery processes using different templates (e.g., RTF/Excel/PDF), including scheduling and bursting.
- You have demonstrated hands‑on experience developing and supporting BI solutions using OBIEE and Oracle Analytics Cloud (OAC).You have strong knowledge of dimensional modeling concepts, including star/snowflake schemas, facts and dimensions, conformed dimensions, hierarchies, and aggregate strategies; and you can apply these principles to OBIEE semantic layer design.
- You have strong SQL skills (SQL Server preferred), including the ability to validate results, reconcile metrics, and optimize query performance for reporting workloads.
- You have good knowledge of ETL architecture, processes, and data flow, including incremental vs. full loads, dependency scheduling, monitoring, error handling, and data quality controls.
- You have experience working in a structured delivery model using Azure DevOps, including user stories, tasks, backlog/sprint execution, and documentation of acceptance criteria and outcomes.
- You have proven analytical and troubleshooting skills, including the ability to diagnose and resolve end‑to‑end reporting issues (data, model, performance, scheduling, security, and output).
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com