Temporary GCP Data Engineer

Temporary GCP Data Engineer (contract with unknown length and pay rate). Key skills:
Big Query, Python, SQL, data modeling, pipeline development.

Who are we? 👋 Look at the latest headlines and you will see something Ki insures. Think space shuttles, world tours, wind farms, and even footballers' legs. Ki's mission is simple:
Digitally transform and revolutionise a 335‑year‑old market. Working with Google and UCL, Ki has created a platform that uses algorithms, machine learning and large language models to give insurance brokers quotes in seconds, rather than days. Ki is proudly the biggest global algorithmic insurance carrier, the fastest‑growing syndicate in the Lloyd's of London market, and the first ever to make $100m in profit in three years.

Ki’s teams have varied backgrounds and work together in an agile, cross‑functional way to build the very best experience for its customers. Ki has big ambitions but needs more excellent minds to challenge the status‑quo and help it reach new horizons.

While our broker platform is the core technology crucial to Ki’s success, this role will focus on supporting the middle/back‑office operations that will lay the foundations for further and sustained success. We are a multi‑disciplined team with expertise in software and data engineering, full‑stack development, platform operations, algorithm research, and data science. Our squads focus on delivering high‑impact solutions – we favour a highly iterative, analytical approach.

You will be designing and developing complex data processing modules and reporting using Big Query and Tableau. In addition, you will also work closely with the Ki Infrastructure/Platform Team, responsible for architecting and operating the core of the Ki Data Analytics platform.

• Work with business teams (finance and actuary initially), data scientists and engineers to design, build, optimise and maintain production‑grade data pipelines and reporting from an internal Data warehouse solution, based on GCP/Big Query.
• Work with finance, actuaries, data scientists and engineers to understand how we can make best use of new internal and external data sources.
• Work with our delivery partners at EY/IBM to ensure the robustness of design and engineering of the data model/MI and reporting, which can support our ambitions for growth and scale.
• BAU ownership of data models, reporting and integrations/pipelines.
• Create frameworks, infrastructure and systems to manage and govern Ki's data assets.
• Produce detailed documentation to allow ongoing BAU support and maintenance of data structures, schema, reporting, etc.
• Work with the broader Engineering community to develop our data and MLOps capability infrastructure.
• Ensure data quality, governance, and compliance with internal and external standards.
• Monitor and troubleshoot data pipeline issues, ensuring reliability and accuracy.

• Experience designing data models and developing industrialised data pipelines.
• Strong knowledge of database and data lake systems.
• Hands‑on experience in Big Query, dbt, GCP cloud storage.
• Proficient in Python, SQL and Terraform.
• Knowledge of Cloud SQL, Airbyte, Dagster.
• Comfortable with shell scripting with Bash or similar.
• Experience provisioning new infrastructure in a leading cloud provider, preferably GCP.
• Proficient with Tableau Cloud for data visualization and reporting.
• Experience creating Data Ops pipelines.
• Comfortable working in an Agile environment, actively participating in approaches such as Scrum or Kanban.