Data Engineer & BI Tech Lead
In charge of the data warehouse, integrations, CRM and internal processes (intranet), leading a team of 5: 2 developers, 1 senior developer, 1 senior data analyst and 1 HubSpot administrator.
- AI assistant over the data warehouse: answers business questions in natural language with real data. It generates SQL with Gemini from a catalog built from Postgres metadata, runs the query and proposes charts automatically.
- Corporate intranet (Flask API + Next.js): creator and platform administrator. I coordinate 2 developers and 1 senior developer who build the tools, review and approve their changes, and maintain the core (multi-tenant access model, CI/CD and infrastructure). Built my own tools such as Compliance (AFIP F8126 pipeline, RI-TII dashboard).
- Design, build and operate the company data warehouse on PostgreSQL (AWS RDS) as sole owner: Python ETLs integrating 11 source systems.
- Implemented HubSpot CRM across the company and integrated it with the DWH through its API (deals, companies, contacts, tickets, line items and associations).
- Migrated legacy Pentaho jobs and MySQL to Python + PostgreSQL, using a dual-write transition followed by decommissioning of the old platform.
- SFTP and Google Sheets integrations; Playwright scrapers for backoffices without an API, including OTP-by-email login.
- Automated regulatory reporting (AFIP F8126 / F8125, withholding tax returns) and automated PDF quote generation from HubSpot.
- Infrastructure: configured and administer Linux servers, nginx and filesystem; Docker; CI/CD with GitHub Actions (self-hosted runner); connection health monitoring.
- Data quality, reconciliation, documented data catalog (column comments, read-only BI roles) and Power BI dashboards.