01JUN2019 - JOB - Business Intelligence Developer - Peninsula Petroleum - Dublin, Ireland
Job description
Peninsula Petroleum is a leading integrated marine fuels supplier with a global presence. We are seeking a BI Developer to join our team in Dublin. The ideal candidate will have experience in SQL and Data Warehousing & Reporting and will be responsible for constantly monitoring our databases and immediately addressing database issues and problems. The successful candidate will also submit reports to management that outline the changing data needs of the company and come up with related solutions.
Main Duties and Responsibilities:
1. Develop and maintain ETL Packages using Microsoft SQL Server 2008 R2/2014 Integration Services.
2. Develop Reports using Microsoft SQL Server 2008 R2/2014 Reporting Services.
3. Develop SQL Procedures/Functions.
4. Design, Develop and Implement technical solutions based on business requirements.
5. Database performance tuning including TSQL / Procedural performance tuning (Optimizer and Index usage).
6. Responsible for middleware design, monitoring and maintenance Database documentation.
7. Perform analytical testing and investigative work.
8. Proposing system improvements.
What we are looking for:
1. Strong analytical skills.
2. Ability to think logically and be proactive.
3. Ability to work as part of a team and on own initiative in a constructive manner.
4. Flexible and self-motivated.
5. Work on multiple projects and use strong time management skills and prioritise your workload accordingly.
6. Strong knowledge of application development methodologies.
7. Excellent oral and written communication skills.
Professional Qualifications:
1. Approx 2 Years experience with all aspects of MS Reporting Services, including setup, security, deployment and complex report development using Business Intelligence Development Studio.
2. 1-2 Years ETL experience with SSIS.
3. Experience working with large complex SQL Server Databases.
4. Data Modelling.
5. Relational Database Design.
6. Database Application Development and Database performance tuning.
7. Microsoft - SQL Server / Transact SQL Server / Data Warehousing & Reporting.
8. Development of OLAP cubes using SSAS.
9. Report development in Excel, Tableau.
10. Microsoft Certified in Business Intelligence will be added advantage.
11. Degree in Computer Science / Information Systems Design or equivalent.
12. Excellent troubleshooting and problem-solving skills with good attention to detail.
#J-18808-Ljbffr