RQ08738 - Software Developer - Senior
RQ08738 - Software Developer - Senior
Posted on :
13-03-2025
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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.
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Indepth 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
Skill Set 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
Technical Skills:
- Experience in designing and developing Data Marts or Data Warehouses on a wide range of data repositories (relational and multidimensional data stores)
- Experience in Framework Manager modelling database design/data model design pointintime 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
- Indepth 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)
Core Skills and Experience:
- Indepth 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
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 multitasking abilities and a proven track record for meeting strict deadlines.
Experience and Skill Set Requirements: 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 Skill Set 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 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) 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 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.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
