Porfolio
Camille Lebrun
’m Camille Lebrun, an Analytics Engineer with over two years of experience transforming raw data into scalable and efficient models using tools like dbt, BigQuery, and Snowflake. I specialize in streamlining workflows, delivering actionable insights, and implementing best practices in data transformation and analytics. My work empowers organizations to make confident, data-driven decisions with reliable and maintainable solutions.
About me
I’m an experienced Analytics Engineer with over two years of expertise in designing scalable data models, ensuring data quality, and driving actionable insights. My core skills lie in tools like dbt and SQL, complemented by Python for advanced automation and data analysis.
Leveraging modern data stacks—including Google BigQuery, Snowflake, dbt, and Metabase—I deliver end-to-end data solutions. My work encompasses process automation, the development of scalable data workflows, and the creation of interactive dashboards using platforms like Tableau and Looker.
As a non-binary professional, I am dedicated to fostering diversity, equity, and inclusion in the tech industry. I believe that innovation thrives when diverse voices and perspectives come together to shape meaningful soutions.
Work experience
Analytics Engineer
Hanalytics, Paris, France
Soon
Analytics Engineer Apprentice
Lucky Cart, Paris, France
Nov.2023 - Dec.2024
I ensure data quality through audits and develop data applications to accelerate analysis.
I refactor data models for better performance and maintainability using dbt.
By simplifying complex data, I help stakeholders make informed, data-driven decisions.
Analytics Engineer Intern
My Job Glasses, Paris, France
June.2023 - Nov-2023
I create and maintain data models using dbt to meet diverse business needs, including automating data transformations with dbt macros.
I design data visualizations in Metabase for various teams and ensure precise version control with Git, including interactive rebasing.
Data Analyst Intern
Click & Boat, Paris, France
May.2022 - Oct-2022
I develop dbt models for data analysis and create Tableau dashboards for data visualization. I analyze audience behavior to understand user actions on the platform. I also support the marketing team by evaluating the impact of their campaigns.
Education
Mastere Data & AI
HETIC, Montreuil
2022 - 2024
MSc in Structural Functional Biochemistry
University Toulouse III Paul Sabatier, Toulouse
2018 - 2020
Skills
Explore the technical proficiencies that enable me to transform raw data into actionable insights.
dbt
Experienced in writing complex models, tests, and documentation to transform raw data into valuable insights through efficient data modeling.
Python
Proficient in developing data-driven applications and performing advanced data analysis using libraries such as Streamlit, Keras, TensorFlow, and Pandas.
SQL
Skilled in writing complex SQL queries, optimizing performance, and managing large datasets using BigQuery and Snowflake.
Docker
Proficient in writing Dockerfiles and docker-compose files, and containerizing applications for consistent environments across development and production.
Data Visualization
Experienced in using Matplotlib, Seaborn, Plotly, and tools like Tableau, Looker, and Metabase to create effective visualizations for communicating data insights.
Linux
Proficient in basic Linux commands and comfortable working in Linux environments for development and deployment purposes.
Git
Skilled in managing version control with GitHub, GitLab, and Bitbucket, ensuring smooth collaboration and precise versioning using techniques like interactive rebasing.
Data Analysis
Skilled in exploratory data analysis (EDA), data cleaning, and transformation using Python and SQL to derive meaningful insights from datasets.
Data Applications
Experienced in developing interactive data-driven applications and dashboards using Python and Streamlit to visualize data and provide actionable insights.
Explore my projects
Discover how I've leveraged my skills to create impactful data solutions.
At Lucky Cart
Refactoring of the data transformation repository
Description:
Refactored the data transformation repository to enhance performance and maintainability using dbt. Ensured the quality of SQL code with sqlfluff, maintaining best practices for data consistency and accuracy.
Role:
Optimized data models for better performance, reduced query times, and streamlined data workflows. Led initiatives to improve data transformation processes using dbt and automated quality checks to ensure robust, maintainable SQL code.
At Lucky Cart
Bug managment
Description
Collaborated across teams to address data discrepancies, providing immediate solutions and developing long-term strategies to ensure the stability of data pipelines. Promoted adherence to best practices throughout the process.
Role
Worked with teams to diagnose root causes of data issues, implementing quick fixes and sustainable solutions. Led initiatives to enhance data pipeline reliability through cross-team collaboration and best practice implementation.
TDoR
Transgender Day of Remembrance
Description:
Developed a data visualization application to display real-time data on TDoR (Transgender Day of Remembrance) victims. Leveraged the TransLivesMatter API to provide interactive exploration and automatic updates each year, ensuring accurate and reliable information from trusted sources.
Role:
Designed and implemented a Streamlit-based web app that visualizes real-time data. Integrated API connections for automatic yearly updates, requiring no technical intervention post-deployment. Ensured high-quality data representation that adheres to transgender rights protection standards.
Follow My Updates
Stay up to date with my latest articles and insights by subscribing to my RSS feed.