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