SQL Data Analyst - Barcelona, España - Locaria

Locaria

Empresa verificada

Barcelona, España

hace 2 semanas

Publicado por:

Isabel García

beBee Recruiter

Descripción

Locaria is a pioneering multilingual marketing and language services agency that sits within The Stagwell Group and MDC Partners.

We maximise the effectiveness and performance of global content seamlessly across territory, platform and media for brands with international ambition.

We combine engagement metrics with content creation processes by harnessing data from all stages of the customer journey including awareness, consideration and engagement.

We do this in any language combination, across more than 90 markets.
Our global clients include the world's top brands across luxury, retail, travel, hospitality, finance, market research and tech.

THE TEAM

Our Data team is made up of Data Scientists, Data analysts and Data engineers focused in the management of various products within a Presto like Query Engine.

Within our team you will be able to create, manage and manipulate product data feeds for all channels and provide data visualisations (dashboard creation), ETL solutions and competitor analysis for clients.

The role spans all existing channels (including but not limited to display, paid social, organic performance, affiliates, content creation and localisation) as well as working on stand alone propositions and new services centred around the use of structured data.

KEY RESPONSIBILITIES

Working with the Structured Data and implementing changes to the available systems
Addressing challenges or opportunities presented by clients
Ideation, management and improvement of additional services centred around any currently available or newly sourced datasets
Liaising with internal teams, addressing their feed challenges or opportunities, creating bespoke solutions using technology
End to end management of feeds for various channels and platforms, including (but not limited to) Google and Bing shopping, social, affiliates and display activity
This includes identifying and sourcing available raw data, managing the content, and combining data from any additional sources (currently available or new)

Requirements:

You will have the following core skills and abilities:

Basic knowledge of SQL
Strong analytical individual who enjoys lateral thinking and problem solving
Attention to detail and able to effectively troubleshoot issues across various data sources and platforms
Proactive individual who is confident taking the initiative and working with colleagues across teams and departments
Advanced usage of Excel (ie: Pivot tables) and Google Analytics

Ideally, you'll also have experience in the below:

Understanding of Google search, shopping, social, affiliates and display activity
Any prior experience with GDS, Datorama, Tableau, or similar
Any knowledge of python

You'll live up to the Locarian Values

We take content further
We grow together
Celebrating Individuality
Doing good along the way
With care

Benefits:

In return for your enthusiasm and expertise, we can offer an exciting and multicultural place of work, competitive salary, wide range of benefits, and the chance to progress your career within a truly global organization.

Some of these benefits include:

Holiday: You will be entitled to 22 working days paid leave per year (prorata in first year), excluding public holidays.
Flexible Working: Opportunities to work from home up to 3 days a week through our Flexible Working Policy, plus opportunities to work abroad.
Refer a

Friend Scheme:
We're always on the lookout for talented people.

If you refer a friend who is then hired, we will award you with a bonus of up to £2,000 depending on the level of the role being recruited for.

Birthday Day Off: As a gift from us you will receive an extra day off for your birthday each year. If your birthday falls on a weekend, then you can take this the Friday before or Monday after.
Abroad Working: The opportunity to work from anywhere, whilst still working, allowing you to reengage with your local culture, keep your native language current and increase wellbeing by staying in touch with family and friends.
Equipment: You will be equipped with a laptop, extra screen, mouse and keyboard.