Risk Reporting Developer at New York

Our client, a global international bank is looking for Risk Reporting Developer. The team is responsible for implementing and supporting systems for calculating and reporting consolidated Market and Credit Risk across all locations. Their current system is being is being replaced with a new third party solution called MarkIT Analytics and a new BI reporting

A DAY IN THE LIFE:

The successful candidates primary role will be to support the rollout of the new multi-million dollar Risk infrastructure across multiple regions (NY, LON & Asia). The infrastructure uses a combination of technologies including MS SQL Server, SSIS/SSAS & SSRS, .NET, Grid and Cloud Computing.

The candidate will work closely with various development teams and Risk Managers to further enhance the data warehouse and OLAP elements of the platform. Strong technical knowledge of the core Microsoft BI stack (SQL, SSAS and SSIS) is essential as are strong analytical and communication skills required to translate business functional requirements into technical solutions.

Previous experience working within a Risk Reporting or Product Control area is desirable although a strong track record of comparable experience on large scale MS SQL Server Reporting implementations within finance is also acceptable.

• Develop the reporting repository in SQL Server 2012
• Load and validate existing risk data and new risk data from new risk platform
• Configure Microsoft Analysis Services on top of the reporting database.
• Design and develop canned reports using Microsoft Reporting Services.
• Design and develop the Analysis Services Models.
• Complying with the standard release cycle and deployment controls
• Perform all application unit and system testing
• Support users as with ad hoc queries relating to the use of RAPTOR in the resolving Market & Credit risk issues.

WHAT GETS YOU THE JOB:

• SQL Server 2012 or 2008 R2
• Solid experience of developing large scale enterprise SQL Server reporting databases.
• Solid experience of developing SSIS packages
• Solid experience of developing Data Warehouse transformation routines
• Solid experience of configuring / designing Analysis Services databases
• End to end development cycle knowledge
• Experience of working in an investment banking technology environment
• Planning and prioritization skills
• Proven track record of delivering to Risk/Middle Office/Front Office
• Excellent interpersonal skills to ensure clarity of communication to users and Technology colleagues with a "can do" attitude with flexibility to adapt.

Preference will be given if you have:

• Experience with credit and market risk reporting; PV, Sensitivity, Stress, VAR, P&L Rec, PFE, Credit utilization.
• C# programming experience.
• Solid understanding of software design principles and best practices.
• Experience of Business Objects or Microsoft Reporting Services.
• Knowledge of other BI tools like Tabular, PowerPivot etc.

Country: USA, State: New York, City: New York, Company: Aegis Software Inc..