Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe

---

Job description

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe

Permanent

Remote/Office

London

£65,000 - £68,000 + Benefits and Bonus

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe-London Market Insurance-Data Warehouse Concepts-Kimball

My prestigious speciality insurer is looking to recruit a Technical Analyst to work within the Global Delivery team; The team covers all areas of the business and the knowledge you will gain for this position will be fantastic. My client is a true believer in 'promoting from within' and helping staff progress and learn new skills. You will be working with a very friendly team, people who you can approach for advice and who all work with a collaborative approach.

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe-London Market Insurance-Data Warehouse Concepts-Kimball

Key Responsibilities:

Assist the MI Manager and data development team with activities pertaining to strategic programmes of work around the data warehouse and related reporting systems

Produce technical business requirements detailing the appropriate technical specification to support new requirements including source to target mappings

Assist in the analysis of the impact of change on the system, highlighting the options, impact and potential links between other changes and systems so that informed decisions can be made

Maintain close, good working relationships with customers of the department and IT colleagues

Adhere at all times to company procedures and standards

Work with business stakeholders and system end-users to assist in gathering and understanding requirements

Owning assigned tasks and seeing these through to successful completion

Adherence to all relevant regulatory requirements forms part of your role, and the demonstration of behaviours as set out in the Conduct Risk Policy, as they relate to your role, is core to my client's commitment to placing customers at the centre of their business and behaving with integrity. My client expects you to understand your responsibilities relating to all regulatory and internal requirements, and to proactively demonstrate compliance with these requirements and behaviours at all times. These requirements include Solvency II, fair treatment of customers, Financial Crime, Data Protection, Conflicts of Interest, and Whistleblowing.

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe-London Market Insurance-Data Warehouse Concepts-Kimball

Skills and Experience:

Demonstrated ability to communicate both in business and technical terms

Knowledge, experience and understanding of ETL processes including the ability to analyse existing ETL and produce documentation to support the creation of new ETL flows

Familiarity with SSIS as an ETL tool

Good knowledge of MS Excel to help with requirements gathering and demonstrating concepts

Familiarity with SQL, SQL tools and general database principles

Knowledge of London market insurance

Experience of typical Finance department processes and requirements mainly from a reporting perspective

Good understanding of reporting database systems their design, particularly Kimball modelling methodologies

Good understanding of data warehouse systems, their function and the business requirements they are intended to service

General knowledge of IT concepts, strategies and methodologies, including architectural and security concepts, systems development life cycle, information management and portfolio management (production systems, release planning, change management).

Experience of working in SAFe Agile development environments.

Good knowledge of business functions, business operations, objectives and strategies.

In-depth knowledge IT standards and guidelines.

Experience with any of the following systems is advantageous:

Genius

IRIS

Salesforce

Rulebook

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe

Permanent

Remote/Office

London

£65,000 - £68,000 + Benefits and Bonus

Technical Analyst-Insurance-ETL-SSIS-SQL-Excel-SAFe-London Market Insurance-Data Warehouse Concepts-Kimball