At a Glance
- Tasks: Transform raw data into high-quality datasets and visualisations for business users.
- Company: Join a forward-thinking company that values diversity and innovation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Work in a dynamic environment with excellent career advancement opportunities.
- Why this job: Make an impact by optimising data for real-world applications and collaborating with talented teams.
- Qualifications: 3+ years in a data role, SQL expertise, and experience with dbt and cloud data platforms.
The predicted salary is between 50000 - 65000 € per year.
This critical role sits at the intersection of Data Engineering and Data Analytics, focusing on transforming raw data into high-quality, trustworthy, and easily consumable datasets and visualisations for business users. The ideal candidate will possess a strong background in SQL, dbt, data modelling, ELT/ELT principles and experience with modern cloud data platforms.
Core Responsibilities
- Develop and maintain transformation best practices in ELT Pipelines: Design, develop, and maintain efficient and scalable workflows using tools like dbt to transform raw data loaded into our data warehouse (Snowflake) into clean, ready-to-use data models.
- Data Modelling: Implement best-practice data modelling and software engineering techniques to ensure data structures are optimised for performance, accuracy, and ease of use in reporting and analytical applications.
- Data Quality and Testing: Write comprehensive data quality checks, tests, and monitoring scripts to ensure the accuracy, completeness, and reliability of all transformed data assets. Establish and maintain documentation for all data transformations and models.
- Collaboration: Work closely with Data Analysts and business users to understand their reporting needs and optimise data models to support their analytical use cases. Collaborate with Data Engineers on data ingestion strategies and platform optimisation.
- Performance Optimisation: Tune and optimise SQL queries and data models to reduce latency and improve the performance of our data warehouse and downstream applications.
- Tool Adoption: Champion the adoption of modern data stack tools and practices (e.g. Git, CI/CD). Build scalable, compelling data visualisations in Looker that can be used by large teams.
Required Qualifications
- Experience: 3+ years of experience in a data-focused role (e.g., Analytics Engineer, Data Analyst, BI Developer).
- SQL Mastery: Expert-level proficiency in writing and optimising complex SQL queries.
- Data Transformation Tooling: Hands-on experience with dbt (Data Build Tool) or similar data transformation frameworks is essential.
- Data Warehousing: Experience working with cloud-based data warehouses such as Snowflake, Google BigQuery, or Amazon Redshift.
- Data modelling: Solid understanding of data warehousing concepts, ETL/ELT principles, and dimensional modelling techniques.
- Version Control: Proficiency with Git for collaborative development and version control. Familiarity with reporting/BI tools like Looker.
Preferred Qualifications
- Python expertise for automation, integration, and orchestration.
- Experience with Semantic layers.
- Experience with orchestration tools like Airflow.
- Knowledge of modern software engineering practices applied to data (e.g., modularity, code review, testing).
Location Requirements
This role requires you to be based within commuting distance of our London or Barcelona hubs. For certain roles, relocation assistance may be available. English is the official language at the office.
Equal Opportunity Employment
We’re an equal opportunity employer, which means you’re welcome at Perk regardless of how you look, where you’re from, or anything else that makes you, well, you.
Analytics Engineer employer: Traveltechessentialist
At Perk, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters collaboration and innovation. Our Analytics Engineers benefit from a supportive environment that encourages professional growth through continuous learning opportunities and access to cutting-edge tools. With our London and Barcelona hubs, employees enjoy a vibrant atmosphere and the chance to work alongside talented professionals in a diverse and inclusive setting.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the analytics game. Building relationships can open doors that job applications alone can't.
✨Show Off Your Skills
Create a portfolio showcasing your best work. Whether it’s SQL queries, data models, or visualisations, having tangible examples of what you can do will make you stand out. Don’t forget to share this on platforms like LinkedIn!
✨Ace the Interview
Prepare for common interview questions but also be ready to discuss your thought process when tackling data problems. We want to see how you think, not just what you know. Practice makes perfect, so consider mock interviews with friends!
✨Apply Through Our Website
Don’t forget to apply directly through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about joining our team!
We think you need these skills to ace Analytics Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Analytics Engineer. Highlight your SQL mastery, experience with dbt, and any cloud data platforms you've worked with. We want to see how your skills align with our needs!
Showcase Your Projects:Include specific examples of projects where you've developed ELT pipelines or optimised data models. We love seeing real-world applications of your skills, so don’t hold back on the details!
Be Clear and Concise:When writing your application, keep it straightforward. Use clear language and avoid jargon unless it's relevant. We appreciate a well-structured application that gets straight to the point!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s the easiest way for us to track your application and ensure it reaches the right people!
How to prepare for a job interview at Traveltechessentialist
✨Master Your SQL Skills
Since the role requires expert-level proficiency in SQL, make sure you brush up on your complex query writing and optimisation techniques. Prepare to discuss specific examples of how you've used SQL to solve problems or improve processes in your previous roles.
✨Showcase Your Data Transformation Experience
Be ready to talk about your hands-on experience with dbt or similar data transformation tools. Highlight any projects where you designed and maintained ELT pipelines, and explain how you ensured data quality and reliability throughout the process.
✨Understand Data Modelling Principles
Familiarise yourself with best practices in data modelling and be prepared to discuss how you've implemented these in past projects. Think about how you can demonstrate your understanding of dimensional modelling techniques and how they apply to performance optimisation.
✨Collaboration is Key
This role involves working closely with Data Analysts and business users, so be ready to share examples of how you've collaborated in the past. Discuss how you’ve gathered requirements, optimised data models for analytical use cases, and championed tool adoption within teams.
