BI Cognos Developer

Ventures Unlimited Inc; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

A leading IT firm is looking for a BI Cognos Developer in Toronto. The successful candidate will analyze business requirements and implement effective BI solutions using Cognos along with extensive experience in data analysis. This hybrid role combines in-office collaboration with remote work, ensuring a supportive environment for innovative IT development.

Qualifications

• 5+ years of business intelligence experience required.
• 5+ years of Cognos experience essential.
• Experience with relational databases like DB2, Oracle, MS-SQL.

Responsibilities

• Analyze business requirements and liaise with clients.
• Facilitate IT development and design web-based applications.
• Conduct testing and system support/documentation.

Skills

Business Intelligence

Cognos

Data Analysis

Database Understanding

Education

IBM Certified Designer – Cognos 11.2.1 BI Reports

IBM Certified Developer – Cognos 11.2.1 BI Metadata Models

IBM Certified Administrator – Cognos 11.2.1 BI

Job description

Spruce InfoTech, a leading IT firm, offers innovative and cost-effective solutions to help clients manage and transform their businesses. Our services are designed to guide companies of all sizes, from small businesses to Fortune 500 organizations, in maximizing their IT investment while reducing technology costs. Our team of experts has extensive technical knowledge in enterprise solutions, which helps organizations transform these solutions into a strategic asset that can drive new revenue and improve business operations.

Website

Job Description

Assignment: RQ09423 – BI Cognos Developer
Office Location: 222 Jarvis St. Toronto

Hybrid - 3 days in office, 2 days work from home

Description

• Analysis of business requirement documents and liaison with clients.
• Facilitating IT development, design, construction, testing, promotion, implementation of web-based/n-tier, cloud-based and mainframe applications
• Define standards for the integration and governance of enterprise data
• Design metadata management programs and scripts
• Define and evaluate conceptual, logical, and physical BI solution architectures
• Design healthcare business information structures (cubes, dimensions, facts, tables, etc.)
• Perform data quality assessments, data transformation, and data cleansing
• Develop test scripts and perform testing of BI solutions
• Responsible for integration of Open Source Software (OSS) products into new and existing systems
• Creation and walk-through of Systems Response documents, Technical Specifications, Application Inventory, and Implementation Plans.
• Preparation of test plans, test data, and unit-testing of programs.
• Preparation of implementation plans and promotion of programs.
• System Support/Documentation
• As assigned, response to client queries and troubleshooting of production incidents.
• Conduct/participate in design walkthroughs as well as test case and test results walkthroughs.
• Support testing of the changes by other team members.
• Weekly reporting on status, progress, and key issue/concerns as directed by the Project Lead/Project Manager or Portfolio Manager

MUST HAVES

5 + more years of business intelligence experience

· 5 + years of Cognos experience

· 5+ years – Framework Manager and Report Studio

· 5+ years – Active Reports, Transformer and dashboarding

· 5+ years – Report Studio (including being a trainer/mentor)

· 3+ years – Metrics Studio

· 5 years data analysis experience

· IBM Certified Designer – Cognos 11.2.1 BI Reports

· IBM Certified Developer – Cognos 11.2.1 BI Metadata Models

· IBM Certified Administrator – Cognos 11.2.1 BI

Experience with, and understanding of, relational databases (DB2, Oracle, MS-SQL)

· Preparation of test plans, test data, and unit-testing of programs

· Preparation of implementation plans and promotion of modules

· Participate in business requirements walkthroughs

· Conduct/participate in design walkthroughs