Data Analyst
Bristol, United Kingdom
Collecting, collating and carrying out complex data analysis in support of management & customer requests. Also involved in reporting statistical findings to work colleagues and senior managers. • Manipulating, cleansing & processing data using Excel, Access and SQL. • TES Microlise champion / super user.• Manhattan WMS super user .• Responsible for loading, extracting and validation of client data.• Liaising with end-users and 3rd party suppliers. • Analysing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts. • Developing data analytical databases from complex financial source data. • Performing daily system checks. • Data entry, data auditing, creating data reports & monitoring all data for accuracy. • Designing, developing and implementing new functionality. • Monitoring the automated loading processes. • Advising on the suitability of methodologies and suggesting improvements. • Carrying out specified data processing and statistical techniques. • Supplying qualitative and quantitative data to colleagues & clients. • Using in house software to extract, transform & load source data from transaction / tracking systems. Key Skills: • Attention to detail & ability to work in a pressurised time sensitive environment. • Experience running complex and high volume ETL processes. • Exposure to MIS/data warehouse applications. • Checking of supplied data for sense, consistency and accuracy. • Sound understanding of relational, object and dimensional databases. • Extensive experience with Microsoft Access / Excel 2003/2007.• Extracting raw data from Microlise systems , using ETL processes manipulate the data for use with other software.