Reecruit

Action

• Like
• Follow

• Job Title: Business Intelligence Specialist
• Salary: As Per Industry
• Functional Area: IT Software - ERP / CRM
• Job Shift: Day
• Employment Type: N/A
• Keyskills: Java Script, SQL
• Job Description:

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

Read More