Titre du poste ou emplacement
RECHERCHES RÉCENTES

RQ08739 - Business Intelligence Specialist - Senior

Maarut Inc - 59 emplois
East York, ON
Publié il y a 3 jours
Détails de l'emploi :
Temps plein
Niveau d`entrée

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.

Requirements

Experience and Skill Set Requirements:

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

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

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.

Partager un emploi :