logo

View all jobs

Senior BI Consultant

Remote Role, Nova Scotia · Computer/Software
Scope:
A Cognos Business Intelligence Analyst / Developer is required to support the following project tasks:
• Participate in building Data Marts
• Finalize a Data Model on a given domain
• Implement the Data Model using an ETL tool
• Maintain, develop, and test code changes using existing coding standards and tools

The Scope of this project is limited to the consolidation of data into a Cognos BI solution from one (1) data source: the Integrated Case Management (ICM).
The Consultant will have the following key responsibilities:

• Participate in building Data Marts
• Finalize a Data Model on a given domain
• Implement the Data Model using an ETL tool
• Maintain, develop, and test code changes using existing coding standards and tools
• Report to the Project Manager with respect to task status, progress, estimates to complete, and issue/problem escalation in a timely manner

Deliverables:
The key deliverables of the Consultant over the course of the engagement are expected to be:
• Data Mart development / testing
• ETL development / testing
• Creation of custom reports in Cognos
• Knowledge transfer of changes from/to the Business Intelligence Support Team
• Support User Acceptance testing

Qualifications
The proposed resource(s) must demonstrate the following qualifications:

Minimum of 5 years' experience developing with:
• IBM Cognos 10 Report Studio/Cognos Analytics 11
• IBM Data Manager
• IBM Framework Manager
Minimum of 5 years in Data Mart Design
Experience with Oracle 10G or 11G
Experience developing PL/SQL
Able to work as a member of a team
Ability to read and evaluate design specifications with a view to providing gap analysis, technical design improvements, and other technical feedback
Good communication skills – Written and Oral
Experience performing and supporting testing efforts, including developing and executing unit tests to ensure software will perform as expected
Experience working in structured project team environments that include formal processes such as deliverable approvals, change request processes, and rigid configuration management

Beneficial Qualifications:

Experience with ICM or LaMPSS systems
Previous public sector project experience
Data mart Design

 
Powered by