Business Intelligence Specialist - North York, Canada - Dawn InfoTek Inc.

Dawn InfoTek Inc.

Verified Company

North York, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

We are currently seeking competent individuals to fulfill the role of
Business Intelligence Specialist - Senior to join our dynamic team for our client

C
ontract Duration:15 months**
Work type: Required to work onsite at the work location 3 days a week and 2 days from home

Position Summary-

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 onpremises 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, reengineer 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 selfserve 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

Experience working in the
OPS and familiarity with I&IT project management processes:
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 pointintime architecture; testing with Life Cycle Manager (5+ years)
Excellent requirements analysis skills
Indepth 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:
Experience in
Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views.
Experience in
AWS Cloud technologies, specifically A
WS 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

Soft Skills

Demonstrated leadership and people management 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, detailoriented and creative team player with perseverance, excellent organization and multitasking abilities, and a proven track record for meeting strict deadlines.

Salary:
$90.00-$110.00 per hour

Work Location:
Hybrid remote in North York, ON M7A 2T1