Skip to main content
John SmallpageJS
Looking for a job

John Smallpage

@johnsmallpage

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

Venezuela
Message

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

Work history, roles, and key accomplishments

FA
Current

Data & Analytics Analyst

Farmatodo

Aug 2024 - Present (2 years 3 months)

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.

EO

Data Engineer

ETA Orionis

Nov 2023 - Jul 2024 (8 months)

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.

Education

Degrees, certifications, and relevant coursework

Universidad Metropolitana logoUM

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

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.

Availability

Looking for a job

Location

Venezuela

Authorized to work in

Salary expectations

80k+ USD

Skills

Data EngineeringETL ELTDatabricksLakehouse ArchitectureSQLPySparkDimensional Modeling
Semantic Layer Design
Data Quality
Data Pipeline Monitoring
Delta Lake
Lakeflow Spark Declarative Pipelines
Dbt Cloud
Databricks Jobs
Data Vault

Interested in hiring John?

You can contact John and 600K+ other talented remote workers on Himalayas.

Message John

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan