We are seeking a highly skilled Business Intelligence Specialist to design, develop, and support enterprise-grade BI solutions. This role focuses on leveraging OBIEE, Oracle Analytics Cloud (OAC), and BI Publisher to deliver sophisticated reporting and guided analytics. You will be responsible for the full reporting lifecycle, from semantic layer design to high-fidelity report delivery, ensuring that data insights align with strategic business objectives.
...
Pay Rate: $560.07- $595.56/Diem
Advantages
- Lead a major rewrite of key enterprise reports to drive operational monitoring.
- Collaborative onsite environment combined with structured, process-driven delivery.
- Work across the entire Oracle BI stack while engaging with modern ETL and cloud architectures.
- Focus on high-visibility, "pixel-perfect" reporting solutions that support executive decision-making.
Responsibilities
- Design and implement BI solutions using OBIEE and OAC, including the development of dashboards, alerts, and drill-down analytics.
- Develop and maintain OBIEE RPD semantic models that accurately reflect dimensional warehouse structures, including facts, dimensions, and hierarchies.
- Lead the design and delivery of BI Publisher reports using various templates (RTF, Excel, PDF), managing complex scheduling and bursting requirements.
- Create customized SQL solutions to analyze operational data and optimize query performance for reporting workloads.
- Partner with ETL and database teams to monitor data lineage, troubleshoot refresh schedules, and ensure reporting accuracy.
- Investigate and resolve incidents related to data discrepancies, security/access (row-level/object-level), and report rendering failures.
- Manage report content through versioning, environment promotion, and archival procedures within a structured SDLC framework.
- Work within an Azure DevOps environment to refine user stories, track tasks, and maintain traceability from requirements to delivery.
Qualifications
- Extensive experience designing and supporting BI Publisher reports, including scheduling, bursting, and multiple template types.
- Proven hands-on experience with OBIEE and Oracle Analytics Cloud (OAC).
- Strong expertise in star/snowflake schemas, conformed dimensions, and aggregate strategies applied to semantic layer design.
- Robust skills in SQL (SQL Server preferred) for metric reconciliation and performance tuning.
- Solid understanding of ETL architecture, including incremental vs. full loads, dependency logic, and error handling.
- Expert analytical skills to diagnose end-to-end reporting issues across data, models, and security.
- Experience in a structured delivery model using Azure DevOps for sprint execution and documentation.
Summary
If you're interested in the Business Intelligence Specialist role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
We are seeking a highly skilled Business Intelligence Specialist to design, develop, and support enterprise-grade BI solutions. This role focuses on leveraging OBIEE, Oracle Analytics Cloud (OAC), and BI Publisher to deliver sophisticated reporting and guided analytics. You will be responsible for the full reporting lifecycle, from semantic layer design to high-fidelity report delivery, ensuring that data insights align with strategic business objectives.
Pay Rate: $560.07- $595.56/Diem
Advantages
- Lead a major rewrite of key enterprise reports to drive operational monitoring.
- Collaborative onsite environment combined with structured, process-driven delivery.
- Work across the entire Oracle BI stack while engaging with modern ETL and cloud architectures.
- Focus on high-visibility, "pixel-perfect" reporting solutions that support executive decision-making.
Responsibilities
- Design and implement BI solutions using OBIEE and OAC, including the development of dashboards, alerts, and drill-down analytics.
- Develop and maintain OBIEE RPD semantic models that accurately reflect dimensional warehouse structures, including facts, dimensions, and hierarchies.
...
- Lead the design and delivery of BI Publisher reports using various templates (RTF, Excel, PDF), managing complex scheduling and bursting requirements.
- Create customized SQL solutions to analyze operational data and optimize query performance for reporting workloads.
- Partner with ETL and database teams to monitor data lineage, troubleshoot refresh schedules, and ensure reporting accuracy.
- Investigate and resolve incidents related to data discrepancies, security/access (row-level/object-level), and report rendering failures.
- Manage report content through versioning, environment promotion, and archival procedures within a structured SDLC framework.
- Work within an Azure DevOps environment to refine user stories, track tasks, and maintain traceability from requirements to delivery.
Qualifications
- Extensive experience designing and supporting BI Publisher reports, including scheduling, bursting, and multiple template types.
- Proven hands-on experience with OBIEE and Oracle Analytics Cloud (OAC).
- Strong expertise in star/snowflake schemas, conformed dimensions, and aggregate strategies applied to semantic layer design.
- Robust skills in SQL (SQL Server preferred) for metric reconciliation and performance tuning.
- Solid understanding of ETL architecture, including incremental vs. full loads, dependency logic, and error handling.
- Expert analytical skills to diagnose end-to-end reporting issues across data, models, and security.
- Experience in a structured delivery model using Azure DevOps for sprint execution and documentation.
Summary
If you're interested in the Business Intelligence Specialist role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
