Software Developer RQ06826
Assignment Type: Hybrid. 5700 Yonge Street 3 days a week.
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 V11.1.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 deliverables as assigned by the Project/Resource Manager
Knowledge transfer to HSC staff.
Skills - 5 points total
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 - 40 points total
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 v11.1.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)
Core Skills and Experience - 50 points
In-depth knowledge and experience with Cognos report development, testing in Cognos Analytics v11.1.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
Consulting & communication skills - 5 points
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/Time
2024-02-02, 12:30 p.m.EST
Note:
Must haves:
In-depth knowledge and experience with Cognos report development, testing and server management in Cognos Analytics and Administration v11.1.x
Experience in Framework Manager modelling, database design/data model design, point-in-time architecture, and dimensional model (5+ years)
Experience in Oracle 19 or higher and Redshift including writing complex SQL queries and materialized views
