Software Developer (RQ08738)

  • Contract
  • Toronto
  • Applications have closed

Ministry of Health

Description

NOTE

Assignment Type: This position is currently listed as “Hybrid” and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be at the Hiring Manager’s discretion.

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on April 3, 2026. HSC may exercise its option(s) to extend a SOW beyond April 3, 2026. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.

 

The resources needed till March 31, 2027, will include an option to extend, at the same rate, until March 31, 2027 if Tender_12075 Managed Service Provider for Contingent IT Resources is also extended for a further one year, else an RFS under the Successor VOR will be issued for the services required April 4, 2026 to March 31, 2027.

==================================================================

Responsibilities:

  • Prepare a detailed BI user requirement document and applicable documentation.
  • Prepare the database design/structure document based on the requirement
  • Design and build the dimensional data model for Data Warehouse and Data Mart
  • 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
  • Create use cases for each of the requirement
  • Design, build, test predefined reports
  • Create reports using Cognos Analytics V12.x
  • Test, Debug and resolve BI reporting issues
  • Document test cases to ensure expected functionality test is completed
  • Deploy reports using COGNOS Framework Manager
  • Develop SQL, PLSQL and Redshift SQL process and procedures to implement complex logic 
  • Assist with SQL tuning and optimization activities related to the Cognos reports
  • Help to optimize the SQL, PL/SQL and Redshift SQL process for optimal report performance    
  • Prepare scripts and documentation for the data preparation process and regular performance check & monitoring
  • Support user testing and system implementation.
  • Train SMEs or conduct demos on Ad hoc reporting
  • Any other enhance requests and deliverables, such as Ontario Health region alignment in Cognos, as assigned by the Project/Resource Manager
  • Knowledge transfer to HSC staff.

Skills
Experience Requirements

Public Sector Experience

·     Experience with Public Sector processes around incident and change
management. Knowledge of Public Sector Enterprise Architecture artifacts (or
similar), processes and practices, and ability to produce technical
documentation that comply with industry standard practices

5
points

Technical Skills

·    
Experience in designing and developing
Data Marts or Data Warehouses on a wide- range of data repositories
(relational and multi-dimensional data stores)

·    
Experience in Framework Manager
modelling, database design/data model design, point-in-time architecture, and
dimensional model (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 various

·    
In-depth knowledge and experience with Cognos report
development, testing and server management in Cognos Analytics and
Administration v12.x

·    
Knowledge of Power BI and Tableau

·    
Knowledge of BI architecture patterns, best practices,
processes, and artefacts

·    
Experience with Agile/scrum and
waterfall methodologies, using tools such as JIRA and Confluence

·    
Linux Experience

·    
Cloud Experience (Azure, AWS)

40
points

Core
Skills and Experience

·    
In-depth knowledge and experience with
Cognos report development, testing in Cognos Analytics v12.x (5+ years)

·    
Experience in overall administration,
configuration, deployment, security, and maintenance for the Cognos
environment

·    
Experience in Oracle 19 or higher and
Redshift  including writing complex SQL
queries and materialized views

·    
Experience in Cognos and database
performance and tuning skills

·    
Expert Cognos development skills,
specifically Report and Query Studio, and ability to write JavaScript in
reports

50
points

Consulting
& communication skills

·    
Proven critical
thinking, analytical and problem solving skills

·    
Excellent verbal
and written communication skills.

·    
Strong
communications skills to engage with all stakeholders.

·    
Proven track
record for building strong working relationships.

·    
Excellent customer
service skills, including tact and diplomacy to ensure client needs are
managed effectively

·    
A motivated,
flexible, creative team player with perseverance, excellent multi-tasking
abilities and a proven track record for meeting strict deadlines.

5
points

Supplier Comments

Closing Date: 2025-03-17, 11:00 a.m.

Maximum Number of Submissions – one (1)

Hybrid – Candidate must be able to work 3 days onsite and 2 days remote

MUST HAVES:

In-depth knowledge and experience with Cognos report development, testing and server management in Cognos Analytics and Administration v12.x

 

Experience in Oracle 19 or higher and Redshift including writing complex SQL queries and materialized views

 

 

 

This entry was posted in . Bookmark the permalink.
HR