Mid Analytics Engineer (SQL & DBT) in London
Mid Analytics Engineer (SQL & DBT)

Mid Analytics Engineer (SQL & DBT) in London

London Freelance 50000 - 65000 £ / year (est.) Home office possible
Toucanberry Tech

At a Glance

  • Tasks: Analyse complex data and provide insights for financial services clients.
  • Company: Dynamic start-up focused on innovative data solutions.
  • Benefits: Fully remote work, competitive pay, and long-term contract opportunities.
  • Other info: Work in a fast-paced environment with great career growth potential.
  • Why this job: Join a high-performing team and tackle real-world data challenges.
  • Qualifications: Experience with SQL, DBT, and Python; strong communication skills.

The predicted salary is between 50000 - 65000 £ per year.

You will join one of our high-performing consultant teams, delivering cutting‑edge solutions for our financial services clients. This is a hands‑on role where your data analysis skills and financial acumen will be essential to supporting senior business experts. You will be moving beyond the limitations of standard tools like Excel to solve complex data challenges. Working directly with critical data in the reinsurance domain, performing data crunching & providing actionable insights that inform key decisions.

Key Responsibilities

  • Perform complex data manipulation and analysis to support senior business experts and stakeholders.
  • Utilise Python and its data libraries to handle large datasets and automate analytical tasks.
  • Design and execute robust data mapping and analysis projects.
  • Work with our expert teams to understand client needs and translate them into effective data solutions.
  • Working in a fast paced start‑up agile and high pressure environments.

Must Have

  • Domain knowledge: Have worked within the operations team for an asset management department and understands assets data, like financial securities, trading data.
  • SQL: Data manipulation and querying.
  • DBT: Transforming raw data in the warehouse into clean, tested & documented models using SQL.
  • Python: Experience in libraries like Pandas and NumPy.
  • Communication: Excellent senior stakeholder, articulate, presenting & engagement skills.

Nice‑to‑Haves

  • Familiarity with Databricks.
  • Cloud Platform: Building on Azure / GCP.

Additional Information

  • Fully Remote
  • Outside IR35
  • Long term contract
  • £500/day

Mid Analytics Engineer (SQL & DBT) in London employer: Toucanberry Tech

As a leading player in the financial services sector, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to excel. Our fully remote setup offers unparalleled flexibility, allowing you to balance your professional and personal life while working on impactful projects that drive innovation. With a focus on continuous learning and development, we provide ample opportunities for growth, ensuring that you can advance your career while contributing to meaningful solutions in the reinsurance domain.
Toucanberry Tech

Contact Detail:

Toucanberry Tech Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Mid Analytics Engineer (SQL & DBT) in London

✨Tip Number 1

Network like a pro! Reach out to people in the industry, especially those who work in financial services or analytics. A friendly chat can lead to opportunities that aren’t even advertised yet.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your data manipulation projects, especially using SQL and DBT. This will give potential employers a taste of what you can do and set you apart from the crowd.

✨Tip Number 3

Prepare for interviews by brushing up on your Python skills and understanding how to apply them in real-world scenarios. Be ready to discuss how you've used libraries like Pandas and NumPy to solve complex data challenges.

✨Tip Number 4

Don’t forget to apply 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 their job search!

We think you need these skills to ace Mid Analytics Engineer (SQL & DBT) in London

Data Analysis
Financial Acumen
SQL
DBT
Python
Pandas
NumPy
Data Manipulation
Data Mapping
Stakeholder Engagement
Communication Skills
Agile Methodologies
Cloud Platforms (Azure / GCP)
Problem-Solving Skills

Some tips for your application 🫡

Show Off Your Skills: Make sure to highlight your SQL and DBT experience in your application. We want to see how you've used these tools to tackle complex data challenges, so don’t hold back on the details!

Tailor Your Application: Take a moment to customise your application for this role. Mention your experience in financial services and how it relates to the responsibilities listed. We love seeing candidates who understand our needs!

Be Clear and Concise: When writing your application, keep it straightforward. Use clear language to explain your past experiences and how they relate to the role. We appreciate a well-structured application that gets to the point!

Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can’t wait to hear from you!

How to prepare for a job interview at Toucanberry Tech

✨Know Your Data Tools

Make sure you brush up on your SQL and DBT skills before the interview. Be ready to discuss how you've used these tools in past projects, especially in the context of financial data. Practising some common queries and transformations can really help you feel confident.

✨Showcase Your Analytical Skills

Prepare to talk about specific examples where you've performed complex data manipulation and analysis. Think about challenges you've faced and how you overcame them using Python and its libraries like Pandas and NumPy. Real-world examples will make your experience stand out.

✨Understand the Financial Context

Since this role is focused on financial services, it’s crucial to demonstrate your understanding of asset management and trading data. Brush up on key concepts and be ready to discuss how your domain knowledge can benefit the team and their clients.

✨Engage with Stakeholders

Communication is key! Prepare to showcase your ability to engage with senior stakeholders. Think of ways to articulate your insights clearly and effectively. You might even want to practice presenting a data-driven solution to a hypothetical problem to show off your presentation skills.

Mid Analytics Engineer (SQL & DBT) in London
Toucanberry Tech
Location: London

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>