Skip to content
View chipap-dev's full-sized avatar

Block or report chipap-dev

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
chipap-dev/README.md
Claudia Cáceres — Analytics Engineer · Data Engineer

Website LinkedIn Email Buenos Aires, Argentina Open to remote

Analytics Engineer · Data Engineer, based in Buenos Aires.

I've worked with data since 2020, and for the last three years I've been building and operating internal platforms: dimensional modeling, ELT pipelines, and REST, SOAP and ODBC integrations between databases and external systems.

The projects below are my own. All of them run on a schedule, in production.

Projects

One Airflow deployment that runs the BigQuery and dbt pipelines of two production projects without holding any business logic of its own. Each project mounts as a volume and brings its own DAG and credentials, so adding one touches three files.

Airflow 3.3 (CeleryExecutor) PostgreSQL 16 Redis Docker Compose

Timetables for the Tigre Delta passenger boats live in PDFs from three different companies. This parses them with pdfplumber — by colour and row position, not plain text — and normalizes the three sources into one relational model in PostgreSQL. On BigQuery, a dbt star schema: four dimensions, one fact table at a grain of one row per timetable entry × route, 31 tests.

The parser is the fragile part, so it has its own suite in CI plus a weekly check against the live sources to catch format changes before they break the app.

Django pdfplumber PostgreSQL BigQuery dbt Airflow pytest Docker

Two official APIs publish tide height and weather for Argentine river stations, but only as a rolling snapshot — yesterday's readings are gone. A daily Airflow DAG loads them into BigQuery with an incremental MERGE, so history accumulates instead of being overwritten. dbt builds a staging model per source and a mart joining tide and weather by station, date and hour, with tests for freshness, duplicates and forecast staleness.

The dashboard doesn't read from the warehouse: it reads a local per-station JSON cache, so the page stays fast and keeps working if the pipeline is down.

Django BigQuery dbt Airflow Docker vanilla JS

Fret position calculator for string instruments, with 1:1 scale printable plans in PDF. No database — pure calculation, service layer kept out of the views.

Django ReportLab SVG

Stack

Python · SQL · dbt · BigQuery · PostgreSQL · SQL Server · Airflow · Django · Docker · pandas · Power BI

Contact

Open to remote data roles: analytics engineering, pipelines and orchestration, warehouse modeling, internal data platforms.

claudiacaceres.info@gmail.com · chipap.net · LinkedIn

Pinned Loading

  1. lanchas lanchas Public

    Tigre Delta boat timetables: government PDFs parsed with pdfplumber, normalized into PostgreSQL, modeled as a dbt star schema on BigQuery.

    Python 1

  2. mareas mareas Public

    Tide and weather dashboard for Argentine river stations, with an incremental MERGE into BigQuery and dbt models behind it.

    CSS 3

  3. airflow-orchestrator airflow-orchestrator Public

    A single Airflow deployment that runs other projects' BigQuery and dbt pipelines, with no business logic of its own.

    Python 1

  4. luthier luthier Public

    Fret position calculator for string instruments, with 1:1 scale printable PDF plans.

    CSS 2