Connecting...

BI Developer

BI Developer

  • Location

    City of London, London

  • Sector:

    Insurance

  • Job type:

    Contract

  • Salary:

    Up to £450 per day

  • Contact:

    Tanya Howard

  • Contact email:

    thoward@venquis.com

  • Salary high:

    450

  • Salary low:

    450

  • Job ref:

    BBBH8215_1535119020

  • Published:

    etwa 1 Monat

  • Duration:

    6 months

  • Expiry date:

    2018-09-23

  • Startdate:

    ASAP

  • Consultant:

    #

An established insurance client based in the city is looking for a BI Developer to help with Data migration, design and modelling. Ideal person will come from an Insurance background and understand Lloyd's Market.

Job Purpose:

The role of Data migration SQL developer is to work within the Data migration team and with the wider business to support, enhance and develop ETL Routines in Source system migration. The developer will design, develop the data extracts using ETL processes as required by project or work requests.

General Activities & Key Tasks:

  • SQL Skills
  • ETL development work within the IBM DataStage toolset and within SQL Server T-SQL
  • Data modelling and data solution design
  • Provide assistance with the resolution of user problems and queries
  • Data analysis, reconciliation and manipulation as required
  • London Market Insurance knowledge
  • Liaise with users to specify, design and implement changes to the data Migration processes as required by the team
  • Provide assistance with the resolution of user problems and queries
  • Liaise with the IT department on changes to upstream and downstream systems to ensure that any impacts on the BI systems are identified and dealt with accordingly
  • Database, ETL, Report and OLAP development work
  • Monitor and maintain the integrity, performance and capacity of the data warehouse
  • Reconciling the migrated data back to the source systems
  • Run month-end procedures and reports as required
  • Maintain change management controls for all system changes
  • Data analysis, reconciliation and manipulation as required
  • Work as part of the Business Intelligence Team to deliver a coordinated and evolving BI solution for TMHCC.

  • Essential Skills & Qualifications

    • Understand the principles of ETL Data Migration, design and development
    • London Market Insurance knowledge
    • Independent thinker with strong analytical and problem-solving skills
    • Sound Knowledge and hands on experience of MS SQL Server - SQL, SSIS,
    • Knowledge of SSAS, SSRS
    • Knowledge of IBM InfoSphere DataStage
    • Knowledge of data migration principles
    • Good understanding of Database schema design
    • Exposure to Transact SQL coding
    • Understand the principals of data modelling
    • Knowledge of problem analysis, structured analysis and design, and programming techniques
    • Strong organisational, interpersonal and time management skills
    • Good verbal and written communications skills
    • Confident, friendly, self-motivated personality
    • Communication with business users to understand the data requirement

    Desirable Skills & Qualifications

    • Exposure to large scale data migration
    • Exposure to the DB Admin tasks - Backup / Restore etc. etc.
    • Microsoft Visual Studio online

Please get in touch with Tanya Howard ASAP via email (thoward@venquis.com) or jobserve response. When sending across your CV please highlight relevant experience (particularly Business Objects and dashboarding experience). If experience is suitable we will be in contact within the next 48 hours.