Analytics Engineer

About Us: Locaria is a leading multilingual marketing and linguistic services agency that operates across more than 90 global markets. We blend insights, data, talent, and technology to take global content further for ambitious brands. Locaria is central to the global content solution of Stagwell, the challenger advertising network.

We have been recognized by the following awards:

Home to the Association of Translation Companies' Innovator of the Year Shortlisted for three business awards by The Drum Named "Best Workplace for Training & Personal Development" by Adaptive Recognised as Top mid-market language service providers by Nimdzi Insights Overview: We are looking for a skilled and data-enthusiastic Analytics Engineer to join our young data science, engineering, and analytics team in Barcelona. In this role, your focus will be:

75% of your time you will work on automating internal processes, building utility applications, dashboards, and analytical frameworks, supporting internal stakeholders with tools, data, and insights. 25% of your time will be dedicated to managing SQL-based shopping feeds, maintaining data pipelines, performing data analysis on digital marketing data, and communicating directly with clients. We are a young, dynamic team looking for someone who's eager to make an impact. We need a team player who can communicate effectively with both technical and business stakeholders. You should enjoy collaborating with others and be passionate about using technology to solve real-world problems for non-technical colleagues. This role is hands-on, where you will translate business problems into technical solutions, developing data applications and workflow automations in Python and deploying them on Google Cloud Platform. Additionally, you will support maintaining a major SQL-based data pipeline for a key client, handling client communication and technical troubleshooting.

Responsibilities: End-to-end Pipeline Management: Support in maintenance of Google Shopping feeds by writing and optimising SQL queries. Troubleshoot issues in our internal system and Google Merchant Center, addressing both internal and client flags efficiently. Provide technical support for any other technical- or feed-related topics, ensuring client collaboration and satisfaction is maintained. Proactively identify and propose improvements to feed quality and performance in the feeds to external stakeholders. Workflow Automation: Map out internal workflows and processes and automate what can be automated. Utility Application Development: Participate in or lead the end-to-end design, development, and deployment of web utility applications to facilitate workflows, tasks, and processes within the company. Analytical Dashboard Design & Deployment: Design, build and deploy dashboards and analytical frameworks to deliver insights to internal and external stakeholders. Collaboration & Communication: Collaborate effectively with both technical and non-technical stakeholders, translating complex technical concepts into understandable terms for business teams. Follow and actively contribute to our data-team's "way of working" concepts and conventions. Presentations: Lead or support the creation and delivery of clear, insightful presentations that communicate key insights, ideas, and improvement opportunities to clients and internal, external stakeholders. Documentation: Create clear, thorough, and comprehensive documentation of all processes, workflows, and technical implementations, ensuring that everything is well-documented and easy to follow. Qualifications: Shopping Feeds Management: Proven working experience in SQL Workflow Automation: Proven working proficiency with Python (Knowledge of best practices: classes, compute-efficient code, data-structure, commenting, etc.) Analytical Dashboard Design & Deployment: Working experience with dashboarding tools, such as Looker, PowerBI, Tableau. Data Pipelines: Experience in understanding, maintaining & optimising ETL pipelines. Databases: Understanding of relational databases and No-SQL databases. Version Control: Familiarity with Git and GitHub. Cloud Engineering: Exposure to Cloud Deployment solutions such as Google Cloud, Azure, or AWS. (GCP preferred). Soft skills: Collaboration Skills: Proven ability to work collaboratively across teams and departments. Communication: Ability to communicate clearly and concisely in fluent English, both written and spoken, with internal and external stakeholders. Critical thinking, problem-solving attitude. Big Plus: Ideally knowledge of Google Merchant Centre, Google Analytics, Search Ads 360 Containerisation: Knowledge of containerisation principles (Docker). Utility Application Development: Experience with frameworks such as flask, Django, dash, fastAPI Web development: Experience with JavaScript frameworks Equal Opportunities: Locaria is global by nature and vastly strengthened by multicultural, international and eclectic teams. Working together to achieve shared goals, our employees recognise the importance of our core value 'celebrating individuality', and are supported by Locaria's breadth of cultural resources and insights that attract and retain the best talent.

We appreciate the unique perspectives and experiences that each person brings to our team and are fully dedicated to ensuring equal opportunities across the board, regardless of race, color, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability and gender identity. If you have a disability or special need that requires accommodation, please let our team know.

Join our team and become part of a vibrant workplace and company culture that values and celebrates individuality!

Benefits: In return for your interest 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 (pro rata 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 depending on the level of the role being recruited for. Rest and Recharge: The option to lengthen your standard 1-hour lunch break by 30 minutes, as long as you maintain the same number of hours you work a day. Do Some Good Along the Way Days: In line with our 'Doing Some Good Along The Way' value, which you will have the opportunity to get involved with if you'd like to. This also allows all employees up to 2 days off a year to get involved in charity initiatives. OpenUp: Access for you and three family members to OpenUp, a mental health support platform designed for your personal and professional growth. Including 1:1 sessions with psychologists, masterclasses, mindfulness sessions and online courses and articles.


#J-18808-Ljbffr