Senior Data Engineer
Own Citywire’s data platform, build trusted Python and dbt pipelines, and mentor a close-knit team powering reporting and AI products.
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.
- Department
- Technology - Data
- Role
- Data Engineer
- Location
- London
About Citywire Financial Publishers Ltd
For 25 years we have built up the most complete picture of the decision-makers who drive the way the global wealth industry invests more than $90tn in assets.