RQ10056 - Business Intelligence Specialist - Senior

Description:

• 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.
  

Experience 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.