Data Warehouse Analyst

Location Crewe
Rate £23.25 per hour via umbrella
Duration 3 months
Posted 06/04/2020
Contract Type Contract
Hours Full Time
Start date ASAP
Do you need a DBS? No
Ref #REQ6894

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:

Database Management

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.

Data Management

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 ( 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.

Share this job: