Skip to content
View juanmicl's full-sized avatar
📡
📡
130 followers · 39 following

Achievements

Achievement: Pull SharkAchievement: Arctic Code Vault ContributorAchievement: Starstruck

Achievements

Achievement: Pull SharkAchievement: Arctic Code Vault ContributorAchievement: Starstruck

Highlights

Block or report juanmicl

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.

Content in all repositories owned by your account will be closed.
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
juanmicl/README.md

Juan Miguel Contreras

Data engineer, 7+ years in. Most of my work is Python talking to PostgreSQL and TimescaleDB: pipelines that move tens of millions of rows a day, with statistical models sitting on top.

Day job: I lead data science in the public sphere, mostly election estimation with multilevel regression and poststratification (MRP) over large survey and unstructured opinion datasets. Everything else on this profile is side projects I build to learn: quant research, and spatial analytics over Spanish open data (Catastro, INE, MITMA).

I've also started contributing upstream: merged changes in taskiq and numba, a docs PR in pandas under review, and bug reports in pandas, pydantic and langgraph. The contribution graph below has the rest.

Projects

Repo Description
quant-market-data-forensics Point-in-time market data platform: bitemporal ingestion (Sharadar, FRED vintages), TimescaleDB, SQL feature factory, Numba kernels. Its data-quality instruments found 3 biases in the feed and killed the strategy built on it.
sqlpush prisma db push for SQLAlchemy: push, diff and check PostgreSQL/TimescaleDB schemas straight from your models. Risk-classified changes, CI exit codes, no migration files.
ine-api Python client for the Tempus API of the INE, the Spanish national statistics office.

Stack

Python PostgreSQL TimescaleDB pandas Numba SQLAlchemy

Elsewhere

Pinned Loading

  1. quant-market-data-forensics quant-market-data-forensics Public

    Quant market-data platform: point-in-time ingestion (Sharadar SF1/SF2/SF3/SEP, FRED vintages), TimescaleDB, pure-SQL feature factory, PCA (Higham PSD repair) + EWLS-ridge Numba kernels + Huber-WLS,…

    Python 6

  2. ine-api ine-api Public

    Cliente Python para la API Tempus del INE (Instituto Nacional de Estadística de España)

    Python 5

  3. sqlpush sqlpush Public

    Prisma db push for SQLAlchemy: push, diff and check PostgreSQL/TimescaleDB schema straight from your models (SQLAlchemy / SQLModel). Risk-classified, CI-ready, no migration files.

    Python 2

  4. tacet tacet Public

    Low-cost receive-only drone detection: RF signatures (ELRS, DJI O4), acoustic array and passive radar, fused with measured ROC curves. Python + SDR.

    Jupyter Notebook