Search Jobs

Contract Opportunities

If you are an experienced professional wanting the flexibility to leverage your skills and knowledge into a diverse and rewarding assignment or someone who is not sure what industry or specialty you want to focus your career in, check out our contract assignments. We know contracting and can assist with setting yourself up as an independent contractor as well as provide insight into compliance and opportunity generation. If you want the control and advantage of self-directing your career then give contract work a try!

Permanent Opportunities

Deciding what you want to do for the next 3 to 5 years is an important decision. Add to that deciding who you want to work for without a real understanding of the culture and make-up of a new company can be daunting. At CTSNA we are interested in you. Not just how you will fit into a particular job, but what skills you want to leverage, or what you want to learn, do and become. By all means check out our permanent employment opportunities, but don’t be surprised if we ask about you before we tell you about the culture and expectations of the companies we represent.

Search a job :

Cognos BI Architect

Category: IT Work Type: Contract Location: Chalk River

Position: Cognos Business Intelligence Architect

Location: Chalk River, Ontario

Duration: 6 Months

Rate:$100.00/HR to your incorporation

Per Diem:$175.00/Day

Note: Resumes required by 3PM, Friday Oct 25/19.


The Architect will be responsible for reviewing current data models, existing COGNOS framework, and reports being derived from the CNL financial and Project COGNOS data marts and cubes already built. After a complete review of the entire data architecture they will provide direction on changes required to correct issues in the structure and make improvements to the overall enterprise data warehouse model. He/she will assist CNL IT solution analysts in implementing the changes to ensure a complete business reporting structure that provides accurate and timely reporting. In addition, the architect will provide support and guidance to the CNL Solution analysts assigned to the COGNOS Business Intelligence Enterprise Application to continue to expand and support the data warehouse and data marts following best practice ongoing.


Utilize expert knowledge of Cognos Analytics 11, Cognos Framework Manager and any associated technologies to assist the CNL IT Systems and Architecture Team to support the COGNOS Business Intelligence environment at CNL
Responsible for creating, reviewing and troubleshooting reports in Cognos Analytics 11
Responsible for creating and maintaining a Financial and Project Management Data Architecture Map
Review and provide suggestions to improve the use of data models inside Cognos Framework
Review and help implemented new Data models for Cognos based on Business Requirements
Work closely with the BI Governance Council and CNL IT to ensure that Business Requirements are being met within the application in an optimized manner.
Help CNL IT with upgrading Transformer Cubes for use in Cognos Analytics 11 as a source.
Investigate, Document and implement system improvements and efficiencies following CNL Change
Management process.
Participate as a subject matter expert on project teams to deliver new items for Business Intelligence reporting
Participate in creation and execution of test cases to support new COGNOS implementations or processes.
Work closely database administrators to resolve escalated technical issues.

Knowledge, Skills and Abilities:

5+ years working as a COGNOS Data Architect
3+ years’ experience with Cognos Framework Manager3+ years’ experience with Cognos Analytics 11Experience creating reports and troubleshooting reporting issues in Cognos Analytics 11
Experience in creating and troubleshooting data sources in Cognos Framework. (Types of Data: Oracle, SQL Server)
Experience in upgrading Transformer Cubes for use in Cognos Analytics 11 as a source

Assist users with functionality in Cognos Analytics 11. May be requested to train less experienced employees.
Help architect new and existing data solutions for use with Cognos Analytics 11
Review existing data mart solutions and provide recommendations on necessary changes or improvements.
Assist CNL IT Technical Leads with any questions, problems or issues that they might have
Understand and translate Business Requirements for new data solutions and/or reporting.
Recommendations and Decisions:

Expected to act as a COGNOS Architect for the all financial and Project management data marts
Responsible for providing guidance and technical advice on improving COGNOS solutions and applications.
Responsible in reviewing existing framework and providing guidance to improve or increase the use of the data warehouse and data marts already existing.
Responsible for understanding high level business requirements and translating those down to the technical level
Resource Management:

Expected to at all times keep confidentiality in respect to the information that is accessible and worked with in the Merlin System and its associated technologies
Expected to understand and interpret the complexity of the Business Requirements for this reporting system

This position will not have any direct reports. It may from time to time act as a subject matter expert or technical/functional lead on project type work where oversight might be necessary on a small team of individuals.

Back to top