Senior Data Engineer

About the company

Created in Lyon in 2016 by three French entrepreneurs, Agicap is one of Europe's fastest-growing scale-ups, with over 8,000 clients, 600 employees, and rapid revenue growth (multiplied by 7 between 2021 and 2024). Agicap is part of the French Tech 120, which rewards the most promising startups in France.

Agicap enables finance departments of mid-sized companies to effectively manage and forecast their cash flow, pay their suppliers, and get paid. By combining a cash management system with accounts payable and accounts receivable management solutions on a single platform, Agicap aims to become the new benchmark in cash management for mid-sized companies.

We have raised 145 million euros since our creation, from prestigious venture capital funds such as AVP, Greenoaks, Partech, and BlackFin, with a recent round in November 2024.

These additional resources further fuel our product innovation, allowing us to grow significantly and accelerate our international expansion across the world.

We are convinced that our success lies in our passionate and dedicated teams, committed to building a company where everyone can evolve and build their career. We are constantly looking for new talent, aiming for excellence and ready to join our ambitious adventure!

👥The team you are joining You will join a team of 3 Data Engineers who collaborate daily with 4 Data Analysts and Pauline (Head of Data). You will be in direct contact with Kévin (Team Lead Data Engineering) and Pauline on a daily basis. The Data team is attached to the Revenue & Operations department.

The team in 3 words: tight-knit, pragmatic, technically demanding. We handle many strategic topics in parallel — that's why we are looking for a senior who can quickly find their feet and bring weight to architecture decisions.

Your tasks

Do you want to work on a Data Platform that feeds an entire fintech scale-up — from Marketing to Product, including Finance, Customer Success, and sales — and which is today at the heart of our AI-first transition? Do you have the perspective to maintain production systems AND the energy to build the semantic layer that will connect our data to AI?

At Agicap, the Data Platform meets the analytics needs (reporting, AI) and data synchronization needs serving the entire company. It relies on Google Cloud Platform (notably BigQuery and Composer), Airbyte, dbt, and Looker to maintain and distribute up-to-date, consolidated, and reliable data. 🔥 The project that changes everything: opening access to corporate data via AI through our MCP Analytics server. We have already laid the first bricks with Looker Explores governed by DAs — the logical next step is the extension to BigQuery coupled with a semantic layer. And that is where you come in.

💪 Your missions You will alternate between demanding run and structuring projects:

• Maintain and ensure platform reliability: Composer (Airflow), Airbyte self-hosted on GKE, BigQuery, dbt, Terraform. A portion of your time will go to run (incident management, DA support), distributed within the DE team. You design and enrich tests, monitoring, and alerting — both technical and functional.
• Industrialize data ingestion: collect sources via Airbyte (API or CDC depending on the case), manage schema evolution and BigQuery external tables.
• Feed business tools: reverse-ETL and synchronizations between tools (HubSpot, Gainsight, Intercom…) or towards our PostgreSQL real-time database via our streaming architecture (webhooks → Pub/Sub → Cloud Run).
• Extend the AI access layer: extend MCP Analytics towards BigQuery, build the semantic layer that conditions the quality of AI responses. The quality of modeling determines the quality of responses.
• Master costs and security: BigQuery slot reservations in autoscaling, dynamic dbt build routing, monthly FinOps review, least privilege, management of personal and sensitive data, securing data access by AI.

Requirements

Essential

• Minimum 5 years of experience in Data Engineering on a major Cloud Provider, with the responsibility of maintaining systems in production.
• Advanced SQL + complex dbt models (incremental materialization, snapshots, macros) that you know how to debug (duplicates, late data, deletions, schema changes) and optimize (duration, cost).
• Solid experience in ingestion and pipeline orchestration: debugging, schema drift, recovery, backfill, impact analysis.
• High-quality Python, tested and mastered — maintainability and reliability at the heart of your practice.
• Infrastructure as Code and CI/CD on a daily basis.
• You work with a Coding Agent and you know how to take a step back to verify what it produces.
• You are proactive, rigorous, humble, and you love mentoring: sharing your discoveries, explaining your choices to both technical and business teams, helping your colleagues progress.
• You are comfortable in a partially full-remote team.
• English B2 minimum.

A big plus

• Experience with a semantic layer (dbt Semantic Layer / MetricFlow, LookML), on the GCP Knowledge Catalog (formerly Dataplex) or equivalent, or more broadly on data governance: cataloging, lineage, classification, policy tags, ownership.
• Processing in event-driven architecture and its specificities (Pub/Sub, Cloud Run, scaling, rejections, retries).

A plus

• GCP experience: BigQuery and its compute model via slot reservations, Composer, Cloud Run, GKE / Helm.
• You have built tools for AI agents (MCP server, skills).
• Integrations into business tools (HubSpot, Gainsight, Intercom).
• Data pipelines in Change Data Capture.
• Contribution to the Airbyte ecosystem.

What we offer

🎁 What we offer

• A role at the heart of an AI-first fintech scale-up FT120, €145M raised, 8,000+ clients, 6 countries.
• A Data Platform with a real strategic scope (reporting, AI, data governance) and fundamental topics for the next 2 years.
• Compensation: 60K€ - 70K€ depending on expertise + SYNTEC holiday bonus.
• CDI (permanent contract), 39h forfait including 4 hours of overtime paid.
• Full remote — occasional visits to Lyon for team moments.
• 25 days of paid leave + 10 days of flexible leave (usable upon arrival).
• Alan health insurance (family extension possible), Swile meal vouchers (€11/day including €6.50 covered).
• CSE benefits: annual KDO card, Gymlib / EGYM wellpass, and more.

How to apply

⏳ Recruitment process

1. Screening with our Senior Talent Acquisition — 45 min on your background and motivation.
2. 1st technical interview with Pauline (Head of Data) — technical discussion, challenge on how to approach problems, scoping of topics, Agicap use case — 1h.
3. 2nd technical interview with Kévin (Team Lead DE) and Julien — SQL test + oral architecture test + technical discussion + AI case — 2h.

Quick feedback at each step. Transparent process, no traps.

Other

👀 How we work

• Daily DE + weekly Data to share progress and unblock quickly.
• Co-constructed and documented architecture decisions, systematic code review, continuous improvement.
• Full remote for DEs — the team is distributed, we know how to work together remotely.
• One week per quarter in Lyon with the entire Data team for deep topics and human moments.
• AI is a daily work tool: Claude Code, repo-specific instructions, internal skills marketplace. Human review remains mandatory — we use AI with high standards.
• Open source contribution: we publish Airbyte connectors.

⭐ Our stack

• GCP: BigQuery, GCS, Pub/Sub, Cloud Run, Cloud SQL, Composer, GKE, Looker
• Ingestion: Airbyte self-hosted (CDC PostgreSQL and SQL Server), GCS Avro → BigQuery external tables
• Transformation & quality: dbt, Elementary
• IaC & CI/CD: Terraform, Cloud Build, GitHub Actions
• Languages: Python, SQL, Docker
• AI: Claude Code (internal skills and plugins), internal MCP server