Senior Business Intelligence Specialist

Found in: beBee S CA - 3 weeks ago

Toronto, Canada GTT, LLC Full time

Senior Business Intelligence Specialist

Overview:
In line with the Ontario Digital services cloud-first adoption strategy, all Cognos Business Intelligence (BI) applications deployed on the Business Intelligence/Business Analytics (BI/BA) platform using BIDA (Business Intelligence and Data Analytics) data repository and hosted by ITS on traditional I&IT systems are to be modernized and migrated to Cloud Pak for Data Platform (CP4D) hosted in GO Cloud Amazon Web Services (AWS).
To support this project, we need a Senior Business Intelligence Specialist (FFS) with strong Cognos development and AWS Redshift experience. The resource will help the team with the following tasks:
Mentor and support our Cognos developers in their transition to the Cloud version
Help with Cognos reports code conversion from on-premises environment to CP4D on AWS
Update embedded SQL code in Cognos reports from Oracle to AWS Redshift
Support the issues encountered during the Cognos migration
Provide knowledge transfer to other team members as needed.

Job Responsibilities:

The Senior Business Intelligence Specialist prepare a detailed BI user requirement document
Document the new requirements and complete the analysis and design document
Convert the user requirements into a business model for Cognos BI
Convert the business model into Framework Manager Models
Build the security model for the BI implementation
The Senior Business Intelligence Specialist will create metadata, user groups, and folder structure for BI objects
Migrate standard reports from Cognos v11.1 on-premises to Cognos v11.2 on Cloud Pak for Data on Amazon Web Services (AWS)
Develop reports in Cognos on Cloud Pak for Data and AWS Redshift database
Test, debug, and re-engineer standard reports and dashboards in Cognos on AWS
Convert Dynamic Cubes functionality to DMR or Transformer Cubes without any loss in performance
Document test cases to ensure the expected functionality of the reports
Deploy reports using Cognos Framework Manager
Develop SQL and PLSQL processes 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 staff in the form of a detailed guide or as per project requirements.

Must-Have:

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)
Experience in AWS Cloud technologies, specifically AWS Redshift
Experience in Cognos migration and testing skills (reporting, dashboarding, embedded JavaScript, embedded SQL)

Evaluation Criteria
Public Sector Experience
Experience working in the OPS and familiarity with I&IT project management processes

Technical Skills:
Experience in the 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, generate scripts, and apply 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:
Proven troubleshooting and critical thinking skills
Strong interpersonal skills with the ability to work with client stakeholders to understand, and interpret business requirements and their technical implications.
Demonstrated ability to present technical solutions to client stakeholders, technical staff, and 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.

Notes:
Hybrid role - 3 days per week in the office required.

  • Senior Business Intelligence Specialist

    Found in: beBee jobs CA - 2 weeks ago

    Toronto, Ontario, Canada GTT, LLC Full time

    Senior Business Intelligence SpecialistOverview:In line with the Ontario Digital services cloud-first adoption strategy, all Cognos Business Intelligence (BI) applications deployed on the Business Intelligence/Business Analytics (BI/BA) platform using BIDA (Business Intelligence and Data Analytics) data repository and hosted by ITS on traditional I&IT...

  • Senior Business Intelligence

    Found in: Talent CA 2 C2 - 1 week ago

    Toronto, Canada CB Canada Full time

    Senior Business Intelligence (BI) Specialist On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior Business Intelligence (BI) Specialist. Senior Business Intelligence (BI) Specialist – Job Description Work with project teams to ensure successful release of Business Intelligence reporting using Power BI Use Power Query to...

  • Business Intelligence Specialist

    2 days ago

    Toronto, Canada Transatlantic Business Consulting Inc. Full time

    Our government client requires a Senior Business Intelligence Specialist/ Expert to help build a new data warehouse/lakehouse and deliver the reporting MVP (minimum viable product). **Data Warehouse/Lakehouse Concepts**:Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data...

  • Business Intelligence Specialist

    4 days ago

    Toronto, Canada Altus Group Full time

    Job Category: Software Opportunity Awaits at Altus Group! The Opportunity This is your chance to develop, build, and grow business intelligence at a global tech company. In this role, you will work closely with teams across the organization, translating their business needs into BI and Analytics solutions. As our next BI Specialist, you will deliver...

  • Business Intelligence Specialist

    3 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Business Intelligence Specialist - Senior** **Location: 21 College suite 300, Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 3-5 years of experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards - Demonstrated experience with M, DAX and Power Query - Demonstrated...

  • Business Intelligence Specialist

    10 hours ago

    Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ06224 - Business Intelligence Specialist - Senior** **Start Date: 2023-11-27** **End Date: 2024-03-31** **Office Location: 125 Sir William Hearst Ave., Toronto** **Organization: Children, Youth & Social Services Cluster** **Ministry: Ministry of Children, Community and Social Services** **# Business Days: 90.00** **Title: Business...

  • Business Intelligence Specialist

    10 hours ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist **for one of our clients. **Position: Business Intelligence Specialist - Intermediate** **Location: Toronto, Ontario (Hybrid)** - 3 days a week** **Duration: Long Term Contract** **Must Haves**: - Power BI Experience - Microsoft Dynamics - 5...

  • Business Intelligence Specialist

    2 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist - Senior **for one of our clients. **Position: Business Intelligence Specialist - Senior** **Location: Toronto, ON (Hybrid)** **Duration: Long Term Contract** **Must haves**: - Data Warehouse/Lakehouse Concepts: Strong understanding of data...

  • Business Intelligence Specialist

    1 week ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation and...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    9 hours ago

    Toronto, Canada TD Bank Full time

    **TD Description** Stay current and competitive. Carve out a career for yourself. Grow with us. **Department Overview** What does TD Data & Analytics stand for? For starters, we believe in visionary leadership and insights. We believe in using every resource at our disposal to better serve our clients, and this includes our vast data. Key objectives...

  • Business Intelligence Specialist

    Found in: Appcast CA C2 Glassdoor - 2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Whatjobs CA C2 - 2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Appcast CA A2 P - 1 week ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Talent CA 2A C2 - 2 weeks ago

    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Jooble CA C2 - 1 week ago

    Toronto, ON, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...