04 ago
|
Travelperk
|
Barcelona
04 ago
Travelperk
Barcelona
ph3Overview /h3 pThis role sits at the intersection of Data Engineering and Data Analytics, transforming raw data into high‑quality, trustworthy datasets and visualisations for business users. The idóneo candidate has strong experience in SQL, dbt, data modelling, ETL/ELT principles, and modern cloud data platforms. /p h3Core Responsibilities /h3 ul libDevelop and maintain ELT transformation best practices: /b Design, develop, and maintain scalable workflows using dbt to transform raw data in Snowflake into clean, ready‑to‑use data models. /li libData Modelling: /b Apply best‑practice data modelling and engineering techniques to optimise data structures for performance, accuracy, and usability in reporting and analytics. /li libData Quality and Testing: /b Write comprehensive data quality checks, tests, and monitoring scripts; establish and maintain documentation for all transformations and models. /li libCollaboration: /b Work closely with Data Analysts and business users to understand reporting needs and optimise data models; collaborate with Data Engineers on ingestion strategies and platform optimisation. /li libPerformance Optimisation: /b Tune and optimise SQL queries and data models to reduce latency and improve warehouse and downstream application performance. /li libTool Adoption: /b Champion adoption of modern data stack tools and practices, including Git and CI/CD. /li libData Visualisation: /b Build scalable, compelling Looker visualisations that can be used by large teams.
/li /ul h3Required Qualifications /h3 ul li3+ years of experience in a data‑focused role (Analytics Engineer, Data Analyst, BI Developer, etc.). /li liExpert‑level proficiency in writing and optimising complex SQL queries. /li liHands‑on experience with dbt or a similar data transformation framework. /li liExperience with cloud data warehouses such as Snowflake, Google BigQuery, or Amazon Redshift. /li liSolid understanding of data warehousing concepts, ETL/ELT principles, and dimensional modelling techniques. /li liProficiency with Git for collaborative development and version control. /li liFamiliarity with reporting/BI tools such as Looker. /li /ul h3Preferred Qualifications /h3 ul liPython expertise for automation, integration, and orchestration. /li liExperience with semantic layers. /li liExperience with orchestration tools such as Airflow. /li liKnowledge of modern software engineering practices applied to data (modularity, code review, testing). /li /ul h3Location Relocation /h3 pThis role requires the candidate to be based within commuting distance of our London or Barcelona hub. We can assist with relocation from anywhere in the world. English is the official language at the office. /p h3Equal Opportunity Statement /h3 pWe are an equal opportunity employer. You are welcome at Perk regardless of how you look, where you’re from, or anything else that makes you, well, you. /p p#LI-Hybrid /p /p #J-18808-Ljbffr
📌 Analytics Engineer (Barcelona)
🏢 Travelperk
📍 Barcelona