Test Triangle

Business Intelligence Analyst

Test Triangle Longford, Longford, Ireland

IT Services and IT Consulting · 51-200 employees

Yesterday
Senior (5-10 yrs) Contractor Full-time Ireland
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The BI Analyst will design, implement, and manage end-to-end Cognos BI reporting and ETL environments while maintaining Tableau dashboards. They will also provide 2nd level support, troubleshoot performance issues, and collaborate with business owners to deliver data-driven reporting solutions.

What they look for

IBM Cognos Tableau ETL Oracle DB PL/SQL SQL Data Analysis Data Mapping Windows Server IIS TOAD for Oracle SSRS Data Warehousing Batch Scripting Disaster Recovery Data Security

Requirements

Candidates must have 4-6 years of professional experience and hold a qualification equivalent to European NFQ level 7. Proficiency in IBM Cognos, Tableau, Oracle databases, and SQL is mandatory for this role.

Full description

Job Title: Business Intelligence Analyst

Office Location: Longford, Co Longford, Ireland (Hybrid working Model minimum 1 day per week onsite in Longford)

Contract Start Date: 16th of February 2027.

Contract or Permanent : Contract Min 12 months or Permanent with Test Triangle Ltd , Ireland

Nature of the Service:

The Client currently utilises Cognos Business Intelligence (BI) as its business intelligence platform. The BI Analyst will be a member of the ICT Development Team, providing essential Business Intelligence services and support to IPS business units and prison-based end users. The post holder will report directly to the Higher Executive Officer within the ICT Development Team.

The role requires the ability to draw upon previous experience, technical knowledge and professional expertise to address business and technical challenges. The successful candidate will be expected to demonstrate an innovative and creative approach to technical problem-solving, while ensuring the effective delivery of BI services across the organisation.

Requirements

​

Minimum or Mandatory Requirements (Pass/Fail)

ü Experience level required

It is a mandatory requirement that the Resource proposed has the equivalent of intermediate level experience, i.e. has 4-6 years’ substantial professional experience in this Role, No other experience levels will be accepted.

ü Qualifications

It is a mandatory requirement that the Resource proposed hold the following qualifications or equivalents:

The Resource must have as a minimum, qualifications in a relevant field which is equivalent to European NFQ level 7

ü Language Requirements

Fluent English language skills

Key Deliverables

The following non-exhaustive list of Key Deliverables are applicable to this Role.

Client operates a large Cognos BI and Tableau environment. Key functions of the role include:

· Design, document, implement and manage end-to-end Cognos BI reporting and ETL environments

· Control user access permissions and privileges to Cognos BI & Tableau environments

· Maintain and support dashboards in Tableau.

· Troubleshoot and solve performance issues of the Cognos BI reporting, Tableau and ETL environments.

· Monitor and support Disaster Recovery environment.

· Monitor and manage data merging and data replication to the reporting data warehouses

· Communicate effectively with business owners, Prison staff and ICT teams to gather and analyse requirements in order to develop and deliver well-defined Cognos reports that can be used to make sound business decisions

· Check and analyse reporting data to maximise accuracy, reliability, efficiency and performance.

· Communicate effectively and liaise with business owners, .Net Development team and Project Managers. Resolve 2nd Level Support Service Requests assigned by Helpdesk in a timely fashion

· Check and analyse reporting data to maximise accuracy, reliability, efficiency and performance.

· Communicate effectively and liaise with business owners, .Net Development team and Project Managers. Resolve 2nd Level Support Service Requests assigned by Helpdesk in a timely fashion.

Key Experience/Competencies/Skillsets

The following Experience/Competencies/Skillsets are applicable to this Role:

The CV set out in the Tender Response Document, must clearly and comprehensively demonstrate the Resource’s experience with the following:

· IBM Cognos Report.Net, IBM Cognos 10/11/12 BI, Windows Server 2003 – 2022, IIS 6.0 - 8.5, and TOAD for Oracle (versions 9.6 – 16.3), Tableau most recent versions (2022.3.0). Experience in data source connections, Experience of Data Analysis and data mapping skills.

· Experience of RDBMS Systems including Oracle DB Server Version 9 – 19, Oracle Enterprise Manager, Oracle PL/SQL (version 19), Oracle Apex, T-SQL/SSRS, SQL and MS SQL Server 2022 Cluster.

· Extract, Transform & Load of Data (ETL), Data Replication specifically Materialized View and custom replication methods, experience in creating Large Data marts, Batch Scripting automation, SQL Loader and previous experience of working in a secure environment. Experience in Data Security and user setups (Cognos & Tableau).

​