Data Analyst / Reporting Analyst (SQL)

Data Analyst | Reporting Analyst (SQL, Excel, VBA)

CONTRACT

Rate: £420 – £480 per day
Location: London, city
Duration: Initial 3 months
Start: ASAP

Keywords: Data Analyst, Reporting Analyst, Information Analyst, BI Analyst, MI Analyst, Excel, Advanced Excel, SQL, VBA, Mathematics, Investment Banking, Financial Services, Tableau, Qlikview, Software, London, Contract.

Urgent requirement for an experienced Data Analyst | Reporting Analyst who will be responsible for the data management, mapping and reporting of data using databases, excel and report writing tools (Qlikview) Also responsible for ensuring the quality of the processed data and final output as well as that requests and deadlines are either met or exceeded.

This will be working with the end client team & stake holders, as well as with the on-site implementation team on a complex SaaS / Cloud based software platform to the Investment Banking arena.

Duties and Responsibilities include the following:

– SQL Skills with a track record of transforming complex feeds into multi-table relational databases.
– Prepare, load, filter, and manage client data into processing software and hosted document and data platforms.
– Perform thorough quality checks on client data and work product at multiple stages of processing to ensure 100% compliance of data and deliverable to client specification. Attention to detail is paramount.
– Analyse project issues efficiently, effectively communicate those issues to Managers, recommend viable solutions, and provide detailed hand off instructions.
– Provide and maintain detail reports of data processed and worked through all stages of data progression from collection to production
– Independently work on job requests at the direction of the Manager ensuring that jobs progress and are completed within specified deadlines. Maintain a sense of urgency on all production deliverables and internal requests.

Requirements:

– VBA / script writing skills for complex Excel; structured coding, with good comments.
– SQL: SQL querying, DDL, DML, Postgres SQL preferred
– MS Excel: In depth technical skills including Analyzing large data sets, creating Charts, Array formulas, custom views etc
– Detail and quality oriented
– Understand the importance of confidentiality
– Excellent problem solving ability, verbal and written communication skills, work under strict deadlines in a legal environment and the ability to interact with all levels of staff and attorneys necessary
– Strong maths and/or technology skills
– Ability to handle multiple tasks under challenging conditions and work as a team player

Any exposure to Qlikview or Tableau MI Scripting would be an advantage, but not required.

Any experience of XML & understanding of XML Schemas would be an advantage, but not required.

Please pop me over your CV for review!