dataforgoodfr/13_odis
Mar 2025 – Jun 2025
3 Months active
Languages Used
CSVJSONPythonJinjaSQLYAML
Technical Skills
Data AnalysisData EngineeringAWS S3Data ExtractionData ProcessingPandas
Kimberly Black
PROFILE
Kimberly Black
Kimberly Black developed and refined a social housing data pipeline for the dataforgoodfr/13_odis repository over three months, focusing on end-to-end extraction, transformation, and aggregation of government housing data. She engineered a Python-based ETL process using Pandas and SQL, automating the download, processing, and storage of regional datasets in AWS S3. Her work included designing reusable utilities, implementing commune-level aggregation, and introducing SQL macros and dbt models to standardize indicators across administrative levels. By aligning data flows from extraction to silver-layer modeling, Kimberly improved data quality, accessibility, and reporting accuracy, laying groundwork for scalable analytics and future gold-layer aggregation.
Overall Statistics
Feature vs Bugs
100%Features
Repository Contributions
4Total
Bugs
0
Commits
4
Features
3
Lines of code
18,211
Activity Months3
Your Network
18 peopleShared Repositories
18
Arthur HavlicekMember
kloudkraftsMember
apibracMember
antoningarMember
gustelleMember
HAMIDI AminMember
Henry D.Member
salma-hnanaMember
Jean-Baptiste-NMember
Work History
June 2025
2 Commits • 1 Features
Jun 1, 2025June 2025 monthly summary for dataforgoodfr/13_odis: Delivered a Bronze-to-Silver refactor of the Social Housing Data Pipeline with commune-level aggregation. Introduced new SQL macros and models to structure housing data across commune, department, region, and EPCI levels; prepared data for the gold layer by enabling downstream aggregation and data quality improvements; established a commune-level path to improve reporting accuracy. This work enhances data quality, accessibility, and reporting capabilities for social housing indicators and sets the foundation for faster analytics and scalable reporting.
2 Commits • 1 Features
Jun 1, 2025June 2025 monthly summary for dataforgoodfr/13_odis: Delivered a Bronze-to-Silver refactor of the Social Housing Data Pipeline with commune-level aggregation. Introduced new SQL macros and models to structure housing data across commune, department, region, and EPCI levels; prepared data for the gold layer by enabling downstream aggregation and data quality improvements; established a commune-level path to improve reporting accuracy. This work enhances data quality, accessibility, and reporting capabilities for social housing indicators and sets the foundation for faster analytics and scalable reporting.
June 2025
April 2025
1 Commits • 1 Features
Apr 1, 2025April 2025 monthly performance summary for dataforgoodfr/13_odis: Delivered an end-to-end Social Housing Data Extraction Notebook and S3 upload pipeline, enabling automated collection, transformation, and storage of housing data from government sources. Emphasis on end-to-end ETL, documentation, and readiness for analytics.
April 2025
1 Commits • 1 Features
Apr 1, 2025April 2025 monthly performance summary for dataforgoodfr/13_odis: Delivered an end-to-end Social Housing Data Extraction Notebook and S3 upload pipeline, enabling automated collection, transformation, and storage of housing data from government sources. Emphasis on end-to-end ETL, documentation, and readiness for analytics.
March 2025
1 Commits • 1 Features
Mar 1, 2025March 2025 monthly summary for dataforgoodfr/13_odis: Delivered a new data extraction capability for social housing analytics to enable regional and municipal analysis via a dedicated CSV.
1 Commits • 1 Features
Mar 1, 2025March 2025 monthly summary for dataforgoodfr/13_odis: Delivered a new data extraction capability for social housing analytics to enable regional and municipal analysis via a dedicated CSV.
March 2025
Activity
Loading activity data...
Quality Metrics
Correctness90.0%
Maintainability87.6%
Architecture87.6%
Performance80.0%
AI Usage20.0%
Skills & Technologies
Programming Languages
CSVJSONJinjaPythonSQLYAML
Technical Skills
AWS S3Data AnalysisData EngineeringData ExtractionData ModelingData ProcessingPandasPython ScriptingSQLdbt
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline