# John Smallpage

John Smallpage is a remote worker on Himalayas, Data & Analytics Analyst at Farmatodo, based in Venezuela.

Source: https://himalayas.app/@johnsmallpage

```text
Data & Analytics Analyst at Farmatodo, designing Databricks lakehouse models for 300+ business users across three countries.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Venezuela |
| Authorized to work in | Venezuela |
| Salary expectations | 80k+ USD |
| Job categories | Data Engineer, Data Analyst |
| Skills | Data Engineering, ETL ELT, Databricks, Lakehouse Architecture, SQL, PySpark, Dimensional Modeling, Semantic Layer Design, Data Quality, Data Pipeline Monitoring, Delta Lake, Lakeflow Spark Declarative Pipelines, Dbt Cloud, Databricks Jobs, Data Vault |

## About

```text
At Farmatodo, I design ETL/ELT pipelines and Databricks lakehouse models that support self-service BI for around 300 business users across three countries. I modeled and documented dimension tables, fact tables, and materialized views, and helped cut cloud costs by roughly US$20,000 per year.

At ETA Orionis, I developed a Business Intelligence web application for investigating irregular merchant behavior and helping prevent money laundering. I designed three data marts, built FastAPI REST APIs for investigator-defined detection rules, and automated seven manual form-filling workflows.
```

## Experience

### Data & Analytics Analyst (current)

Farmatodo. Aug 2024 - Present

```text
Re-engineered the board-level Daily Sales Report from legacy Excel VBA macros to Python, cutting generation time from roughly 20 to 3 minutes per country and currency. Developed semantic layers in Databricks that brought self-service BI to around 300 business users across three countries.
```

Skills: Python, Pandas, XlsxWriter, Databricks, SQL, PySpark, Semantic-layer, Data-Modeling, Data-Quality, Pipeline-Monitoring, Cloud-Cost-Optimization, Oracle-BI-Publisher, Medallion-Architecture

### Data Engineer

ETA Orionis. Nov 2023 - Jul 2024

```text
Developed a Business Intelligence web application as an industrial thesis to investigate irregular behavior among affiliated merchants and help prevent money laundering. Designed three data marts (finance, asset control, and anti-money-laundering) to power Metabase dashboards and speed up reporting.
```

Skills: Python, fastAPI, REST-APIs, Metabase, Data-Marts, BonitaSoft, Workflow-Automation, SQL

## Education

### Universidad Metropolitana

Bachelor of Engineering, Systems Engineering. 2019 - 2024. Grade: 17.83/20

Activities and societies: Dean's List (Rector's List) 2021-2022, 2022-2023; Distinguished Honors Thesis

```text
Bachelor of Engineering in Systems Engineering, graduated Cum Laude with a GPA of 17.83/20. Dean's List for 2021-2022 and 2022-2023, and distinguished honors thesis on POS-transaction monitoring for money-laundering prevention.
```

## Tech stack

- Looker
- Metabase
- GitHub
- Jupyter
- NumPy
- Pandas
- PySpark
- Databricks
- React
- JavaScript
- Python
- Java
- PyTorch
- FastAPI
- Shell
- SQL
- Supabase
- Delta Lake
- Cursor
- dbt Cloud
- N8N
- LangGraph
- Unity Catalog
- Claude Code
- Looker Studio

To contact John, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Carlos Eduardo Goncalves Rodrigues](https://himalayas.app/@carloseduardogoncalv): Data Analyst, ARMI Logistics
- [Jesús Hernández](https://himalayas.app/@JesusAHB): Data Analyst (Project), SaaS Retention Engine
- [Sabas Rodriguez](https://himalayas.app/@sabasrodriguez): Senior Data Engineer, Fabric, BairesDev
- [Daniel Camacho](https://himalayas.app/@danielcamacho1): Data Analyst & Data Engineer, FYCO
- [Jonathan Briceño](https://himalayas.app/@jonathanbriceo): Data Scientist Internship, CrixSoft Solution
- [Daniel Sanson](https://himalayas.app/@dasanson): Data & BI Analyst, Freelance
- [Saul Cova](https://himalayas.app/@saulcova): Data Integration Specialist, Engineer Access
- [Ariel Cornejo](https://himalayas.app/@arielCo): Data Engineer, DBA on Call
- [Zair Valentina Duarte Romero](https://himalayas.app/@zairvalentinaduarter): Administradora & Analista de Operaciones y Datos, Fondo UGAVI para el Desarrollo Agropecuario
- [Galvys Rodríguez](https://himalayas.app/@galvysrodrguez): Ingeniero de Datos / Analista, PagoVenezuela
