Database Administrator

Apply now

Our client is looking for an intern to join their team to work on a number of data-led projects across the business. This role will be to conduct a series of tasks to improve the integrity of marketing data and eliminate the potential for duplication that currently exists across the database. You will be set a list of prioritised tasks that you will need to complete within specific deadlines.

The ideal candidate will have a strong working knowledge of Excel, having the ability to utilise formulas and macros to automate repetitive tasks. The experience of this role will act as a perfect starter for somebody that is looking to build a career in either digital marketing, data analytics or data science.

PROPOSED PROJECT AREAS:

• Data Export: Exporting each marketing segment that currently exists within our email marketing software and structuring it accordingly for re-upload.


• Data De-duplication: Working through exported data to eliminate duplication, creating final data sets to re-upload.


• Data Formatting: Once de-duped, the data will then need to be reformatted to remove any errors, typos and common areas that exists within the database.


• Data Upload: Once formatted, this data will then need to be carefully re-uploaded back to the email marketing system and formatted correctly for use within future campaigns.


• Data Segmentation: Using automated rules based on parameters such as keywords to create additional custom fields that can be used to increase the targeted nature of messages.


• Data Analysis: On request, to look at existing data sets to spot trends and report on observations gleaned from marketing activity.

In addition to this, there will be a number of other projects that will be passed to you overtime for completion. You will work in a prioritized way with deadlines set for each task that you will have to work to.

REQUIRED EXPERIENCE:

Our client is looking for an intern who has a solid understanding of working with data. To do this role successfully, experience in Excel is mandatory, VBA experience is optional.

Our client offers a wide selection of social media and digital marketing training in the UK and US. Their client base covers most blue-chip brands and government organisations, with 10,000+ delegates trained to-date, they are a global organisation with offices in both London and San Francisco having grown rapidly over the last 3 years. Ambitious plans are afoot for the future and they are currently looking for someone to join their team in a customer support/events admissions role.