Senior Data Engineer

Citywire GmbH

Greater London

Hybrid

GBP 90,000 - 130,000

Full time

46 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

25 days holiday
Flexible working
Well-being allowance
Eye-test allowance
Pension scheme
Critical illness cover
EAP 24/7
Cycle to work
Techscheme
Income protection
Private medical & dental

Job summary

Citywire is seeking a Senior Data Engineer to own and develop our data platform, building Python pipelines and dbt models while mentoring peers. You’ll work with BigQuery, Postgres, OpenSearch and SurrealDB to ensure accurate, timely data behind our AI systems.

You will shepherd testing, lineage, ADRs and infrastructure as code (Terraform). The role offers flexible hybrid working options and a collaborative engineering culture in London.

Qualifications

  • Proven experience in data engineering with strong Python and SQL.
  • Production dbt: incremental models and tests on BigQuery or Snowflake.
  • Orchestration experience with Prefect, Airflow or Dagster in production.

Responsibilities

  • Build and run Python pipelines from multiple sources into BigQuery and grow our dbt estate.
  • Own testing, source reconciliation and data lineage for reported figures.
  • Run Prefect orchestration on ECS with reliable retries and runbooks.

Skills

Python
SQL
dbt
BigQuery
ETL
Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

Terraform
AWS
S3
SQS
ECS
OpenSearch
Postgres
Airflow
Dagster
Prefect

Job description

Citywire’s data platform powers products across the company, from Editorial and Sales reporting to Board figures and our production AI systems. We’re hiring a Senior Data Engineer to own and develop it - the pipelines, dbt models and orchestration at its core. You’ll be the senior hands-on engineer in a team of four, reporting to the platform lead. You’ll mentor other engineers, set the dbt standards for our analysts and own how your parts of the platform are built.

What you'll be doing:
  • Building and running Python pipelines from HubSpot, Stripe, Adform and other sources into BigQuery, and develop our dbt estate of around 140 models.
  • Owning the testing, source reconciliation and lineage behind every reported figure.
  • Run our Prefect orchestration on ECS with idempotent loads, sensible retries, alerting and runbooks.
  • Working with the Platform Lead on the data behind our AI platform, including loads into Postgres, OpenSearch and SurrealDB.
  • Taking ownership of our Stripe webhook and subscription CDC pipelines on SQS and Lambda.
  • Reviewing analysts’ dbt work and mentor engineers through code review and pairing.
  • Managing your infrastructure in Terraform and document significant decisions in ADRs (architecture decision records).
What we're looking for:
  • Experience: Proven experience in data engineering, with strong Python and SQL.
  • Production dbt: Incremental models and tests on BigQuery, Snowflake or a similar warehouse.
  • Orchestration: Prefect, Airflow or Dagster in production.
  • API integration: Handling rate limits, pagination and incremental syncs.
  • AWS and Terraform: Working knowledge of Lambda, S3, SQS and ECS, and comfort changing Terraform.
  • Testing: You reproduce a bug with a test before you fix it.
  • Mentoring: You’ve reviewed others’ SQL and dbt and helped people new to version control.
  • Judgement: You fix the problem in front of you rather than rewrite the platform, and you know when a decision isn’t yours to make.
  • Clear writing: Your write‑ups are concise, cite numbers and are honest about what didn’t work.
  • AI tooling: You use tools like Claude Code hands‑on and check their output properly.
Nice to haves:
  • Event-driven pipelines: SQS FIFO, dead‑letter queues, CDC
  • Postgres and Alembic, or FastAPI and Pydantic
  • OpenSearch or graph databases such as SurrealDB or Neo4j
  • Preparing data for LLM applications
  • Media, publishing or subscription experience
Meet Citywire

We cover - and connect - all sides of the $100 trillion global asset management industry - through our news, events and insights.

At Citywire, we uphold a culture rooted in honesty, integrity, and fairness, where every voice is valued and heard. Our culture promotes constructive dialogue and collaboration on a global scale.

Join the team at the Heart of Wealth.

Our perks:
  • Generous holiday entitlement: Start with 25 days per annum, increasing to 28 days after three years' service, and 30 days after five years' service, in addition to bank holidays.
  • Flexible working options.
  • Annual allowance for well‑being activities or gym memberships, with assistance available for monthly or annual costs.
  • Eye‑test and glasses allowance.
  • Competitive private pension scheme.
  • Critical illness cover and group life assurance from day one of employment.
  • Well‑being support: Access to an independent Employee Assistance Programme, available 24/7.
  • Cycle to work scheme and annual travel card loans.
  • Techscheme: Purchase the latest tech through our employer scheme, spreading the cost over 12 months with National Insurance savings.
  • After two years of continuous service, access group income protection, private medical, and dental insurance.

Citywire is an equal opportunities employer.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Citywire • City Of London

On-site
GBP 50,000 - 70,000
Generous holiday entitlement
Flexible working options
Annual well-being allowance
AWS/Python Software Engineer
AWS/Python Software Engineer

Citywire • Greater London

On-site
GBP 60,000 - 80,000
Generous holiday entitlement
Flexible working options
Annual well-being allowance
+5
Senior Data Engineer - Build Scalable Data Pipelines & AI
Senior Data Engineer - Build Scalable Data Pipelines & AI

Citywire GmbH • Greater London

Hybrid
GBP 90,000 - 130,000
25 days holiday
Flexible working
Well-being allowance
+8
Customer Success Manager
Customer Success Manager

Citywire • Greater London

Hybrid
GBP 50,000 - 70,000
Generous holiday entitlement (25-28-30
Flexible working options
Well-being activity allowance
+6
Senior Data Engineer
Senior Data Engineer

Optima Partners • Greater London

On-site
GBP 70,000 - 110,000
Competitive base salary
Annual discretionary bonus up to 15%
Up to 37 days holiday incl. personal &
+5
Client Account Manager
Client Account Manager

Citywire • Greater London

Hybrid
GBP 42,000 - 64,000
Generous holiday entitlement: 25 days+
Flexible working options
Well-being allowance
+5
Client Account Manager
Client Account Manager

Citywire Financial Publishers Ltd • London Borough of Lambeth

Hybrid
GBP 50,000 - 70,000
Generous holiday entitlement: 25 days+
Flexible working options
Well-being and gym benefit
+6
Commercial Product Executive
Commercial Product Executive

Citywire • Greater London

On-site
GBP 30,000 - 40,000
Generous holiday entitlement
Flexible working options
Annual well-being allowance
+4
Customer Success Manager Subscriptions · London ·
Customer Success Manager Subscriptions · London ·

Citywire • Greater London

Hybrid
GBP 50,000 - 85,000
Generous holiday entitlement: 25–30+
Flexible working options
Well-being allowance
+7
Senior Data Engineer
Senior Data Engineer

Moneybox • Greater London

Hybrid
GBP 90,000 - 120,000
Company bonus scheme
Company pension scheme
Hybrid working
+3