We are seeking a highly specialized Senior Business Intelligence Specialist with in-depth knowledge and experience in Cognos Analytics v12.x. This role is crucial for designing, developing, and optimizing Cognos reports and dashboards, specifically leveraging IBM Cloud Pak for Data and AWS Redshift. The specialist will translate user requirements into technical models, implement robust security, perform complex SQL/PLSQL tuning, and provide critical testing and knowledge transfer support. This is a Hybrid role based in Toronto, requiring 4 days onsite per week.
...
Advantages
- Hyper-Specialization: Mandatory, in-depth expertise in the latest Cognos Analytics v12.x features and implementation.
- Cloud Platform Focus: Direct experience working with both IBM Cloud Pak for Data and AWS Redshift.
- High Performance Role: Heavy emphasis on SQL/PLSQL tuning and database performance optimization.
- Hybrid Flexibility: Benefit from a hybrid work arrangement in Toronto (4 days onsite/1 day remote).
Responsibilities
The Senior Business Intelligence Specialist will be responsible for:
- Translating user requirements into a Cognos BI business model and Framework Manager models. Designing and implementing the BI security model, metadata, user groups, and folder structure.
- Developing and optimizing Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift. This includes expertise in Cognos Analytics v12.x features like reporting, dashboarding, embedded JavaScript, and embedded SQL.
- Creating and tuning SQL/PLSQL processes for complex logic and performance optimization, with experience in Oracle 19 or higher.
- Testing, debugging, and re-engineering reports. Documenting test cases for functionality validation and applying strong Cognos testing skills.
- Supporting UAT, deployment, and providing training or demos for self-service BI reporting.
- Preparing scripts and documentation for data preparation, performance checks, and monitoring. Delivering knowledge transfer and detailed documentation to staff as per project requirements.
- Applying experience with Agile/Scrum and Waterfall methodologies, using tools such as JIRA and Confluence.
Qualifications
Must-Have Experience:
- In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL).
- Experience in Cognos Analytics reporting; modeling with Framework Manager, Dynamic Cube Designer, Data Module, Dataset, SDK.
- Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.
- Experience in AWS Cloud technologies, specifically AWS Redshift.
- Experience developing Cognos reports in the IBM Cloud Pak for Data environment.
- Experience in database performance and tuning skills.
- Excellent requirements analysis skills and strong interpersonal skills to interact with client stakeholders.
Desired Skills (Assets):
- Experience working in the Public Sector and familiarity with I&IT project management processes.
- Demonstrated experience in working with Power Designer Tool to design logical and physical models.
- Knowledge of BI architecture patterns, best practices, processes, and artefacts.
Summary
If you're interested in the Senior 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.
show more
We are seeking a highly specialized Senior Business Intelligence Specialist with in-depth knowledge and experience in Cognos Analytics v12.x. This role is crucial for designing, developing, and optimizing Cognos reports and dashboards, specifically leveraging IBM Cloud Pak for Data and AWS Redshift. The specialist will translate user requirements into technical models, implement robust security, perform complex SQL/PLSQL tuning, and provide critical testing and knowledge transfer support. This is a Hybrid role based in Toronto, requiring 4 days onsite per week.
Advantages
- Hyper-Specialization: Mandatory, in-depth expertise in the latest Cognos Analytics v12.x features and implementation.
- Cloud Platform Focus: Direct experience working with both IBM Cloud Pak for Data and AWS Redshift.
- High Performance Role: Heavy emphasis on SQL/PLSQL tuning and database performance optimization.
- Hybrid Flexibility: Benefit from a hybrid work arrangement in Toronto (4 days onsite/1 day remote).
Responsibilities
The Senior Business Intelligence Specialist will be responsible for:
...
- Translating user requirements into a Cognos BI business model and Framework Manager models. Designing and implementing the BI security model, metadata, user groups, and folder structure.
- Developing and optimizing Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift. This includes expertise in Cognos Analytics v12.x features like reporting, dashboarding, embedded JavaScript, and embedded SQL.
- Creating and tuning SQL/PLSQL processes for complex logic and performance optimization, with experience in Oracle 19 or higher.
- Testing, debugging, and re-engineering reports. Documenting test cases for functionality validation and applying strong Cognos testing skills.
- Supporting UAT, deployment, and providing training or demos for self-service BI reporting.
- Preparing scripts and documentation for data preparation, performance checks, and monitoring. Delivering knowledge transfer and detailed documentation to staff as per project requirements.
- Applying experience with Agile/Scrum and Waterfall methodologies, using tools such as JIRA and Confluence.
Qualifications
Must-Have Experience:
- In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL).
- Experience in Cognos Analytics reporting; modeling with Framework Manager, Dynamic Cube Designer, Data Module, Dataset, SDK.
- Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.
- Experience in AWS Cloud technologies, specifically AWS Redshift.
- Experience developing Cognos reports in the IBM Cloud Pak for Data environment.
- Experience in database performance and tuning skills.
- Excellent requirements analysis skills and strong interpersonal skills to interact with client stakeholders.
Desired Skills (Assets):
- Experience working in the Public Sector and familiarity with I&IT project management processes.
- Demonstrated experience in working with Power Designer Tool to design logical and physical models.
- Knowledge of BI architecture patterns, best practices, processes, and artefacts.
Summary
If you're interested in the Senior 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.
show more
