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
Worked on the dataforgoodfr/13_odis repository to deliver a social housing data pipeline supporting regional and municipal analytics. Developed end-to-end data extraction and transformation workflows using Python, SQL, and dbt, including a notebook to automate downloading, processing, and uploading government housing data to AWS S3. Refactored the pipeline from bronze to silver layers, introducing SQL macros and data models for standardized aggregation at commune, department, region, and EPCI levels. Focused on data quality, accessibility, and traceability, with clear documentation and reusable ETL utilities. The work established a foundation for scalable reporting and faster analytics on social housing indicators.
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