Lead Data Architect

Project overview

Lead Data Architect

Project details

Paris, France - Hybrid

Contract: Freelance until 31 December 2026, with potential extension

ASAP

We are looking for a hands-on Lead Data Engineer to design and build a new data platform supporting website analytics and consumer engagement within a global consumer healthcare organisation.

This is a technically focused role combining data engineering, modelling and solution architecture, with the opportunity to use AI-assisted development tools to accelerate delivery. You will work closely with business stakeholders and a small delivery team to turn multiple data sources into a reliable, automated and well-governed data product.

Key Responsibilities

Required Experience

Desirable

This opportunity would suit a technically strong, autonomous engineer who enjoys building solutions from the ground up, combining architecture decisions with hands-on development and delivery.

If you have strong Databricks and dbt experience and are available for a new freelance assignment, we'd be keen to hear from you.

• Design and build data pipelines, models and semantic layers using Databricks and dbt.
• Integrate website and consumer engagement data from sources including GA4, SEO tools and server logs.
• Develop ETL/ELT processes, transformations and orchestration using Python, SQL and Apache Airflow.
• Define and document the target architecture, data models and integration approach.
• Establish data quality, testing, Git and CI/CD standards.
• Lead hands-on delivery while estimating resource requirements and coordinating a small team.
• Collaborate with business stakeholders to translate requirements into technical solutions.
• Implement monitoring, support processes and a sustainable operational model.
• Leverage AI-assisted coding tools, particularly GitHub Copilot, to improve engineering efficiency.
• 7+ years of experience in data engineering, modelling or a similar technical data role.
• Strong hands-on expertise in Databricks, dbt, SQL and Python.
• Experience with Apache Airflow, data pipelines, ETL/ELT and data integration.
• Experience designing and delivering a data platform or data mart end to end.
• Knowledge of historised data modelling, semantic layers and data governance.
• Familiarity with Git, CI/CD, automated testing and AI-assisted development.
• Ability to design and justify technical architecture while remaining hands-on with development.
• Strong stakeholder communication skills and experience working in Agile environments.
• Consumer healthcare, CPG or digital marketing data experience.
• Exposure to GA4, SEO analytics, Power BI or AI-search visibility.
• Experience with agentic AI workflows, RAG or AI-ready data infrastructure.
• French language skills.
• Start: flexible
• Duration: 4 months
• Remote: hybrid
• Location: Paris, France, FR
• Languages: French