BUSINESS INTELLIGENCE SPECIALIST

Business Intelligence Specialist

Key Responsibilities:
General

Develop and maintain stored procedures, functions and views in SQL Server and DB2.
Performance tuning and query optimisation of existing database objects.
Create, monitor and maintain SQL Server Agent jobs.
Any other tasks as assigned by management.

SQL Administration

Monitor and maintain backup schedules.
Database performance, tuning and scaling.

Crystal Reports

Develop highly formatted crystal reports.
Publishing, maintaining and scheduling these and other reports on Infoview.

SAP BI

Building, updating and maintaining Bex Analyser reports.
Performance tuning of reports in DB2.
Building and monitoring ETL/Process chains.
Develop and edit data sources, infosources, infoobjects, infoproviders and multiproviders.

Requirements:

Essential

5 years of Business Intelligence/Datawarehousing, preferably SQL Server and DB2.
Experience developing highly formatted Crystal Reports.
Experience with SAP BI desirable, full training will be provided if not a current skill
Experience of publishing, maintaining and scheduling these reports on Infoview.
Ability to develop and maintain complex stored procedures for reports.
Excellent verbal, written, communication /interpersonal skills.
Be highly motivated and ambitious, a self starter with a can do attitude.
Problem solving and decision making capabilities.
Customer Service Awareness.

Desirable
SQL Server 2005/2008 experience.
DB2 Experience.
Ability to performance tune and perform query optimisation of existing database objects.
Experience in the development and maintenance of large databases.
Experience building, updating and maintaining of SAP BI Bex Analyser reports.
Experience of workbook development and report broadcasting.
Experience building and monitoring ETL/Process chains.

Role Information :
This is a permanent position based in Galway.