Responsibilities:
· Prepare a detailed BI user requirement document
· Document the new requirements and complete analysis and design document
· Convert the user requirements into business model for Cognos BI
· Convert the business model into Framework Manager Models
· Build the security model for the BI implementation
· Create metadata, user groups and folder structure for BI objects
· Migrate standard reports from Cognos v11.1 on-premises to Cognos v11.2 on Cloud Pak for Data on Amazon Web Services (AWS)
· Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
· Test, debug, re-engineer standard reports and dashboards in Cognos on AWS
· Convert Dynamic Cubes functionality to DMR or Transformer Cubes without any loss in performance
· Document test cases to ensure expected functionality of the reports
· Deploy reports using Cognos Framework Manager
· Develop SQL and PLSQL process and procedures to implement complex logic.
· Assist with SQL tuning and optimization activities related to the Cognos reports.
· Help to optimize the SQL and PL/SQL process for optimal report performance.
· Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring.
· Support user acceptance testing and system implementation.
· Train SMEs or conduct demos on self-serve BI reporting.
· Any other deliverables as assigned by the Project/Resource Manager.
· Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements.
Experience and Skill Set Requirements
Public Sector Experience · Experience working in the OPS and familiarity with I&IT project management processes 5 points
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, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (5+ years)
· 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 v11.2.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 migration and 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.
Desire candidate profile
Must haves: · Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (5+ years) · Experience in AWS Cloud technologies, specifically AWS Redshift · Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)
Education Level
GraduationOrganization Profile
Reecruit