Data Warehouse Specialist

Data Warehouse Specialist Image
Data Warehouse Specialist

South Dublin



Ref: E9338SPG

Job Description

Dublin based company requires an experienced Data Warehouse Specialist to join their team. Excellent opportunity with a market leading organisation that can offer long term career opportunities.

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.
  • Develop and modify complex software systems using disciplined software development processes.

Experience Required

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

Educational Requirements

  • Third Level Qualification in Computer Science / IT or relevant work experience.
  • MS certifications desirable but not essential

Working Hours & Benefits

Standard working week. 9-5

How to Apply

If you are interested in this role, then please Apply along with your updated CV and I will be in touch with you to discuss your application in more detail, otherwise feel free to connect with me by whichever medium you are most comfortable with be that Linkedin, Email or Telephone. Remember we have limited our site to a maximum of 200 Jobs so if this Role is not a 100% match to your requirements please be sure to connect with us as we will most likely have another role which you may find more suitable.

Apply for Job

Not what you're looking for?

If this isn't the job for you then why not reach out to one of our consultants today and send us your CV so we can find the one that is?

Reach out to a Consultant