RQ10056 - Business Intelligence Specialist - Senior

4 days ago

Toronto, Ontario, Canada Maarut Inc Full time US$80,000 - US$120,000 per year

Description:

Translate user requirements into a Cognos BI business model and Framework Manager models.
Design and implement BI security model, metadata, user groups, and folder structure.
Develop and optimize Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift.
Test, debug, and re-engineer reports; document test cases for functionality validation.
Create and tune SQL/PLSQL processes for complex logic and performance optimization.
Prepare scripts and documentation for data preparation, performance checks, and monitoring.
Support UAT, deployment, and provide training or demos for self-service BI reporting.
Deliver knowledge transfer and detailed documentation to HSC staff as per project requirements.

Requirements

Experience and Skill Set Requirements:

Must Haves:

In-depth knowledge and experience with Cognos report development in Cognos Analytics v12.x (reporting, dashboarding, embedded JavaScript, embedded SQL) 

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, Dynamic Cube Designer, Data Module, Dataset, SDK; implementing point-in-time architecture
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 v12.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 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 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.

  • RQ10056 - Business Intelligence Specialist - Senior

    4 days ago

    Toronto, Ontario, Canada Maarut Inc Full time US$60,000 - US$120,000 per year

    Description:Translate user requirements into a Cognos BI business model and Framework Manager models. Design and implement BI security model, metadata, user groups, and folder structure. Develop and optimize Cognos reports and dashboards on Cloud Pak for Data and AWS Redshift. Test, debug, and re-engineer reports; document test cases for functionality...

  • Senior Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    We are seeking a Senior Business Intelligence Specialist for a 10-month contract opportunity in Toronto, ON. This is an onsite role.Must haves:Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.Demonstrated experience with data analytics and reporting from Dynamics 365 CE...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada 2iSolutions Inc. Full time $80,000 - $120,000 per year

    **If interested please share your latest resume on RQ Business Intelligence Specialist - SeniorLocation:**Onsite / 595 Bay Street, TorontoStart Date: End Date: Duration: 10-monthMust HavesPower BI:Proficiency in Power BI, includingdata modeling,creating interactive reportsanddashboards, and utilizing advanced features.Demonstrated experience with data...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Bevertec Full time $80,000 - $120,000 per year

    26578BEV123Business Intelligence Specialist - Senior (Power BI, Dynamics, Azure)Toronto, ONContract RoleDuration: Must Haves:Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.Data...

  • Business Intelligence Specialist – Senior

    2 days ago

    Toronto, Ontario, Canada Russell Tobin Full time US$42,000 - US$54,000 per year

    Job Title:Business Intelligence Specialist - Senior (Cognos)**Location: Toronto, ON, CAN (On-Site)Duration: 73 Days (Possible Extension)Client: Public SectorPay Rate: C$80-C$90/hr**Join our dynamic team in Toronto, ON, where innovation meets healthcare technology. We are seeking a skilled individual to translate user requirements into actionable business...

  • Senior Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Randstad Full time $80,000 - $120,000 per year

    Do you have proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features? Do you have demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O? If so, this would be a great opportunity for you Our client is looking for a Senior Business Intelligence...

  • Business Intelligence/Research Specialist

    4 days ago

    Toronto, Ontario, Canada Options Consulting Solutions Full time $80,000 - $120,000 per year

    Research & Business Intelligence SpecialistWe're looking for a skilledResearch & Business Intelligence Specialistto join a collaborative, curious, results driven team. This role is ideal for someone who thrives on transforming data into insights, supporting strategic decision-making, and working closely with employee across an organization.What You'll Do:•...

  • Business Intelligence Specialist

    2 weeks ago

    Toronto, Ontario, Canada Teckhorizon Inc Full time $100,000 - $150,000 per year

    About The RoleOur Client is seeking a Senior Business Intelligence Specialist to support the Office of the Public Guardian and Trustee (OPGT) in building a new Azure-based data warehouse/lakehouse and delivering the Reporting MVP. This is a high-impact role for a seasoned BI professional experienced in Power BI, Dynamics 365 CE/F&O, Azure data engineering,...

  • Senior Business Intelligence Analyst

    4 days ago

    Toronto, Ontario, Canada Alliants Full time $135,000 - $150,000 per year

    Job Description We're Hiring a Senior Business Intelligence Analyst Location: Canada Remote Salary: $135,000 – $150,000 CAD per year Travel: occasional visits to client HQ Washington DC for important planning sessions, and potential client site visitsAt Alliants, we're on a mission to transform every customer engagement into something exceptional. We...

  • RQ09934 - Business Intelligence Specialist - Senior

    2 days ago

    Toronto, Ontario, Canada Maarut Inc Full time $80,000 - $120,000 per year

    Scope:Work with project teams to ensure a successful release of Business Intelligence reporting using Power BI. The resource(s) will be responsible for:Use Power Query to extract data from different data sources and choose a storage mode and connectivity type.  Profile, clean, and load data into Power BI  Design data models that are intuitive,...