MTES-MCT/zero-logement-vacant
Nov 2024 – May 2026
18 Months active
Languages Used
JinjaSQLDockerfileGitJSONJupyter NotebookPythonShell
Technical Skills
DBTData EngineeringSQLData WarehousingDatabase ManagementETL
Raphaël Courivaud
PROFILE
Raphaël Courivaud
Over 18 months, contributed to the MTES-MCT/zero-logement-vacant repository by designing and evolving a robust data analytics platform for housing vacancy analysis. Developed scalable ETL pipelines and data models using Python, SQL, and dbt, integrating external data sources and automating ingestion with Dagster. Enhanced data quality through validation, deduplication, and address normalization, while supporting advanced analytics and machine learning workflows in Streamlit and Metabase. Improved deployment reliability with Docker and CI/CD, enabling rapid iteration and production readiness. The work emphasized maintainability, test coverage, and documentation, resulting in a flexible, production-grade analytics stack supporting business intelligence and data-driven decision making.
Overall Statistics
Feature vs Bugs
75%Features
Repository Contributions
199Total
Bugs
24
Commits
199
Features
71
Lines of code
1,330,871
Activity Months18
Your Network
10 peopleShared Repositories
10
Andrea GueugnautMember
Loïc GuilloisMember
Guillaume ClaverieMember
JuGuuuMember
Loïc GuilloisMember
JouinMember
NicolasMember
NicolasMember
snyk-botMember
Work History
May 2026
15 Commits • 4 Features
May 1, 2026Monthly summary for MTES-MCT/zero-logement-vacant (May 2026). Focused on delivering business value through robust data pipeline tooling, increased PM autonomy, and fortified CI/test infrastructure. Highlights features delivered, major fixes, impact, and technologies demonstrated for performance reviews.
15 Commits • 4 Features
May 1, 2026Monthly summary for MTES-MCT/zero-logement-vacant (May 2026). Focused on delivering business value through robust data pipeline tooling, increased PM autonomy, and fortified CI/test infrastructure. Highlights features delivered, major fixes, impact, and technologies demonstrated for performance reviews.
May 2026
April 2026
23 Commits • 16 Features
Apr 1, 2026For 2026-04, delivered a scalable owner matching and zlovac generation pipeline for MTES-MCT/zero-logement-vacant, with substantial data quality, performance, and analytics improvements across the FF25/FF2025 lineage. Implemented end-to-end features in the dbt + Dagster stack, hardened matching under memory constraints, and introduced richer ownership linkage to enable accurate housing-to-owner attribution and downstream business reporting.
April 2026
23 Commits • 16 Features
Apr 1, 2026For 2026-04, delivered a scalable owner matching and zlovac generation pipeline for MTES-MCT/zero-logement-vacant, with substantial data quality, performance, and analytics improvements across the FF25/FF2025 lineage. Implemented end-to-end features in the dbt + Dagster stack, hardened matching under memory constraints, and introduced richer ownership linkage to enable accurate housing-to-owner attribution and downstream business reporting.
March 2026
7 Commits • 3 Features
Mar 1, 2026March 2026 Monthly Summary — MTES-MCT/zero-logement-vacant Key features delivered: - Metabase and DuckDB upgrade across deployments to enhance analytics performance, compatibility, and data processing. Work included version stabilization around Metabase 0.59 with Dockerfile updates and related build adjustments (commit sequence: update metabase building; upgrade metabase md driver; downgrade; restore 0.59). - ZLV analytics improvements and data quality: refined SQL queries and usage patterns to improve accuracy of housing vacancy analytics and ensure reliable ZLV data retrieval. - Housing document events data model and analytics: introduced a dedicated housing_document_events table with a join table; added Dagster ingestion, dbt source, and staging models to support improved document statistics analytics. Major bugs fixed: - Corrected ZLV analytics usages (fix establishment zlv usages) to ensure accurate vacancy factor analysis. - Fixed document statistics pipeline by using the housing_document_events join table instead of a previously misused CTE; added robust ingestion/staging paths (Dagster, dbt) for the new table. Overall impact and accomplishments: - Significantly improved data reliability and speed of analytics for housing vacancy metrics and document statistics. - Strengthened data pipelines with a dedicated data model for housing documents, reducing query complexity and improving maintainability. - Delivered a more resilient analytics stack that supports faster, more accurate decision-making for business stakeholders. Technologies and skills demonstrated: - Data stack: Metabase, DuckDB, Docker, SQL - Data modeling and ingestion: housing_document_events, join tables, dbt, Dagster - Pipeline reliability: robust ingestion workflows, version control discipline, and change management
7 Commits • 3 Features
Mar 1, 2026March 2026 Monthly Summary — MTES-MCT/zero-logement-vacant Key features delivered: - Metabase and DuckDB upgrade across deployments to enhance analytics performance, compatibility, and data processing. Work included version stabilization around Metabase 0.59 with Dockerfile updates and related build adjustments (commit sequence: update metabase building; upgrade metabase md driver; downgrade; restore 0.59). - ZLV analytics improvements and data quality: refined SQL queries and usage patterns to improve accuracy of housing vacancy analytics and ensure reliable ZLV data retrieval. - Housing document events data model and analytics: introduced a dedicated housing_document_events table with a join table; added Dagster ingestion, dbt source, and staging models to support improved document statistics analytics. Major bugs fixed: - Corrected ZLV analytics usages (fix establishment zlv usages) to ensure accurate vacancy factor analysis. - Fixed document statistics pipeline by using the housing_document_events join table instead of a previously misused CTE; added robust ingestion/staging paths (Dagster, dbt) for the new table. Overall impact and accomplishments: - Significantly improved data reliability and speed of analytics for housing vacancy metrics and document statistics. - Strengthened data pipelines with a dedicated data model for housing documents, reducing query complexity and improving maintainability. - Delivered a more resilient analytics stack that supports faster, more accurate decision-making for business stakeholders. Technologies and skills demonstrated: - Data stack: Metabase, DuckDB, Docker, SQL - Data modeling and ingestion: housing_document_events, join tables, dbt, Dagster - Pipeline reliability: robust ingestion workflows, version control discipline, and change management
March 2026
February 2026
10 Commits • 2 Features
Feb 1, 2026February 2026 Monthly Summary – MTES-MCT/zero-logement-vacant
February 2026
10 Commits • 2 Features
Feb 1, 2026February 2026 Monthly Summary – MTES-MCT/zero-logement-vacant
January 2026
3 Commits • 2 Features
Jan 1, 2026January 2026 monthly summary for MTES-MCT/zero-logement-vacant: Focused on delivering two key features and validating deployment workflows. Major bugs fixed: none reported this month. Overall impact: produced production-ready analytics tooling to explore community indicators and exit rates, improved housing vacancy exploration and ML training capabilities, and established cloud deployment workflow for faster iterations. Technologies demonstrated: Streamlit, data exploration, data visualization, ML training, Python, code refactoring, deployment to Clever Cloud, Git-based version control.
3 Commits • 2 Features
Jan 1, 2026January 2026 monthly summary for MTES-MCT/zero-logement-vacant: Focused on delivering two key features and validating deployment workflows. Major bugs fixed: none reported this month. Overall impact: produced production-ready analytics tooling to explore community indicators and exit rates, improved housing vacancy exploration and ML training capabilities, and established cloud deployment workflow for faster iterations. Technologies demonstrated: Streamlit, data exploration, data visualization, ML training, Python, code refactoring, deployment to Clever Cloud, Git-based version control.
January 2026
December 2025
10 Commits • 4 Features
Dec 1, 2025December 2025 monthly summary for MTES-MCT/zero-logement-vacant focused on delivering robust data ingestion, analytics improvements, and more accurate entity lookups. The work hardened the data pipeline, improved data quality, and expanded geographic/demographic context for housing vacancy analyses.
December 2025
10 Commits • 4 Features
Dec 1, 2025December 2025 monthly summary for MTES-MCT/zero-logement-vacant focused on delivering robust data ingestion, analytics improvements, and more accurate entity lookups. The work hardened the data pipeline, improved data quality, and expanded geographic/demographic context for housing vacancy analyses.
November 2025
9 Commits • 1 Features
Nov 1, 2025November 2025 performance summary for MTES-MCT/zero-logement-vacant: Delivered a scalable external data ingestion framework and owner events analytics, enabling direct loading of external sources into DuckDB/MotherDuck, centralized configuration for public data providers, and standardized asset naming for analytics (dbt owner_events). Implemented a robust external pipeline to build external sources and refreshed dbt schemas. Stabilized pipelines with infrastructure and environment improvements across Dagster and Metabase Docker images, including Python 3.12 upgrades and necessary build dependencies. These efforts improved data reliability, scalability, and timeliness of owner-related analytics, reducing operational risk and enabling faster, data-driven decisions. Technologies demonstrated: DuckDB/MotherDuck, dbt, Dagster, Docker, Python 3.12, ETL architecture and data modeling.
9 Commits • 1 Features
Nov 1, 2025November 2025 performance summary for MTES-MCT/zero-logement-vacant: Delivered a scalable external data ingestion framework and owner events analytics, enabling direct loading of external sources into DuckDB/MotherDuck, centralized configuration for public data providers, and standardized asset naming for analytics (dbt owner_events). Implemented a robust external pipeline to build external sources and refreshed dbt schemas. Stabilized pipelines with infrastructure and environment improvements across Dagster and Metabase Docker images, including Python 3.12 upgrades and necessary build dependencies. These efforts improved data reliability, scalability, and timeliness of owner-related analytics, reducing operational risk and enabling faster, data-driven decisions. Technologies demonstrated: DuckDB/MotherDuck, dbt, Dagster, Docker, Python 3.12, ETL architecture and data modeling.
November 2025
October 2025
6 Commits • 4 Features
Oct 1, 2025Monthly summary for 2025-10: Delivered foundational data platform improvements for MTES-MCT/zero-logement-vacant, focusing on production reliability, developer ergonomics, and expanded analytics capabilities. Key features delivered include: - Dagster development environment and dependency updates to streamline local setup and avoid installation issues; - Added marts_productions_events table to enhance event tracking and data warehousing; - Simplified marts_production_events data model by removing joins to marts_production_join_owner_housing and owner_id casting; relying on a direct join with marts_production_users to reduce complexity; - Consolidated ff and lovac schemas into a single cerema schema to simplify ingestion and maintenance; - Production data tests validation improvements to ensure reliability in production. Major bug fixes include: - Production housing analytics tests corrected by fixing dbt schema test configuration and renaming tests to data_tests, with refined accepted values and relationships to prevent production failures. This reduced false positives and improved data quality in production.
October 2025
6 Commits • 4 Features
Oct 1, 2025Monthly summary for 2025-10: Delivered foundational data platform improvements for MTES-MCT/zero-logement-vacant, focusing on production reliability, developer ergonomics, and expanded analytics capabilities. Key features delivered include: - Dagster development environment and dependency updates to streamline local setup and avoid installation issues; - Added marts_productions_events table to enhance event tracking and data warehousing; - Simplified marts_production_events data model by removing joins to marts_production_join_owner_housing and owner_id casting; relying on a direct join with marts_production_users to reduce complexity; - Consolidated ff and lovac schemas into a single cerema schema to simplify ingestion and maintenance; - Production data tests validation improvements to ensure reliability in production. Major bug fixes include: - Production housing analytics tests corrected by fixing dbt schema test configuration and renaming tests to data_tests, with refined accepted values and relationships to prevent production failures. This reduced false positives and improved data quality in production.
September 2025
8 Commits • 3 Features
Sep 1, 2025September 2025 summary for MTES-MCT/zero-logement-vacant: Delivered three core items that improve data analytics, data fidelity, and deployment reliability. Implemented Housing Vacancy Analytics with NLP-enabled data processing and anonymization tooling, including a fix to campaign return-rate reporting. Added Production Events Mart with owner/IDs to improve event data provenance and consistency. Modernized Dagster environment and Docker tooling with pyproject.toml and uv.lock, and hardened Dockerfile practices to ensure reliable dependency installation and builds.
8 Commits • 3 Features
Sep 1, 2025September 2025 summary for MTES-MCT/zero-logement-vacant: Delivered three core items that improve data analytics, data fidelity, and deployment reliability. Implemented Housing Vacancy Analytics with NLP-enabled data processing and anonymization tooling, including a fix to campaign return-rate reporting. Added Production Events Mart with owner/IDs to improve event data provenance and consistency. Modernized Dagster environment and Docker tooling with pyproject.toml and uv.lock, and hardened Dockerfile practices to ensure reliable dependency installation and builds.
September 2025
August 2025
5 Commits • 3 Features
Aug 1, 2025Monthly summary for 2025-08: Focused on expanding analytics capabilities and data model clarity for MTES-MCT/zero-logement-vacant. Implemented notes data ingestion, launched a comprehensive vacancy exit analytics suite, and improved data models documentation. The changes strengthen production analytics pipelines, governance, and usability of data products. No major bugs fixed this month; improvements were delivered with updated documentation and configuration to support scalable analytics pipelines.
August 2025
5 Commits • 3 Features
Aug 1, 2025Monthly summary for 2025-08: Focused on expanding analytics capabilities and data model clarity for MTES-MCT/zero-logement-vacant. Implemented notes data ingestion, launched a comprehensive vacancy exit analytics suite, and improved data models documentation. The changes strengthen production analytics pipelines, governance, and usability of data products. No major bugs fixed this month; improvements were delivered with updated documentation and configuration to support scalable analytics pipelines.
July 2025
6 Commits • 3 Features
Jul 1, 2025In July 2025, MTES-MCT/zero-logement-vacant delivered four core outcomes that enhance data quality, analytics consistency, and the robustness of the analytics stack. Key features and fixes improved data accuracy and insight depth, while a modernization of the analytics environment streamlines maintenance and delivery of business insights.
6 Commits • 3 Features
Jul 1, 2025In July 2025, MTES-MCT/zero-logement-vacant delivered four core outcomes that enhance data quality, analytics consistency, and the robustness of the analytics stack. Key features and fixes improved data accuracy and insight depth, while a modernization of the analytics environment streamlines maintenance and delivery of business insights.
July 2025
June 2025
7 Commits • 1 Features
Jun 1, 2025June 2025: Delivered batch BAN addresses population and analytics integration for MTES-MCT/zero-logement-vacant. Implemented batch processing to update BAN addresses and auto-populate missing owner addresses; added a Dagster asset and job for missing BAN addresses; integrated analytics imports, and improved logging. This work enhances data completeness, analytics readiness, and observability, enabling faster business decisions around vacant housing data. Minor workflow refinements included removing ban score validation and updating the job name to reflect updated scope. Commit surface includes: 4e5664a90f8b57a8f16956caff4d20e5df53ed60; 93d16aee9b253eccfd10e9604b44de223231c1c2; 231c41145a7824da97124f5dbd522c88c91d3305; 85c0800082d686e4e32f3b0003e485af885286ac; 6cb165ead47cc9dda04c5ec0ae24783a29966f11; 0c59b6187ee881d49eae794b47065130518b2d39; 4ed0218627ecf148cd757be673c07b2c7da2bc13.
June 2025
7 Commits • 1 Features
Jun 1, 2025June 2025: Delivered batch BAN addresses population and analytics integration for MTES-MCT/zero-logement-vacant. Implemented batch processing to update BAN addresses and auto-populate missing owner addresses; added a Dagster asset and job for missing BAN addresses; integrated analytics imports, and improved logging. This work enhances data completeness, analytics readiness, and observability, enabling faster business decisions around vacant housing data. Minor workflow refinements included removing ban score validation and updating the job name to reflect updated scope. Commit surface includes: 4e5664a90f8b57a8f16956caff4d20e5df53ed60; 93d16aee9b253eccfd10e9604b44de223231c1c2; 231c41145a7824da97124f5dbd522c88c91d3305; 85c0800082d686e4e32f3b0003e485af885286ac; 6cb165ead47cc9dda04c5ec0ae24783a29966f11; 0c59b6187ee881d49eae794b47065130518b2d39; 4ed0218627ecf148cd757be673c07b2c7da2bc13.
May 2025
13 Commits • 2 Features
May 1, 2025May 2025 performance summary for MTES-MCT/zero-logement-vacant. Delivered major data ingestion enhancements and naming consistency that tightened the analytics pipeline, improved data quality, and accelerated time-to-insight. Key features were designed with 2025 readiness in mind and focused on simplifying the data processing stack for maintainability and scalability.
13 Commits • 2 Features
May 1, 2025May 2025 performance summary for MTES-MCT/zero-logement-vacant. Delivered major data ingestion enhancements and naming consistency that tightened the analytics pipeline, improved data quality, and accelerated time-to-insight. Key features were designed with 2025 readiness in mind and focused on simplifying the data processing stack for maintainability and scalability.
May 2025
March 2025
17 Commits • 4 Features
Mar 1, 2025March 2025 monthly summary for MTES-MCT/zero-logement-vacant focusing on delivering analytics features, robust ingestion, and deployment improvements. Key outcomes include expanded establishment data classifications, 2024 FF ingestion pipelines, Metabase/DuckDB reliability enhancements, data quality analytics capabilities, and cleanup of legacy notebooks. These efforts have driven deeper insights, more reliable dashboards, and streamlined data ops for the business.
March 2025
17 Commits • 4 Features
Mar 1, 2025March 2025 monthly summary for MTES-MCT/zero-logement-vacant focusing on delivering analytics features, robust ingestion, and deployment improvements. Key outcomes include expanded establishment data classifications, 2024 FF ingestion pipelines, Metabase/DuckDB reliability enhancements, data quality analytics capabilities, and cleanup of legacy notebooks. These efforts have driven deeper insights, more reliable dashboards, and streamlined data ops for the business.
February 2025
20 Commits • 3 Features
Feb 1, 2025February 2025 monthly summary for MTES-MCT/zero-logement-vacant: Delivered foundational data-geography enhancements and hardened deployment to support more reliable analytics and faster iteration cycles. The month focused on delivering key features, fixing critical infrastructure issues, and elevating data quality for public mart analytics and housing metrics.
20 Commits • 3 Features
Feb 1, 2025February 2025 monthly summary for MTES-MCT/zero-logement-vacant: Delivered foundational data-geography enhancements and hardened deployment to support more reliable analytics and faster iteration cycles. The month focused on delivering key features, fixing critical infrastructure issues, and elevating data quality for public mart analytics and housing metrics.
February 2025
January 2025
38 Commits • 14 Features
Jan 1, 2025January 2025 focused on stabilizing the data platform and delivering production-ready analytics capabilities for MTES-MCT/zero-logement-vacant. Key outcomes include establishing DWH synchronization, deploying Dagster and Metabase to the main environment, and expanding DuckDB/MotherDuck data ingestion. Substantial bug fixes improved container orchestration and reliability (Dagster port and Docker fixes), while security hardening and governance updates reduced risk. The month also delivered enhanced export and DBT workflows, setting the stage for scalable, observable analytics and faster business insights.
January 2025
38 Commits • 14 Features
Jan 1, 2025January 2025 focused on stabilizing the data platform and delivering production-ready analytics capabilities for MTES-MCT/zero-logement-vacant. Key outcomes include establishing DWH synchronization, deploying Dagster and Metabase to the main environment, and expanding DuckDB/MotherDuck data ingestion. Substantial bug fixes improved container orchestration and reliability (Dagster port and Docker fixes), while security hardening and governance updates reduced risk. The month also delivered enhanced export and DBT workflows, setting the stage for scalable, observable analytics and faster business insights.
December 2024
1 Commits • 1 Features
Dec 1, 2024December 2024 monthly summary for MTES-MCT/zero-logement-vacant. Focused on delivering data infrastructure enhancements to support housing vacancy analytics. Key work centered on establishing event status tracking and consolidating housing data, with refactoring of analytics queries to improve data processing and reporting latency.
1 Commits • 1 Features
Dec 1, 2024December 2024 monthly summary for MTES-MCT/zero-logement-vacant. Focused on delivering data infrastructure enhancements to support housing vacancy analytics. Key work centered on establishing event status tracking and consolidating housing data, with refactoring of analytics queries to improve data processing and reporting latency.
December 2024
November 2024
1 Commits • 1 Features
Nov 1, 2024November 2024 performance summary for MTES-MCT/zero-logement-vacant focused on delivering a major enhancement to housing occupancy and vacancy analytics and strengthening the data pipeline for cross-year analysis.
November 2024
1 Commits • 1 Features
Nov 1, 2024November 2024 performance summary for MTES-MCT/zero-logement-vacant focused on delivering a major enhancement to housing occupancy and vacancy analytics and strengthening the data pipeline for cross-year analysis.
Activity
Loading activity data...
Quality Metrics
Correctness88.8%
Maintainability88.2%
Architecture85.0%
Performance82.0%
AI Usage22.4%
Skills & Technologies
Programming Languages
BashCSVDockerfileGitJSONJavaJavaScriptJinjaJupyter NotebookMarkdown
Technical Skills
API IntegrationAPI integrationAWSAuthenticationBackend DevelopmentBuild OptimizationBusiness IntelligenceCI/CDCloud Data WarehousingCloud DeploymentCloud InfrastructureCloud StorageCode CleanupConfiguration ManagementContainerization
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline