My Dublin based Financial Services client is looking for a Data Warehouse Developer to join the team for a permanent position.
-Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked.
-Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
-Work with business analysts and project managers to develop and refine reporting and analytics requirements.
-Work on complex projects that require both depth and breadth of knowledge in a number of technologies and the business.
-Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
-Assist in planning sessions with the business users to analyze business requirements, and provide design recommendations.
-Write concise and clear technical specifications based on analysis of complex business requirements.
-Translate business and technical requirements into business application systems.
-Develop and modify complex software systems using disciplined software development processes.
–Advanced knowledge of SQL including complex stored procedures, functions, query optimization, indexing strategy.
-3+ years of experience of SSIS and SQL Server Database.
-Experience with overall Data Warehouse infrastructure capacity planning and scaling.
-Proven track record in delivering scalable and reliable DW solutions.
-Strong data modelling and dimensional modelling skills (including slowly changing dimensions).
-Experience with data quality and data profiling.
-ETL/ELT design and development experience.
-Experienced in designing, building and maintaining large/complex DW systems is desirable.
-Experience with Tableau is also desirable.
Essential and Desirable Skills:
-Delivery focused with a strong aptitude for team motivation
-Highly organised and structured approach to working
-Strong analytical skills that ensure projects are delivered to an accurate and high quality standard.
-Ability to work effectively in a team environment.
-Superb oral/written communication skills.
-Third Level Qualification in Computer Science / IT or relevant work experience.
-MS certifications desirable
-Standard working week.