Senior SQL BI Developer - SSIS

Our client employs over 1000 staff, has won awards for both their product and their customer services and generate revenues of €600m. They have created a challenging, fast-paced work environment. They believe they make a positive difference to their customers and they encourage all teams to strive for this goal. They have created a fun, encouraging place to work and place a strong emphasis on teamwork as well as individual achievement

Job Title: Senior BI Integration Developer

Role Purpose: The ideal candidate will carry out extensive ETL development to integrate data from various source systems, and transform according to the underline business logics. Additionally, responsible for plan and develop an ETL framework.

5 main Key Performance Indicators (KPIs) of the role:

*Design ETL flow from micro design and plan and execute the development based on the best practices.
*Design and implement an ETL framework and packages
*Perform unit test against detail requirement and make sure the accuracy of the functionality.
*Needs to understand complex requirements and translate into development
*Required to work as part of a development team and sometimes work as own.

Skills and Experience:

5 years+ experience of delivering Business Intelligence solutions using:
*MS Integration Services (SSIS) including development of full DW ETL Solutions
*Excellent skills in T-SQL Development using queries and stored Procedures (MS SQL Server 2008R)
*MS Reporting Services (SSRS) including development of complex reports
*MS Analysis Services (SSAS) for complex cube reporting solutions
*Hands-on experience with relational and dimensional databases, Data modelling and SQL
*Using SSIS to generate complex data feeds to downstream systems
*Excellent skills in Data Integration and Data transformations
*Microsoft certification of MCTS or MCITP in SQL server 2008 / 2005

Fit:

*Able to work well in high growth, fast paced environment which can lead to change, opportunities and ambiguity
*Able to work in a team in a diverse and multinational environment
*Hands on and operationally capable, irrespective of role profile.
*Can go above and beyond and has ability to work in high performance demanding environments