Description
Job Title: ETL/Data Warehouse DeveloperType: Contract
Duration: 6 months (extension possible)
Location: London
Sector: Insurance
Main Function:
Technical Support
- Assist with day-to-day support for our clients technical infrastructure and related technologies, including :-
o External Data Feeds and associated SSIS, ESB and SFTP infrastructure
o Control M Daily Load jobs and associated database updates
o Warehouse database management, performance and security
o Our clients Application Server configuration and upgrade
Development
- Build and test MS SQL based solutions - Procedures, views, functions
- Maintain source code documentation and version control
- Build, test and implement robust and efficient technical solutions using the MS SQL Server application stack and internally authorised solutions - e.g. Control M, ESB, SFTP
- Ensure new developments follow agreed documentation, programming standards, testing and release control processes
- Liaise with business analysts and users to ensure proposed changes provide acceptable solutions for the original requirements.
- Generate ideas/proposals/solutions for further business improvement and opportunity
- Assist with deployment process including
o Creating and maintaining deployment packages
o Providing release and technical test documentation
o Monitoring the change control process from initiation to delivery
BI Technical Environment Management and Processes
With the ETL/Data warehouse developer, developing and ensuring the adherence to the agreed standards of the following areas within the CARAT project
o Documentation
o Programming standards
o Testing
o Technical architecture
o Release Control
o Source Control
Skills:
- Regulatory Knowledge as applicable to role (compulsory)
- Coaching & Assessment (compulsory for Line Managers and other Supervisors)
- To act with integrity at all times and embrace the philosophy of treating our customers fairly (compulsory)
- 5 years+ knowledge of SQL Server Management Studio
- 2 years+ knowledge of SQL Server Integrated Services
- 1 year+ knowledge of SQL Server Analysis Services
- Understanding of Data Warehouse theory, architecture and application within a financial environment
- Strong communication skills
If you are interested in this role please feel free to send your CV across Sthree UK is acting as an Employment Business in relation to this vacancy.