SQL Server DBA / DW Consultant

<< Back to Search Results

Job Description

The Role

  • Design and implementation of a Data Warehousing architecture
  • Database architecture and data modelling to include a knowledge of Data Warehouse design methodologies e.g. star, snowflake
  • ETL and data integration and data migration design and implementation and DWH performance optimization
  • Design and development of data profiling, sourcing, and cleansing routines utilising typical data quality functions involving standardisation, transformation, rationalisation, linking and matching.
  • Design of ETL Processes including, Data Quality and Staging environments
  • Deliver end to end BI systems
  • Data Maps – complete end to end data transformation diagrams
  • Database design and testing
  • Ensure Implementation of suitable security, authentication and access control models
  • Develop reports using Server Reporting Services (SSRS)
  • Develop SQL Server Integration Services (SSIS) packages
  • Develop stored procedures
  • Create technical and architectural documentation

**SQL server DBA certification is a essential requirment for this role**

For more info please call Michael on +353 1 6146058 or michael.fitzgerald@cpl.ie

Apply via LinkedIn

Michael Fitzgerald

Principal Consultant 01 614 6058 michael.fitzgerald@cpl.ie
  • Salary: 450.00 - 550.00
  • Location:Dublin City Centre
  • Type:Contract
  • Category:Technology & IT
  • Ref.no:JO-1812-421018