Database Developer

Data Warehousing; Reference Data; Data Management; Datamodelling; RDMS; MS SQL Server; SSIS; SSAS; SSRS; Python, Perl, Powershell, Shell scripiting; Data Integration; Data Quality;

Mansion House is an independent international business and technology consultancy focussed exclusively on the Finance Service Sector. We provide innovative solutions to the corporate and transaction banking, capital markets, wealth and investment management communities through our team of highly skilled Subject Matter Experts. We have offices in London, NY, Frankfurt and Singapore. Overall we specialise in Global Change Management programmes.

Our client, a tier 1 Investment Bank is looking for a Database/Data Warehouse developer to join the IT Security team in New York. The team oversees not only IT Infrastructure, but the application space and the development of Security Solutions.

The Database/Data warehouse developer is responsible for various IT security activities which manage, monitor and/or report on the adherence to the IT security program and the related IT security policies and standards. The role will liaise with Architecture and Engineering, Production support, IT Risk analysis, design, develop, test, debug, deploy, maintain and update
- Design, implement and maintain database schema across multiple versions
- Develop data warehouse process models, including sourcing, loading, transformation and      extraction.
- Develop and implement data extraction procedures from other applications (commercial MS SQL Server; T-SQL; .NET; VB.NET; C#; ETL; MS business      Intelligence (SSIS, SSAS, SSRS,) and crystal Report
- Knowledge of Scripting languages (eg Python, Perl, Powershell, Shell scripiting)
- Excellent communications skills

EDUCATION

- MCSA/MCSE (SQL Server)