RQ10056 - Business Intelligence Specialist - Senior

Job DescriptionDescription:Translate user requirements into a Cognos BI business model and Framework Manager models.Design and implement BI security model, metadata, user groups, and folder structure.Develop and optimize Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift.Test, debug, and re-engineer reports; document test cases for functionality validation.Create and tune SQL/PLSQL processes for complex logic and performance optimization.Prepare scripts and documentation for data preparation, performance checks, and monitoring.Support UAT, deployment, and provide training or demos for self-service BI reporting.Deliver knowledge transfer and detailed documentation to HSC staff as per project requirements.RequirementsExperience and Skill Set Requirements:Must Haves:In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL)  Skill Set Requirements:Public Sector Experience:Experience working in the Public Sector and familiarity with I&IT project management processes Technical Skills:Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores)Experience in Cognos Analytics reporting; modeling with Framework Manager, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architectureExcellent requirements analysis skillsDemonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes.In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL)Knowledge of BI architecture patterns, best practices, processes, and artefactsExperience developing Cognos reports in the IBM Cloud Pak for Data environment Core skills, database and domain knowledge:Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.Experience in AWS Cloud technologies, specifically AWS RedshiftExperience in database performance and tuning skillsExperience in Cognos testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence General Skills:Proven troubleshooting and critical thinking skillsStrong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications.Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management.A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.RequirementsExperience and Skill Set Requirements: Must Haves: In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL) Skill Set Requirements: Public Sector Experience: Experience working in the Public Sector and familiarity with I&IT project management processes Technical Skills: Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores) Experience in Cognos Analytics reporting; modeling with Framework Manager, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture Excellent requirements analysis skills Demonstrated experience in working with Power Designer Tool to design logical and physical models, generating scripts and applying model changes. In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL) Knowledge of BI architecture patterns, best practices, processes, and artefacts Experience developing Cognos reports in the IBM Cloud Pak for Data environment Core skills, database and domain knowledge: 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 in database performance and tuning skills Experience in Cognos testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL) Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence General Skills: Proven troubleshooting and critical thinking skills Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications. Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management. A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.