-
Current Vacancies
SQL Database Administrator (SQL DBA) - Bournemouth
Marketing Database Development Manager - Bournemou
Pricing Manager - Bournemouth
Outbound Sales Advisor Belfast
Head of Marketing Campaigns

Testimonials
Work hard, persevere and the rewards will come
Jonathan Hughes Picture of Jonathan Hughes

Title:

Systems Analyst

Reports To:

Application Development Manager

Department:

IT

Salary:

Up to £35,000 per annum

Benefits:

 
Competitive benefits package

Job Purpose:

To identify and interpret the needs of the Business for corporate-based systems, working with the users to establish a clear and unambiguous specification; translate, document, analyse and design these as required and to deliver a set of functional requirements to the developers for building a system solution.

Dimensions:

 

For all development system solutions within RIAS:

Business translation

Analysis & design of optimal system solution

System integration skills

System test/delivery

Collaboration with other I.T. specialists

Translation of business rules into complex functional logic

Areas of complexity:

Complex business rules

Complex data relationships

Inter-dependant components

System integration

Accountabilities:

1.      To understand Business needs, research, and lead in documenting, analysing and designing solutions in response to business and technical requirements received.

2.      Accountable, internally within the development team, for the analysis standards and procedures employed within the team and the overall quality of the functional specifications produced

3.      Identify and mitigate potential risks to the Business when determining and implementing the final technical solution.

4.      To identify and design the most appropriate technical solution to requirements presented by the Business giving consideration to the central problem and any associated impacts on other departments and the Business.

5.      Lead in the technical development, enhancement and upgrade to existing software solutions.

6.      Lead in the continual review and improvement of the chosen tools and techniques.

7.      Collaborate with other members of the development team to ensure that the strategic aims and drivers of the business are clearly and effectively met with when producing system solutions

8.      Design system solutions that not only satisfy the business requirements but also meet the strategic aims of the department with optimal future-proofing

9.      Design and build complex report solutions that can be published on the Oracle portal  

10. Lead in the creation of test plans and scripts for unit and system testing

11. Audit the quality of unit and system test scripts produced by other Application Development team members

12. Be ‘centre of excellence’ capability within the team for the tools and techniques used within the role and be perceived as an expert in these.

13. Ensure knowledge transfer during development and implementation lifecycle

14. Liaise with business to ensure requirements complete and accurate, presentation layer fit for purpose and correct solution delivered and effectively utilised

15. Write and maintain specifications and other documentation to RIAS standards

16. Project manage small developments carried out within the team

Essential Competencies:

1. Formal experience as a Systems Analyst

2. Hands-on exposure to a formal development lifecycle methodology e.g. SSADM, LSDM

3. Fully competent in writing PL/SQL (Oracle 9i or later)

4. Specific hands-on experience is required in one or more of the following Oracle tools – Warehouse Builder, Oracle Portal, Oracle Application Server, Oracle Discoverer, Oracle Reports.

5. Experience in producing and documenting effective design solutions, at least one should be business critical.

6. Experience in writing business requirements and functional specifications.

7. Experience in generating logical and physical data models using a recognised modelling tool e.g. Oracle Designer 2000.

8. Excellent communication skills with assertive and questioning approach

9. Strong problem solving skills based upon technical knowledge and experience of similar situations.

Desirable Competencies:

1. Experience in creating test plans and scripts

2. Experience of the General Insurance sector

3. Hands-on exposure to Oracle Reports – 9i or later

4. Hands-on exposure to Oracle DB 9i or 10g

5. Some exposure to Oracle Developer toolkit

6. Experience in project management tools such as MS-Project.

 

Performance Measures:

 

1. Deliverables meeting agreed dates and quality

2. Deliverables meeting business and technical requirements

3. Solution ‘fit for purpose’ in relation to the corporate strategic and tactical objectives.

4. Conforms to RIAS adopted project methodology and ’ways of working’

5. Compliance with FSA regulations

6. Proactive knowledge acquisition and absorption

7. Adheres to company standards

8. Optimum use of tools and infrastructure

9. Incremental knowledge of RIAS’s strategic application/data architecture

10. Produce effective design solutions

11. Produce written reports/documentation as relevant

12. Clear and effective communication skills

13. Perform impact analysis of any changes and identify potential risks to the Business of any changes.

14. Manage the development and implementation lifecycle using RIAS methodology and project plans