Job Title:	Data Analyst
Reference:	SW08/32
Salary:	25-30000 basic plus benefits and bonus
Location(s):	Kent, Bedfordshire, Berkshire, Buckinghamshire, East Sussex, Essex, Hampshire, Hertfordshire, Isle of Wight, Kent, Oxfordshire, Surrey, West Sussex, South East, Sussex
Industry(s):	Accounting, Banking, Consumer Banking, Consumer Finance, Data Specialists, Financial Services, Information Technology, Software
Advertiser:	FSG Ltd Executive Search & Selection
Employment Type:	Permanent
Posted:	03-06-2008

Description:

My client is a financial services provider that is currently looking for a Data Analyst. The data analyst will be required to develop, implement and support any data extract or data load for evaluation of portfolio to support the company to perform portfolio acquisitions. This includes documentation of data dictionaries performing data validations, creating integrity reports of the data received, ensuring that balances can be recalculated from the data and validated against high level KPIs. This role will also perform the creation of a series of reports to highlight trends in the data and also to provide some high level characteristics about the data.

The Data Analyst position will support the inorganic acquisition team to ensure that they have the data required to perform further analysis and also provide initial insight regarding the data to speed the delivery of the evaluation of the portfolio.

The successful candidate will have the ability to develop generic re-usable code/modules to apply to different data tapes with minimal changes required to load and report on new data as it arrives. This should be done using concepts of metadata and all applications developed should be fully documented to enable other team members to perform this operation should there be a need. It is also expected that once the initial load procedures have been written, the turn around time for data load and the production of key reports should be within a couple of days.

Key Accountabilities

To ensure that all documentation is up to date and that the data has been validated prior to providing the data to the rest of the team to perform further analysis and valuation.

To ensure that the data is loaded and all required steps (ie validation, high level distributions and initial insight on the data tape) to be performed accurately within the timelines agreed with the project manager.

Rapid uploading of data for analysis – From time to time, the other team members may need to perform specific analysis on the data tape and therefore this role will assist the team by uploading the data into either the SAS environment or SQL Server environment to enable the analysis. This task will include exporting data from the SAS or SQL Server environment into summarized Excel pivot tables so that business users can use the data to perform various analysis.

To liaise with external companies in responding to data request. This could involve providing access to external users to FTP servers to upload and download data.

To assist with organic growth when there is no inorganic activity. This includes loading data and summarizing data to perform analysis on profitability.

Key Experience/Skills

The ideal candidate will be familiar with working with uploading raw data into the SAS or SQL environment. The candidate will also be required to be knowledgeable in both SAS and SQL Server for data loading and for creating rapid OLAP cubes for analysis and providing the ability to create drill-down graphs.

The candidate must have hands on experience in writing SQL on SQL Server and SAS programs whilst having the ability to project manage the work to ensure that it meets the time, cost and quality whilst maintaining excellent documentation throughout the process.

The candidate must also have experience in gauging the timescales for any tasks that are carried out and to take full ownership of the delivery of the work. The candidate must be able to communicate the progress and produce status reports to the Portfolio Valuation Manager to ensure that tasks are being progressed in a timely manner and that all issues are raised, managed and resolved.

The candidate will be at least graduate level and will also have relevant and excellent communication skills to be able to understand the business requirements and to be able to convert this into a technical solution to obtain the answers required.

A good knowledge of SAS Base, SQL on MS SQL Server (including DTS and OLAP cubes/Analysis Services) and writing queries to interrogate data is essential. Knowledge of MS Excel is essential especially to be able to extract data into user friendly pivot tables so that users can interrogate data.

Good interpersonal and influencing and skills. Must be able to present articulate and well thought-through business cases to senior management.

High energy levels, a positive outlook, and a willingness to enthuse colleagues and business partners about our strategies is essential. Willingness to “get their hands dirty” is essential in a small, dynamic company culture.

Other jobs you may be interested in...

Credit Controller/Data Analyst - Hemel Hempstead
Our client are a large multi national high tech company and are currently recruiting for a credit co...
Hertfordshire	£25000-26000	View Job