Data Warehouse Analyst
|Rate||£23.25 per hour via umbrella|
|Do you need a DBS?||No|
Full Job Details
Our client is looking for a Data Warehouse
Analyst for a 3 month initial contract based in Cheshire.
The ideal candidate will be able to help with the day to day maintenance of the warehouse, Data Transfer and Data reporting experience is a must have. This position will sit underneath the Data Warehouse Manager.
The ideal candidate will have experience with:
Support and maintain On Premise SQL databases and Azure SQL databases.
Provide database support services.
Undertaken SQL upgrades to ensure services do not run on unsupported database technology.
Monitor and optimise SQL performance including database tuning.
Proactively manage log files including responding to events as required as well as managing the storage and sizing of log files.
Respond to and manage any incidents and events which occur on the databases.
Support and monitor data extraction methods to ensure data is extracted from core systems effectively with limited impact of live services.
Adhere to a ‘deployment and testing’ strategy to migrate data on premise to Microsoft Azure cloud platform.
Support and monitor data transfer processes including data staging.
Support and monitor the data load routines including load validation.
Data Warehouse Planning
Undertake system capacity analysis to ensure systems are not subject to capacity related incidents.
Undertaken proactive storage management utilising different storage types to manage costs.
Undertake upgrades to the data warehouse environment ensuring the warehouse remains modern and supported including test and release processes.
Research new data warehouse technologies and capabilities to support the ongoing development and improvement of the service.
To stay safe in your job search we recommend that you visit SAFERjobs (www.safer-jobs.com) a non-profit, joint industry and law enforcement organisation working to combat job scams. Visit the SAFERjobs website for information on common scams and to get free, expert advice for a safer job search.