Technical Data Specialist (SQL Developer)

Job Purpose

This is a key role in the Investment Control Team that delivers Asset Reporting under Solvency II Regulations. The role holder will provide support and assistance in developing a new asset data system.  The system will manage, control and report all the investment data required to produce the Asset Quantitative Reporting Templates (QRTs) for the CBI.  In addition, the role holder will support ad-hoc projects required by the business.

Distinguishing Features

The role holder will be responsible for the following:

• Developing and maintaining the data architecture of the Back-End of the software (SQL-Server)
• Producing User-documentation, training and supporting end-users in new and existing operational processes.
• Delivering Technical Specifications in line with design standards that accurately detail the technical solutions to be implemented and supported on the systems.
• Contributing toward the operational efficiency of the Investment Control team to achieve solutions and to improving all processes / tasks.
• Analysis and manipulation of complex, high-volume data across multiple sources.
• Providing ad-hoc support to the Investment Operation Teams and wider business.
• Providing ongoing Technical support to Investment Control Team.

Required / Desirable Qualifications and Experience

• A third level qualification in computer science/mathematics, ideally 2.1 or higher.
• Strong numerical and logical mind.
• Minimum of 4-5 years SQL experience.
• 4-5 Years as SQL Back-End developer (SP, Triggers, etc).
• Experience of analysis, manipulation and cleansing of large volumes of data is a distinctive advantage.
• Some experience working with VBA (excel and Access) is an advantage.
• Some experience with investment data is an advantage.