Data Warehouse Support Developer - London/Remote - £45,000

Data Warehouse Support Developer

Full-time

London/Remote

£35,000 - £45,000

Are you a Warehouse Support Developer with specialist technical knowledge and experience supporting the Business Intelligence reporting solutions?

iO Associates are looking for a Warehouse Developer to play a key role in developing and maintaining the organisations data warehouse and reporting service used by Business Intelligence and the wider organisation. You will be responsible for maintenance, development and running of new and existing ETL processes as well as performing mandatory tasks.

Requirements:

• T-SQL for the production of datasets and database manipulation
• SQL Server Data Tools for the development of SSIS, SSRS or SSAS packages.
• Experience of communicating with stakeholders with a non-technical background.
• Significant experience of T-SQL programming.
• Experience and understanding of designing ETL processes for large organisations.
• Can implement and execute Database recovery plans
• Experience of creating and managing scheduled transactions on SQL Server.
• Experience of loading data in and out of SQL Server databases from a variety of sources including Linked Server Connections, OLEDB, ODBC, XML and Flatfiles.
• Experience in loading bulk and net change data.
• Experience of creating and maintaining BI Data Marts based on the principles of dimensional modelling.
• Experience of using and developing on other third party Analysis tools. Examples include Qlikview, Qliksense, and Power BI.
• Experience of documenting Database processes as well as Standard Operation Procedures.
• Experience of creating Data Quality for monitoring ETL loads

This opportunity comes will a competitive salary and excellent benefits package, if you're interested apply now or contact Jennifer on 07958441684