Data Engineer (Mid Level) in City of London
Data Engineer (Mid Level)

Data Engineer (Mid Level) in City of London

City of London Full-Time 36000 - 60000 £ / year (est.) No home office possible
Pubitygroup

At a Glance

  • Tasks: Build and maintain data pipelines, ensuring reliable and accessible data across the business.
  • Company: Join Pubity, a fast-paced company where you can shape the data function from the ground up.
  • Benefits: Competitive salary, hands-on experience, and the chance to make a real impact.
  • Why this job: Be the first dedicated data engineer and take ownership of exciting projects early in your career.
  • Qualifications: Experience with SQL, Python, and building production data pipelines is essential.
  • Other info: Dynamic environment with opportunities for growth and collaboration across teams.

The predicted salary is between 36000 - 60000 £ per year.

London – 4 Days in Office

Note: We are unable to provide Visa Sponsorship for this role.

Data at Pubity moves fast. We’re looking for an engineer who wants to take real ownership early in their career and become the first dedicated data hire at the company. You will help build the foundations of how data works across the business. That means creating reliable pipelines, structuring messy inputs, and building systems the team can trust to make decisions. If you enjoy building things from the ground up, working closely with stakeholders, and developing scalable data systems as you grow into the role, this is a rare opportunity to do it.

About the Role

As our first Data Engineer, you will help shape Pubity Group’s data function from the ground up. This is a hands-on role where you will design and build the first generation of our data pipelines and models. You will work closely with the Director of Special Projects and teams across Social, Commercial and Studio to ensure data is reliable, accessible and useful across the business. You won’t be expected to arrive with a fully built playbook. Instead, we want someone capable, curious and ambitious who wants to take ownership of the data layer and grow into the role as the function scales.

Key Responsibilities

  • Take ownership of the company’s early stage data infrastructure and help shape how it evolves.
  • Build and maintain data pipelines and models in GCP using BigQuery, SQL and Python.
  • Develop reliable Python pipeline code using tools such as requests and pandas.
  • Build and maintain API integrations across platforms including Meta, TikTok, YouTube and X.
  • Expand pipelines into internal systems such as CRM platforms, project management tools and Slack.
  • Implement data validation, monitoring and quality checks to ensure reliability.
  • Help establish metric definitions and consistent reporting standards across platforms.
  • Schedule and orchestrate data workflows using GCP tools such as Cloud Composer.
  • Work with teams across Social, Editorial, Commercial and Studio to deliver reporting and dashboards.
  • Document pipelines, definitions and processes so the data function can scale properly over time.

What We’re Looking For

Must Haves

  • Experience building and maintaining production data pipelines.
  • Strong SQL skills and experience with BigQuery or a similar warehouse.
  • Strong Python skills for data pipelines and API integrations.
  • Experience working with APIs and ingesting external platform data.
  • Familiarity with modern data modelling tools such as dbt or Dataform.
  • A mindset focused on reliability, monitoring and good engineering practices.

Important

  • Experience with orchestration tools such as Cloud Composer, Airflow or similar.
  • Experience connecting data models to BI platforms such as Power BI, Looker or similar.
  • Ability to work with stakeholders and prioritise requests across teams.

Nice to Have

  • Experience optimising queries and managing warehouse costs.
  • Postgres or Supabase experience.
  • Node.js scripting for integrations.
  • Exposure to multiple cloud environments such as AWS or Azure.

Platforms and Pipeline Scope

You will help build and scale pipelines across:

  • Meta (Facebook and Instagram) which already have integrations.
  • Next platforms including TikTok, YouTube, X, Snap, LinkedIn and Google Ads.
  • Internal systems such as CRM platforms, project management tools, meeting trackers and Slack.

Much of this infrastructure will be built for the first time, and you will play a key role in defining how it works.

You’ll Thrive Here If

  • You enjoy building things from scratch.
  • You want ownership and impact early in your career.
  • You like solving messy data problems and making systems reliable.
  • You work well with non-technical teams and can translate data into useful outputs.

Data Engineer (Mid Level) in City of London employer: Pubitygroup

At Pubity, we pride ourselves on fostering a dynamic and innovative work culture where every team member has the opportunity to make a significant impact. As our first dedicated Data Engineer, you will not only take ownership of building our data infrastructure from the ground up but also benefit from a collaborative environment that encourages personal and professional growth. Located in London, we offer a unique chance to shape the future of our data function while working closely with diverse teams across the business.
Pubitygroup

Contact Detail:

Pubitygroup Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer (Mid Level) in City of London

✨Tip Number 1

Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. The more you engage, the better your chances of landing that dream job.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your data projects, pipelines, and any cool stuff you've built. This will give employers a taste of what you can do and set you apart from the crowd.

✨Tip Number 3

Prepare for interviews by practising common data engineering questions and scenarios. Think about how you'd tackle real-world problems and be ready to discuss your thought process. We want to see your problem-solving skills in action!

✨Tip Number 4

Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect directly with us.

We think you need these skills to ace Data Engineer (Mid Level) in City of London

Data Pipeline Development
SQL
BigQuery
Python
API Integration
Data Validation
GCP
Cloud Composer
Data Modelling Tools
Reliability Engineering
Stakeholder Management
BI Platforms
Orchestration Tools
Data Quality Checks
Documentation Skills

Some tips for your application 🫡

Show Your Passion for Data: When you're writing your application, let us see your enthusiasm for data engineering! Share specific examples of projects you've worked on that showcase your skills in building data pipelines and working with SQL or Python. We want to know what excites you about this role!

Tailor Your CV and Cover Letter: Make sure your CV and cover letter are tailored to the job description. Highlight your experience with GCP, BigQuery, and any relevant tools like Cloud Composer. This shows us that you understand what we're looking for and how you can contribute to our team.

Be Clear and Concise: Keep your application clear and to the point. Use bullet points where possible to make it easy for us to read through your experience and skills. We appreciate a well-structured application that gets straight to the good stuff!

Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it gives you a chance to explore more about our company and culture while you're at it!

How to prepare for a job interview at Pubitygroup

✨Know Your Tech Stack

Make sure you’re familiar with the tools mentioned in the job description, like GCP, BigQuery, SQL, and Python. Brush up on your skills and be ready to discuss how you've used these technologies in past projects.

✨Showcase Your Problem-Solving Skills

Prepare examples of how you've tackled messy data problems or built reliable systems. Be ready to explain your thought process and the impact your solutions had on previous teams or projects.

✨Understand the Business Context

Research Pubity Group and understand their business model. Think about how your role as a Data Engineer can support their goals and how you can contribute to making data reliable and accessible across different teams.

✨Ask Insightful Questions

Prepare thoughtful questions for your interviewers about the data function and its future. This shows your interest in the role and helps you gauge if the company is the right fit for you.

Data Engineer (Mid Level) in City of London
Pubitygroup
Location: City of 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

>