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 & Qualifications
Must have at least two years’ experience of using IBM InfoSphere (ideally to version 11.5)
Ideally 5 years 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 experience
Working knowledge of the IBM Information Server suite including Changed Data Capture, QualityStage and Information Governance Catalog
Full project lifecycle experience from initial design and data modelling through development, testing and into production support.
Knowledge of data warehouse and ETL development techniques
Excellent analysis skills with the ability to convert business requirements into practical solutions.
Confident, friendly, self-motivated personality
Good written and verbal communication skills.
Desirable Skills & Qualifications
Hands-on experience implementing large scale data warehouse and BI solutions preferred
Power BI development