OUR PLACEMENTS

Placement summary

Rapidly growing search engine marketing company QueryClick are seeking a smart, techincally-minded graduate for an analytics and report automation role based in Edinburgh.

Job description

Project Description

The project is focused around supporting and extending current analytics and reporting services through additional service and automation.

The Graduate Technical Analyst is responsible for delivering web analytics consultancy and Excel-based marketing reports.

A pilot report automation project has been completed, and the Graduate Technical Analyst will become a key user and developer of the system: running command line ETL scripts, writing new automation scripts in Python, working with developers to extend functionality into an enterprise system. Suporting other areas of the the business who require ETL and analysis automation.

The role will give the successful candidate the opportunity to achieve the following:

• Learn Python and SQL
• Become a web analytics guru
• Play a key role in developing business automation solutions
• Work on a mixture of client consultancy and technical development projects

Placement Objectives

Reporting and report automation development

• Delivering high quality Excel marketing reports
• Optimising & automating report delivery using advanced Excel, SQL, and Python

Web Analytics

• Tracking code implementation and debugging
• Account configuration and optimisation
• Traffic and ROI analysis

Role Description

The placement is within the QueryClick R&D department and the successful candidate will play a key role in delivering and improving existing client analytics and reporting services.

Qualifications

Bachelor’s degree in Computer Science, Mathematics, Physics or related discipline.

Skills / Experience

Essential Skills

• Advanced Excel
• Basic Linux command line
• Database experience (any flavor)
• Some programming experience is essential, however being a ‘programmer’ is not a prerequisite
• Knowledge of web analytics
• Knowledge of internet marketing, especially SEO and PPC

Desirable Skills

• Authenticating with and using APIs to extract data
• Google Analytics, or Omniture experience
• Experience with Adwords interface, or better still, running Adwords campaigns
• JavaScript
• HTML
• XML
• Server architectures, such as LAMP

Benefits

Company benefits

• We're growing pretty fast and you'll never be bored
• We've got offices in Edinburgh, London and New York City (although we'd like you to work in Edinburgh, at least for now!)
• We organise social events such as white water rafting or cocktail classes
• We keep the office stocked with biscuits, drinks and nice tea & coffees
• Archie the dog will likely want to meet you for hugs (he's in about once a week)

Placement benefits

As part of ScotGrad Graduate Placement Programme, the successful candidate will have access to a free two day business and employability skills residential course and also benefit from ongoing support from the ScotGrad team throughout the duration of the placement.

Additional information

Location: Edinburgh

This placement may result in a permanent employment afterwards

Preferred start date: 1st September 2014

Company information

QueryClick are rapid growth SEO agency founded in 2008, with offices in Edinburgh, London and New York.

Company sector: Other

Company website: http://uk.queryclick.com