Business Intelligence Specialist

Please apply ONLY if you have Public Service Experience in Canada

Experience and Skill Set Requirements:

Public Sector Experience

Experience working in the OPS 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.
• In-depth knowledge and experience with Cognos report development in Cognos Analytics and Administration v11.2.x (reporting, dashboarding, embedded JavaScript, embedded SQL)
• 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 in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)
• Experience with Agile/scrum and waterfall methodologies, using tools such as JIRA and Confluence

General Skills:

• 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.