At a Glance
- Tasks: Transform user requirements into impactful business intelligence solutions using Cognos and AWS.
- Company: Join a forward-thinking public sector organization focused on innovation.
- Benefits: Enjoy competitive pay, health benefits, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous learning and career advancement.
- Why this job: Make a difference by leveraging data to drive decision-making in the public sector.
- Qualifications: 5+ years in BI development, strong SQL skills, and experience with AWS Redshift.
The predicted salary is between 82800 - 101200 $ per year.
About the job
Responsibilities:
- Document the new requirements and complete analysis and design document
- 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
- Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
- Test, debug, re-engineer standard reports and dashboards in Cognos on AWS
- Support converted Dynamic Cubes functionality in DMR or Transformer Cubes without any loss in performance
- Document test cases to ensure expected functionality of the reports
- Deploy reports using Cognos Framework Manager
- Develop SQL and PLSQL process and procedures to implement complex logic
- Assist with SQL tuning and optimization activities related to the Cognos reports
- Help to optimize the SQL and PL/SQL process for optimal report performance
- Prepare scripts and documentation for the data preparation process and regular performance checks & monitoring
- Support user acceptance testing and system implementation
- Train SMEs or conduct demos on self-serve BI reporting
- Any other deliverables as assigned by the Project/Resource Manager
- Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements
Skills Experience and Skill Set Requirements:
- Public Sector Experience: Experience working in the Public Sector and familiarity with I&IT project management processes
- Technical Skills: Experience in design and development of Data Marts or Data Warehouses on a wide range of data repositories (relational and multi-dimensional data stores)
- Experience in Cognos Analytics reporting; modeling with Framework Manager, Transformer, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture; testing with Life Cycle Manager (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
- Knowledge of BI architecture patterns, best practices, processes, and artefacts
- Experience developing Cognos reports in the IBM Cloud Pak for Data environment
- Core skills, database and domain knowledge: Experience in Oracle 19 or higher including writing complex SQL/PL SQL queries and materialized views
- Experience in AWS Cloud technologies, specifically AWS Redshift
- Experience in database performance and tuning skills
- Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence
General Skills:
- Proven troubleshooting and critical thinking skills
- Strong interpersonal skills with ability to work with client stakeholders to understand, interpret business requirements and its technical implications
- Demonstrated ability to present technical solutions to client stakeholders, technical staff and to senior management
- A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines
MUST HAVES: Experience in AWS Cloud technologies, specifically AWS Redshift
Senior Business Intelligence Specialist in Toronto employer: Rubicon Path
As a Systems Testing/QA Specialist at our Toronto location, you will thrive in a collaborative and innovative work culture that prioritizes quality and continuous improvement. We offer competitive benefits, opportunities for professional growth, and a commitment to work-life balance, ensuring that you can excel in your role while contributing to meaningful projects that impact the community. Join us to be part of a dynamic team dedicated to delivering high-quality solutions in a supportive environment.
We think you need these skills to ace Senior Business Intelligence Specialist in Toronto
Cognos BI
Framework Manager
Dynamic Cube Designer
Data Module
Dataset
SQL
PL/SQL
