Development Data Warehouse Expert

DATA WAREHOUSE SQL T-SQL MS SQL SERVER

eCRM Euro are looking for a Data Warehousing expert. The Data Warehousing expert's main goal is to implement interfaces and coordinate development activities whilst maintaining existing data marts in the data warehouse. The role will also involve the assisting with the design of technical and functional requirements for data integration projects.

TASKS AND DELIVERABLES

Reporting directly to the head of the .NET development group

Participate in regular meetings of the development team

You will be required to work as defined in the Scrum team sprint as a full team member of the Scrum team.

Dependant upon profile you will be required to - Maintain the code base and fix bugs

Implement interfaces to other systems

Implement and co-ordinate development activities with external partners.

Implement new and maintain existing data marts in the data warehouse system.

Implement new and maintain existing standard and specific reports.

TECHNICAL KNOWLEDGES AND SKILLS:

Excellent knowledge of data warehouse modelling and implementation

Excellent knowledge of T-SQL

Excellent knowledge and experience of SQL Server Integration Services

Experience with MS SQL Server 2008/2012

Experience with MS Analysis Services

Experience with automatic map generation (eg, using GIS tools) would be advantageous

Experience with MS SQL Server Reporting Services and RDL would be advantageous

Experience with surveillance and laboratory data is advantageous