Data Warehouse Developer

Reference: AH11
Sector: Data
Job Type: Permanent
Consultant: Adam Hughes
Adam Hughes

The Opportunity

My client is looking for an experienced Data Warehouse Developer to a DWH Development team. The role requires the development of data warehouses, data marts and ETL processes. You will interact with stakeholders and management to deliver strategic solutions and ensure any new solutions can be tactically reconciled against legacy reports.

The Role

Here is some of what you will be doing:

  • 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.
  • Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
  • Develop and modify complex software systems using disciplined software development processes.
  • Write concise and clear technical specifications based on analysis of complex business requirements.
  • Translate business and technical requirements into business application systems.
  • Assist in planning sessions with the business users to analyse business requirements, and provide design recommendations.

Candidate Profile / Experience

  • 3+ years of experience of SSIS and SQL Server Database.
  • Advance SQL
  • ETL/ELT design and development experience.
  • Experience with overall Data Warehouse infrastructure capacity planning and scaling.
  • Strong data modelling and dimensional modelling skills
  • Proven track record in delivering scalable and reliable Data Warehouse solutions.
  • 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.

Please note only candidates that match the minimum job requirements above will be contacted for this role.

As per our privacy statement, all data will be held on file by Red Tree Recruitment for a period of 3 years. By sending your CV to Red Tree Recruitment, you are consenting to this. If you wish to have your details removed prior to this period, please contact . Please view our privacy policy:

Reward / Package

Excellent package on offer to the successful candidate


Consultant: Adam Hughes

Adam Hughes, Principal Consultant, Data Science & Technical Recruitment, Red Tree Recruitment on + (353) 1 5541293 or email

Please note, this role is only open to candidates who hold an EU passport or valid stamp 4 visa.