BI Developer

Recruiter
HFG
Location
London (Greater)
Salary
£400 - £465 per day
Posted
27 Nov 2017
Closes
08 Dec 2017
Sector
Accountancy
Contract Type
Permanent
Hours
Full Time
My client is urgently looking for a BI Developer to work within the Business Intelligence team

This role is focused on supporting and developing DataStage code in response to BAU change requests, defects raised by the business and project related enhancements as required.

The role will also involve development and support work on reports and cubes.

General Activities & Key Tasks:
  • ETL development work within the IBM DataStage toolset and within SQL Server T-SQL
  • Data modelling and data warehouse solution design
  • Liaise with the BI Analyst to specify, design and implement changes to the data warehouse as required by the business
  • Full stack SQL Server development including SSIS, SSRS, SSASAnalysis Services development work using MDX and TABULAR models
  • Provide assistance with the resolution of user problems and queries
  • Data analysis, reconciliation and manipulation as required

Essential skills
  • Must have at least two years’ experience of using IBM InfoSphere (ideally to version 11.5)
  • Extensive knowledge of SQL Server (or other DBMS) with experience of the following:
  • Database schema design
  • Advanced T-SQL coding.
  • Development using SSIS, SSRS, SSAS
London Market Insurance knowledge and experienceWorking knowledge of the IBM Information Server suite including Changed Data Capture, Quality Stage and Information Governance CatalogFull project life cycle experience from initial design and data modelling through development, testing and into production support.Knowledge of data warehouse and ETL development techniquesExcellent analysis skills with the ability to convert business requirements into practical solutions.Confident, friendly, self-motivated personalityGood written and verbal communication skills. Desirable Skills

  • Hands-on experience implementing large scale data warehouse and BI solutions preferred
  • Power BI development

You must have LMKT INSURANCE experience and be able to work in the UK without sponsorship. If you do not have either, you application will be unsuccessful