业务智能专员 - 高级

Responsibilities:

• 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

• 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

• Support converted Dynamic Cubes functionality in 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.

• Report development for Intellihealth expansion

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

SkillsExperience and Skill Set Requirements
Public Sector Experience
· Experience working in the Public Sector 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 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
• 50 points
• 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
• 35 points
• 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.
• 10 points
• MUST HAVES:
• In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL)
• Experience in AWS Cloud technologies, specifically AWS Redshift
• Originally posted on Himalayas