Database Analyst

  • Location

    West End, London

  • Sector:

    Data

  • Job type:

    Permanent

  • Salary:

    £30000 - £35000 per annum

  • Contact:

    Paul Culmer

  • Contact email:

    paul.culmer@xcede.co.uk

  • Job ref:

    HQ091214_1572607529

  • Duration:

    Permanent

  • Startdate:

    ASAP

SQL, ETL, Reporting, Customer Insights, SSIS, Marketing, Database, Python, R, Database marketing, Dashboards, power BI

Our client a fast-growing loyalty business based in the heart of London is looking to recruit a SQL database analyst to join the Analytics team.

You will need to have:

Required
Strong ability to read and write Structured Query Language (SQL)
Solid understanding of logical relational database concepts (e.g. including data types, joins, sub queries, primary and foreign keys, normalisation.
Ability to translate requirements sourced from non-technical clients into effective technical specifications
Proven ability to produce process documentation that is logically structured and accurate
Experience of working with common data file formats (e.g. csv, fixed width), importing and exporting data, compression, encryption software (e.g. WinZip) and FTP clients.

Bonus points for any of the following:
Hands on experience of working with a significant (500,000+) customer database
Experience of Microsoft SQL Server (2008/2012) Transact SQL
Experience of Microsoft SQL Server (2008/2012) Reporting Services and / or Integration Services
Experience of using Tableau to create dashboards and reports
Advanced knowledge of MS Excel including complex formulae, advanced charting, lookups, PowerPivot and VBA
Business process concepts including, for example, data flows, batch control, validation rules, exception reporting, audit trail and reconciliation
Domain expertise in any of the following: retail, personal banking, direct marketing, digital marketing, CRM, loyalty programmes.

Please send me your CV to paul.culmer@xcede.co.uk