We are seeking a highly technical Senior Business Intelligence Specialist to lead the design, development, and optimization of sophisticated reporting solutions in Toronto. This role is focused on leveraging the Cognos Analytics suite within modern cloud environments, specifically AWS Redshift and IBM Cloud Pak for Data. The successful candidate will be responsible for the full BI lifecycle, from complex metadata modeling and point-in-time architecture implementation to high-performance dashboarding and SQL tuning.
...
Duration: 12-month contract with potential for extension
Location: Toronto (Onsite)
Rate: $560.07-$595.56/hr
Advantages
Cutting-Edge Environment: Work with the latest Cognos Analytics 12.x on AWS and IBM Cloud Pak for Data.
Project Longevity: 12-month initial contract with a strong likelihood of extension.
Strategic Impact: Lead the expansion of high-profile health-related data initiatives (Intellihealth).
Technical Ownership: End-to-end responsibility for the BI stack, from the security layer to the final dashboard.
Responsibilities
BI Modeling & Design: Convert complex user requirements into robust business models using Framework Manager, Transformer, Dynamic Cube Designer, and Data Modules.
Cloud Reporting: Develop and deploy advanced reports and dashboards in Cognos Analytics v12.x hosted on AWS and IBM Cloud Pak for Data.
Data Architecture: Design and develop Data Marts and Data Warehouses across relational and multi-dimensional repositories; implement point-in-time architecture for historical reporting.
Backend Development: Write and optimize complex SQL and PL/SQL procedures to handle intricate business logic and ensure optimal report performance.
Security & Governance: Build security models for BI implementations, including the creation of metadata, user groups, and organized folder structures.
Testing & Quality: Lead testing activities using Life Cycle Manager, document test cases, and perform deep-dive debugging of standard reports.
Knowledge Transfer: Conduct demos on self-serve BI for SMEs and provide detailed technical documentation to internal staff.
Environment Migration: Support Cognos migration activities, including the re-engineering of embedded JavaScript and SQL within legacy reports.
Qualifications
Expert Cognos Skills: 5+ years of experience in Cognos Analytics reporting and modeling (Framework Manager, SDK, Transformer, Dynamic Cube Designer).
Cloud Proficiency: Demonstrated hands-on experience with AWS Cloud technologies, specifically AWS Redshift.
Database Mastery: In-depth knowledge of relational databases, including advanced SQL tuning and database-specific programming (PL/SQL or T-SQL).
Modeling Tools: Experience using Power Designer to design logical and physical models and generate scripts.
Methodologies: Proficient in both Agile/Scrum (JIRA/Confluence) and Waterfall environments.
Soft Skills: Strong critical thinking and presentation skills, with the ability to explain technical implications to senior management and stakeholders.
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.
This posting is for existing and upcoming vacancies.
show more
We are seeking a highly technical Senior Business Intelligence Specialist to lead the design, development, and optimization of sophisticated reporting solutions in Toronto. This role is focused on leveraging the Cognos Analytics suite within modern cloud environments, specifically AWS Redshift and IBM Cloud Pak for Data. The successful candidate will be responsible for the full BI lifecycle, from complex metadata modeling and point-in-time architecture implementation to high-performance dashboarding and SQL tuning.
Duration: 12-month contract with potential for extension
Location: Toronto (Onsite)
Rate: $560.07-$595.56/hr
Advantages
Cutting-Edge Environment: Work with the latest Cognos Analytics 12.x on AWS and IBM Cloud Pak for Data.
Project Longevity: 12-month initial contract with a strong likelihood of extension.
Strategic Impact: Lead the expansion of high-profile health-related data initiatives (Intellihealth).
Technical Ownership: End-to-end responsibility for the BI stack, from the security layer to the final dashboard.
Responsibilities
...
BI Modeling & Design: Convert complex user requirements into robust business models using Framework Manager, Transformer, Dynamic Cube Designer, and Data Modules.
Cloud Reporting: Develop and deploy advanced reports and dashboards in Cognos Analytics v12.x hosted on AWS and IBM Cloud Pak for Data.
Data Architecture: Design and develop Data Marts and Data Warehouses across relational and multi-dimensional repositories; implement point-in-time architecture for historical reporting.
Backend Development: Write and optimize complex SQL and PL/SQL procedures to handle intricate business logic and ensure optimal report performance.
Security & Governance: Build security models for BI implementations, including the creation of metadata, user groups, and organized folder structures.
Testing & Quality: Lead testing activities using Life Cycle Manager, document test cases, and perform deep-dive debugging of standard reports.
Knowledge Transfer: Conduct demos on self-serve BI for SMEs and provide detailed technical documentation to internal staff.
Environment Migration: Support Cognos migration activities, including the re-engineering of embedded JavaScript and SQL within legacy reports.
Qualifications
Expert Cognos Skills: 5+ years of experience in Cognos Analytics reporting and modeling (Framework Manager, SDK, Transformer, Dynamic Cube Designer).
Cloud Proficiency: Demonstrated hands-on experience with AWS Cloud technologies, specifically AWS Redshift.
Database Mastery: In-depth knowledge of relational databases, including advanced SQL tuning and database-specific programming (PL/SQL or T-SQL).
Modeling Tools: Experience using Power Designer to design logical and physical models and generate scripts.
Methodologies: Proficient in both Agile/Scrum (JIRA/Confluence) and Waterfall environments.
Soft Skills: Strong critical thinking and presentation skills, with the ability to explain technical implications to senior management and stakeholders.
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.
This posting is for existing and upcoming vacancies.
show more
