Senior Business Intelligence Specialist

Found in: beBee jobs CA - 2 weeks ago


Toronto, Ontario, 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.


  • Business Intelligence Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, 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 – Senior

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Company DescriptionArthur Grand Technologies ) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who...

  • Senior Consultant, Business Intelligence

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada Carpedia International Full time

    Senior Consultant, Business IntelligenceCarpedia International is an operations-based management consulting firm where our teams have an opportunity to help client organizations achieve substantial gains in performance and profitability. We implement tangible and sustainable performance, process and people changes to better align our client-organizations. We...

  • Business Intelligence Analyst

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada Exchange Solutions Full time

    The Senior Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, Business Intelligence Analytics.The individual will be responsible for managing and delivering responsibilities related to reporting and analytics needs. The analyst will work closely with other teams and be responsible for analytics and...

  • Senior Technical Producer

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada People Can Fly Studio Full time

    Our central production team is looking for a Senior Technical Producer, Production Intelligence specializing in project management and data insights. You’ll be traversing multiple teams to create production intelligence systems that help grow our game team’s ability to deliver stunning games to market. This is a broad and horizontal role that will help...

  • Senior Business Analyst

    Found in: beBee jobs CA - 4 days ago


    Toronto, Ontario, Canada Ontario Health Full time

    At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value.How we work...

  • Senior Security Platform Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada Akkodis Full time

    Role: Senior Security Platform SpecialistLocation: Toronto, Ontario, CanadaDuration: 11 Months (Hybrid)Key skills:• 5+ years of IT experience, with a minimum of 3 years of hands-on experience deploying, configuring, and troubleshooting Microsoft Sentinel SIEM and Microsoft Defender.• An understanding of threat detection and response is critical,...

  • Senior Underwriting Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada The Mirillion Group Full time

    Position Overview:We are actively looking for an accomplished Senior Underwriting Specialist or Senior Underwriter to join this fantastic Insurance Firm with a great reputation in the market. The right candidate will be responsible for underwriting and profitably growing a portfolio of property business including P&C Package within the Ontario and Atlantic...

  • Business Development Specialist

    Found in: beBee jobs CA - 1 day ago


    Toronto, Ontario, Canada Holland Bloorview Kids Rehabilitation Hospital Full time

    Position title: Business Development Specialist - Commercialization and MRI Services Status: Temporary Full-time (1.0 FTE) Start date: July 2, 2024 Lab/Team: Commercialization Supervisor: Sharon Wong (Director, Commercialization) Program: Bloorview Research Institute Join us in building a world of possibility Holland Bloorview Kids Rehabilitation Hospital is...

  • Senior Sales Innovation Specialist f/m

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada EightSix Network Inc Full time

    Our client, a leading packaging solutions provider, specializes in manufacturing high-quality shrink sleeve labels, folding cartons, stand-up pouch filling, labels, co-packing, and related services. With a commitment to innovation and quality, we are poised for growth and expansion into new sectors We are seeking a dynamic and results-driven Senior Sales...

  • Senior Business Consultant

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Are you a dedicated professional with experience in business analysis, technology/IT, process re-engineering, change management and strategic planning and analysis? Do you have strong communication and stakeholder/relationship management skills? Are you interested in making a difference to vulnerable people in Ontario by helping to lead enterprise-wide...

  • Specialist Cyber Operations

    Found in: beBee jobs CA - 1 week ago


    Toronto, Ontario, Canada Air Canada Full time

    Job Description Description Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.The Cyber Security Operations Centre Specialist will be working in a fast paced and innovative...

  • Senior Social Sector Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada HelpSeeker Technologies Full time

    HelpSeeker is a technology company leading the way in developing innovative solutions to tackle social, municipal, and governmental challenges. Our mission is to empower non-profits, charities, and government bodies with cutting-edge technology to drive significant social impact. We are looking for a Senior Social Sector Specialist with a strong background...

  • Senior Sustainability Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada M Moser Associates Full time

    At M Moser Associates we believe a healthy business has workplaces rooted in sustainability and employee wellbeing. As a leading global workplace design company, our innovative projects have enhanced how people interact with their work environment to achieve business, people, space and brand objectives, for over 40 years. We have diverse capabilities in...

  • Sr Data Specialist, Corporate Actuarial

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Definity Careers Full time

    The Senior Data Specialist is an innovative and experienced data professional with expertise in collection, processing, and transformation of data used for modelling, analysis, and reporting purposes.Reporting to the Director, Special Projects, the Senior Data Specialist will be an integral part of an innovative, project-based team that translates business...

  • Senior Security Infrastructure Specialist

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Ombudsman Ontario Full time

    Effective January 1st, 2024 the salary range for this position is $1,852.71 to $2,314.51 per week in compliance with OPSEU Unified Bargaining Unit collective agreement provisions. The new rates, effective retroactive to January 1, 2024, were recently confirmed and dates for implementation of the new salary rates are still to be determined.The Ministry of...

  • Senior Data Analyst

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Microsoft Canada Full time

    OverviewMicrosoft's mission is to empower every person and every organization on the planet to achieve more. As employees we come together with a growth mindset, innovate to empower others, and collaborate to realize our shared goals. Each day we build on our values of respect, integrity, and accountability to create a culture of inclusion where everyone can...

  • Senior Business Partner

    Found in: beBee jobs CA - 6 days ago


    Toronto, Ontario, Canada Ontario Health Full time

    At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value.How we work...

  • Decision Support Specialist

    Found in: Adzuna CA C2 - 3 days ago


    Toronto, ON, C6A, Ontario, Canada St. Mary's General Hospital Full time

    Position: Decision Support SpecialistDescription: Permanent Full Time (Remote with Potential for Hybrid)St. Mary’s General Hospital’s renewed vision of ‘Inspiring excellence. Healthier Together’ lays out a plan for growth, and innovation that will keep pace with the community and region that it serves. It also reflects our strong culture and values...

  • Technical Specialist

    Found in: beBee jobs CA - 2 weeks ago


    Toronto, Ontario, Canada Vector Institute Full time

    JOB DESCRIPTIONTechnical Specialist POSITION SUMMARY The Vector Institute is an independent, not-for-profit Canadian corporation dedicated to AI research. We work across sectors to advance AI application, adoption, and commercialization across Canada. We are seeking a Technical Specialist to join our growing Business Computing team in Toronto. The...