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: Collaborative environment with a focus on modern data practices and career advancement.
- Why this job: Make a real impact by optimising data for insightful decision-making.
- 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 in London 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 in London
✨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 in London
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your SQL mastery in your application. We want to see how you've tackled complex queries and optimised them for performance. Share specific examples that demonstrate your expertise!
Talk About Your Data Transformation Experience:If you've worked with dbt or similar tools, let us know! Describe your experience in developing ELT pipelines and how you've transformed raw data into clean datasets. We love hearing about your hands-on experience.
Emphasise Collaboration:This role is all about teamwork, so mention any experiences where you've collaborated with Data Analysts or Engineers. Tell us how you’ve understood their needs and optimised data models to support their analytical use cases.
Keep It Clear and Concise:When writing your application, clarity is key! Make sure your points are easy to read and straight to the point. We appreciate a well-structured application that gets to the heart of your qualifications without fluff.
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 tools. Highlight any projects where you designed and maintained ELT pipelines, and explain how you ensured data quality and reliability throughout the transformation process.
✨Understand Data Modelling Principles
Familiarise yourself with best practices in data modelling and be prepared to discuss how you've applied these in past roles. Think about how you can demonstrate your understanding of dimensional modelling techniques and how they relate to performance optimisation.
✨Collaboration is Key
This role involves working closely with Data Analysts and Engineers, so be ready to share examples of how you've collaborated in the past. Discuss how you’ve gathered requirements from business users and optimised data models to meet their analytical needs.
