Data Warehouse Engineer

Job Overview

This is an exciting opportunity for an experienced Data Warehouse Developer to join our expanding IT team responsible for the development and maintenance of our mission critical applications.The successful candidate will be a key member of the DWH Development Team and should be passionate about Data Warehousing, have experience through all aspects of the Standard Development Life Cycle and keeps abreast of emerging trends in the DW/BI domain. The role requires the development of data warehouses ETL processes and data marts, both on premise and public cloud. The role also requires interaction with stakeholders and management to deliver strategic solutions and ensure any new solutions can be tactically reconciled against legacy reports.

This is a hybrid role (based in Head Office, Dublin 12).

Job Responsibilities

• 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.  

Education

• Third Level Qualification in Computer Science / IT or relevant work experience.

Experiences

• Advanced knowledge of SQL including complex stored procedures, functions, query optimization, indexing strategy.
• 3+ years of data engineering experience with hands-on exposure to working with SSIS and SQL Server Database.
• ETL/ ELT design and development experience.​​​​​​
• Strong experience with data quality.
• Proven track record in delivering scalable and reliable Data Warehouse solutions.
• Strong data modelling and dimensional modelling skills (including slowly changing dimensions).
• Experienced in designing, building and maintaining large/complex Data Warehouse systems is desirable.
• Experience with Tableau is also desirable.

Competencies

• 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.

Footer