Freelancer profile translated to English.

Description

Cloud Data Engineer DBT

Reliable and consistent data is crucial for decision-making, and I help data teams strengthen their BI data with tools like DBT.

I can work on data modeling projects in any type of database (data warehouse, non-relational database, etc.) as well as migrations to a new dbt architecture (if you have a project to implement dbt in your company to modernize your data stack and are looking for someone who can not only deploy a project but also establish solid foundations that will last for years).

With 3 years of experience in dbt-core, where I was responsible for deploying a dbt project on GCP, I will bring my expertise to define your needs and implement your new architecture, as well as automate your data pipelines.

Missions related to dbt:

Experience as a technical lead in dbt / Airflow migration with astromer-cosmos
Experience as a technical lead in deploying a dbt project (CI/CD, Docker, Airflow)
Solid experience with dbt-bigquery
Significant experience with dbt-databricks and dbt-trino
Knowledge of dbt Cloud (collaboration with dbt Labs teams on a dbt core vs dbt Cloud POC at France Télévisions)
Real mastery of advanced dbt (incremental dbt, dbt artifact, dbt_project_evaluator, macros, dbt-dry-run...)
Data modeling via dbt models
Implementation of dbt docs for business data lineage
Implementation of dbt test to ensure data quality

Other common missions:

Creating tables with advanced SQL queries
Implementing ETL data pipelines via Python scripts
Deploying Cloud resources via Terraform
Rights management
Cost optimization

Languages

French
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

France Télévisions
Data Engineer
FILM AND AV
June 2023 - June 2026 (3 years)
Paris, France
In a desire to harmonize its steering tools, France Télévisions created a dedicated Steering Domain team for providing BI data through a dedicated "Data4All" environment on Google Cloud Platform, useful for all its dashboards. This team is composed of a Product Owner, a Data Steward, and a Data Engineer.

Important Projects:
Technical lead responsible for choosing the dbt project architecture according to performance constraints and business teams' data usage, as well as deploying GCP resources in dev and prod environments via Terraform. I also provided my expertise in implementing data quality tests (dbt test) and making the dbt project documentation available (dbt docs | App Engine | IAM | Terraform)
Technical lead during the POC and then the deployment of Airflow and astronomer-cosmos in GCP via Cloud Composer (dbt, astronomer-cosmos, CICD, Cloud Composer, Secret Manager, IAM, Cloud Storage, Terraform)
=> Reduction of costs by more than 40% and reduction of time spent on daily runs to restart dbt models that failed during processing.

Missions:
Transform and enrich data from the Lakehouse to create reliable insights usable by business teams (CRM, france.tv partners, etc.) and data analysts in PowerBI using the dbt tool
Implement raw data export pipelines to a GCS bucket for France.tv partners (arte, LCP, etc.) via Python scripts
Industrialize and orchestrate the update of tables and views in Bigquery (CI/CD|Airflow|dbt|Astronomer|Cloud run)
Secure access to the GCP project data
Active participation in agile ceremonies (Retro, Review, Grooming, and Daily meetings).
Collaboration with Data Governance in integrating dbt documentation with the Collibra tool
DBT Astronomer Apache Airflow Gitlab CI/CD Google cloud
Agorapulse
Data Engineer - Marketing
SOCIAL NETWORKS
September 2021 - December 2022 (1 year and 3 months)
Paris, France
Missions:
Design and automate the integration of application user information into the Hubspot CRM and Bigquery data warehouse (Segment | batch API | Python | SQL | ETL/ELT | Webhook | Bigquery)
Implement Airflow DAGs to transform data stored in Bigquery
Import transformed data into Looker Studio dashboards and Google Sheets files (Cloud Storage | Airflow | Segment | Github | Batch API | Python | AWS Lambda)
Monitor data quality performance indicators Understand business issues and implement actions for satisfactory results as quickly as possible
Google cloud SQL Python ETL Airflow
Dataneo
Data Engineer - Marketing
AUTOMOBILE
October 2020 - August 2021 (10 months)
Suresnes, France
Projects: Automation of all B2B campaign processing programs (SQL and Python programming languages) Update of Tableau databases for our clients (Mitsubishi, Mercedes, etc.) Other missions: Development of management rules to ensure the reliability of our database data. Agile SCRUM methodology
SQL scripting-automation Agile methodology Python