BI Developer

  • Location

    City of London, London

  • Sector:

    General Insurance

  • Job type:

    Permanent

  • Salary:

    £50000 - £60000 per annum

  • Contact:

    Louise Jolly

  • Contact email:

    ljolly@mbfitzgerald.co.uk

  • Job ref:

    BBBH2887_1619012067

  • Published:

    2 months ago

  • Expiry date:

    2021-05-21

  • Startdate:

    ASAP

  • Consultant:

    ConsultantDrop

The London Market Syndicate of a leading global insurance firm are looking for a Business Intelligence Developer

As BI Developer you will provide the business community with data governance, reporting devlopment, warehousing, ETL development, MI reporting, SQL and Power BI.

Responsibilities include:

  • Develop and maintain SSRS reports, SSAS cubes and Power BI dashboards
  • Develop and maintain SSIS ETL packages
  • Ad-hoc SQL for analysis and investigation
  • Stored Procedures for reporting and ETL.
  • Full development lifecycle - system test, peer review, assist with UAT and roll out to the end user. Comply with and contribute to the standardisation of reporting in terms of format, definitions and specifications.
  • Awareness of best coding practices for performance tuning, scalability and ease of maintenance.
  • Support the development of the warehouse to include new data sources and functionality using SQL, SSIS and SSAS.
  • Gather requirements for reports or data extracts and agree business specifications with the business community and the dedicated project team.
  • Liaise with the MI Team Leader and other team colleagues to peer review the proposed solution to ensure that it fits suitably within the current architectural framework.
  • Prioritise and communicate development to ensure that the business has a transparent view of priorities, progress and timescales.
  • Develop technical specifications for reports, including aligning specifications to the data dictionary.
  • Analyse and understand the impacts on the new replacement Syndicate Data Warehouse currently in development.

Experience within the Insurance / Lloyd's market is essential for this role!