About the job RQ08738 - Software Developer - Senior

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

Build the security model for the BI implementation

Create metadata, user groups and folder structure for BI objects

Design, build, test predefined reports

Test, Debug and resolve BI reporting issues

Document test cases to ensure expected functionality test is completed

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.

Any other enhance requests and deliverables, such as Ontario Health region alignment in Cognos, as assigned by the Project/Resource Manager

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

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

In-depth knowledge and experience with Cognos report development, testing and server management in Cognos Analytics and Administration v12.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

Cloud Experience (Azure, AWS)

In-depth knowledge and experience with Cognos report development, testing in Cognos Analytics v12.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

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, adaptable, creative team player with perseverance, excellent multi-tasking abilities and a proven track record for meeting strict deadlines.

report development, testing and server management in

Experience in Oracle 19 or higher and

including writing complex SQL queries and materialized views

#

📌 Senior Software Engineer - Configuration (Toronto)
🏢 Rubicon Path
📍 Toronto