At a Glance
- Tasks: Build and optimise data infrastructure using Snowflake, dbt, Python, and SQL.
- Company: Join a fast-growing startup in London with exciting growth potential.
- Benefits: Enjoy competitive salary, equity options, and a dynamic work environment.
- Other info: No sponsorship available; ideal for those seeking a challenging role.
- Why this job: Be part of an innovative team and contribute to impactful projects.
- Qualifications: Hands-on experience with Snowflake, dbt, Python, and SQL required.
The predicted salary is between 42000 - 84000 £ per year.
Analytics Engineer
Location:London
Working arrangement: Hybrid, 1-2 days per week in the office
Salary: Up to £55,000 plus bonus
About the Business
An established technology business is looking for an Analytics Engineer to join its Data Platform team. Data sits at the heart of its customer experience, with teams across the business relying on trusted insights to improve products, understand customer behaviour and make better decisions.
The Opportunity
You'll work at the intersection of data engineering and analytics, building scalable transformation pipelines and reliable data models that support reporting, experimentation and decision‑making.
Working closely with Product, Marketing, Engineering, BI and Data Science, you'll translate business requirements into accessible, well documented data products. Alongside delivering new models, you'll help improve data quality, warehouse performance and the wider data platform.
Key Responsibilities
- Build, optimise and maintain data transformation pipelines using dbt and Snowflake.
- Design reusable data models that support consistent, trusted reporting and analysis.
- Improve the performance, security and cost efficiency of the Snowflake data warehouse.
- Develop automated data quality tests, monitoring and alerting.
- Collaborate with stakeholders across Product, Marketing, BI, Engineering and Data Science to deliver data products that meet business needs.
- Maintain clear documentation and promote best practices in analytics engineering.
- Contribute to platform improvements, including the evaluation and adoption of orchestration tools such as Dagster.
- Ensure data products remain reliable, accessible and useful as business requirements evolve.
Skills and Experience
- Strong SQL skills, including experience writing and optimising complex queries.
- Commercial experience using dbt to build and maintain data transformation pipelines.
- Experience with Snowflake or another modern cloud data warehouse, such as BigQuery.
- Experience building data models for analytics and reporting.
- Familiarity with Python for automation, data manipulation or integration tasks.
- An interest in improving data quality, reliability and performance.
- Strong problem‑solving skills and the ability to work in a collaborative environment.
- Clear communication skills, with the ability to translate business requirements into technical solutions.
Technology Environment
The wider stack includes Snowflake, dbt, SQL, Python, Fivetran, Dagster, Metaplane and Tableau, alongside AWS, Terraform and GitHub.
You don't need experience with every tool listed. Strong SQL, commercial dbt experience and relevant cloud data warehouse experience are the key requirements.
What's on Offer
- Base salary of up to £55,000 plus bonus.
- Hybrid working with 1-2 days per week in the Farringdon office.
- The opportunity to influence data models, engineering practices and platform improvements.
- Collaboration with teams across Product, Marketing, Engineering, BI and Data Science.
- An environment that values continuous improvement, knowledge sharing and learning.
Analytics Engineer in London employer: Xcede
As a Mobility Engineer/Consultant with us, you'll thrive in a dynamic remote work environment that champions innovation and collaboration. We offer competitive benefits, a strong focus on employee development, and the opportunity to work on cutting-edge enterprise solutions that make a real impact. Join our team and be part of a culture that values your expertise and encourages professional growth while ensuring you have the tools and support needed to excel in your role.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer in London
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Snowflake, dbt, Python, and SQL. Consider working on personal projects or contributing to open-source projects that utilise these technologies to showcase your skills.
✨Tip Number 2
Network with professionals in the analytics field, especially those who work with startups. Attend meetups, webinars, or online forums where you can connect with others and learn about potential opportunities at companies like ours.
✨Tip Number 3
Prepare for technical interviews by practising common analytics engineering problems and scenarios. Focus on data modelling, ETL processes, and how to optimise data pipelines, as these are likely to come up during the interview process.
✨Tip Number 4
Show your enthusiasm for the role and the company during any interactions. Research our company culture and values, and be ready to discuss how your personal goals align with our mission and growth trajectory.
We think you need these skills to ace Analytics Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your hands-on experience with Snowflake, dbt, Python, and SQL. Use specific examples of projects or tasks where you utilised these skills to demonstrate your expertise.
Craft a Compelling Cover Letter:Write a cover letter that not only outlines your technical skills but also expresses your enthusiasm for joining a fast-growing startup. Mention why you're excited about the opportunity and how you can contribute to their data infrastructure.
Showcase Relevant Projects:If you have worked on relevant projects, consider including a portfolio or a brief description of these projects in your application. This can help illustrate your practical experience and problem-solving abilities.
Proofread Your Application:Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects attention to detail, which is crucial for an Analytics Engineer role.
How to prepare for a job interview at Xcede
✨Showcase Your Technical Skills
Make sure to highlight your hands-on experience with Snowflake, dbt, Python, and SQL during the interview. Prepare specific examples of projects where you used these tools to solve problems or optimise data processes.
✨Understand the Company’s Data Needs
Research the startup's business model and how they utilise data. This will help you tailor your answers to demonstrate how your skills can directly benefit their data infrastructure and overall goals.
✨Prepare for Problem-Solving Questions
Expect to face technical questions or case studies that assess your analytical thinking. Practice explaining your thought process clearly and concisely, as this will showcase your problem-solving abilities.
✨Ask Insightful Questions
Prepare thoughtful questions about the company's data strategy, team structure, and growth plans. This shows your genuine interest in the role and helps you determine if the company is the right fit for you.