Paolo Francesco Riva Riquelme

Data Engineer / Developer / Tech Enthusiast

— years old Milan, Italy / Remote Chilean / Italian

Chemical Engineer turned Data Engineer with a deep-seated focus on systems architecture and high-performance data pipelines. Whether I'm migrating legacy infrastructures for major financial institutions or building custom asynchronous scrapers, I am driven by a performance first mindset. I thrive on the challenge of transforming raw data into scalable, robust infrastructure, constantly evolving my methodology to stay at the cutting edge of modern data engineering and backend development.
Curious about my background? Check out the FAQ ↓

Skills

Data Engineering & Pipelines

SQL Oracle - PLSQL Postgres - PLpgSQL Teradata Google BigQuery pySpark Databricks Apache Kafka Redis MongoDB Valkey SQLite

Programming & Querying

Python Javascript Bash / Shell Rust (still learning...)

Cloud & Infrastructure

GCP Docker Git VS Code Ansible Linux Distributions

Web Development

HTML5 Javascript Tailwind D3 OAuth2 Uvicorn, Granian, uWSGI HTTP2/3 HTTPS Nginx

Work Experience

Alten

Alten

Milan, Italy (remote)

Data Engineer

Dec 2022 - Present

In this role, I served as a core technical consultant for one of Italy's largest financial institutions, managing a diverse portfolio of 3 to 5 concurrent projects. While my initial focus centered on PL/SQL development, I proactively expanded my technical repertoire to meet the client's evolving architectural requirements, integrating Bash, Python, PostgreSQL, BigQuery, Teradata, DataStage and advanced data engineering patterns into my workflow.
A primary achievement in this role was leading the migration of over 30 critical ETL pipelines from a legacy environment (DataStage and Teradata) to a modern, cloud-native architecture leveraging PySpark and Google BigQuery. Additionally, I managed the telemetry pipeline infrastructure, a high-throughput system responsible for processing and storing millions of daily event traces from web and mobile platforms.
Beyond my direct development responsibilities, I became an expert in the client's internal CI/CD frameworks and ecosystem. This allowed me to act as a horizontal support pillar, providing technical guidance and troubleshooting for various divisions to ensure seamless integration across the client's broader application landscape.

Referral: Riccardo Vasile - Team Leader
Accenture

Accenture

Milan, Italy (hybrid)

Application Development Analyst

Jun 2021 - Dec 2022 · 1 yr 7 mos

Following my promotion. I stepped into the role of PL/SQL lead, taking over after the previous lead moved to a new position. I reported directly to the functional analyst and served as the primary developer for the project. In addition, I was responsible for managing and allocating tasks across a small team of developers. This role represented my first leadership experience and required balancing distribution with each team member's flexible schedule and differing levels of expertise in the system.

Referral: Gianluca Dessì - Tech Arch Delivery Assoc Manager

Application Development Associate

Jan 2020 - May 2021 · 1 yr 5 mos

This role marked my first full professional experience as a PL/SQL developer. I contributed to the development and maintenance of a large‑scale data‑migration and inventory‑management solution for the merger of two telecommunications companies. During the transition, the legacy and new inventory platforms operated simultaneously, requiring real‑time, bidirectional synchronization. All transactional events executed on one system had to be captured, translated, and replicated on the other, a process fully implemented in PL/SQL. I was part of a core development team of three permanent members, supported by additional temporary developers during peak development phases.

Referral: Gianluca Dessì - Tech Arch Delivery Assoc Manager

Technology Trainee

Sep 2019 - Jan 2020 · 5 mos

The trainee program was divided into two stages. The initial phase consisted of intensive classroom training in core technologies such as computer logic, Java development, SQL and Oracle databases, and web application frameworks (Java Spring). After passing the technical evaluation, I joined an active client engagement. I was assigned to a multi-year telecommunications migration project, supported by an excellent recommendation from my classroom professor.

Referral: Emanuele Galli - Senior Software Developer
Enet Energy SA

Enet Energy SA

Lugano, Switzerland (onsite)

Trainee

Jun 2019 - July 2019 · 1 mos

I developed analytical and automation tools to enhance workflow efficiency within the trading desk and to strengthen decision-making for natural gas trading.

Referral: Roberto Dalla Muta - Natural Gas Portfolio Trader
Universidad de Concepción

Universidad de Concepción

Concepción, Chile (onsite)

Product Formulation Researcher

Nov 2016 - Apr 2017 · 6 mos

Following the strong outcomes of my thesis research, I was entrusted with a new phase of application development. As a newly graduated researcher, I led the formulation of intumescent polyurethane tailored for multiple application types including coatings, foams, and sprayable systems.

Referral: Katherina Fernandez - Associate Professor

Undergraduate Student Researcher

Mar 2016 - Aug 2016 · 6 mos

During my thesis research on intumescent polyurethane coatings, I unexpectedly identified an efficient method for producing polyurethane foam that retains the key properties required for the application. This finding led the university to hire me to further develop the process in parallel with my thesis.

Referral: Katherina Fernandez - Associate Professor

Personal Projects

VolleyBot

VolleyBot

Dec 2025 - Present

2025 Live

What started as a casual Sunday volleyball game between 8 friends eventually exploded into a community of over 90 players. As we scaled, our "honor system" WhatsApp list collapsed under the weight of 90+ people fighting for 24 spots across three courts. Between accidental deletions, "creative" rule-following, and the manual overhead of policing the list, I decided the group needed a digital referee.
We migrated the entire community to Telegram and built VolleyBot to take over the logistics. No more manual lists or Sunday morning arguments, the bot handles the gatekeeping so we can focus on the game.
It's a simple solution to a "90-person problem," and it's honestly been one of my most appreciated projects. There's something uniquely satisfying about seeing your code directly stop a group chat from descending into chaos every Tuesday night!

The "Community Logic" Tech

Fair-Play Automation - Built a priority-queue system that automatically favors members over guests, ensuring our core group always gets a court.
The "Zero-Trust" List - Unlike a text message, the bot is the single source of truth. It manages reservations, handles the "first-come, first-served" logic, and automatically closes the cutoff at the exact deadline.
Serverless Reliability - Designed to be lightweight and responsive, the bot handles the peak "registration rush" every week without breaking a sweat.
Python HTML Telegram API 14 commits
Python 71.4% HTML 28.6%
BudgetGamer

BudgetGamer

Nov 2023 - Present

2023 Live

With BudgetGamer, I wanted to build something built to last-and built to scale. It's a platform designed for the patient gamer, tracking price devaluations and sales across the industry. This project represents a major shift in my approach, moving away from "just making it work" toward high-performance systems engineering and 24/7 reliability.
To handle the massive influx of pricing data and user requests, I completely overhauled my previous architectures. This meant moving to an asynchronous stack with Uvicorn and the uv Python distribution, and designing a custom proxy-rotation manager to handle high-frequency scraping without hitting bottlenecks.

The Performance & Reliability Stack

Hybrid Rust/Python - To solve CPU heavy bottlenecks, I implemented a high speed HTML parser using PyO3 and Rust, running as a separate process to leverage true parallelism.
Modern Auth & UX - For the first time, I implemented a full user ecosystem, including OAuth2, session management, and a robust Wishlist system.
Multichannel Alerts - Built a notification engine that pings users across Email, Telegram, Discord, and Push, ensuring they never miss a deal.
Observability - Redesigned the exception framework from the ground up-if something breaks, the "devs" (me) get alerted instantly.
Python Postgres PLpgSQL Redis Javascript Rust Uvicorn Nginx 2,837 commits
Python 56.1% HTML 14.7% CSS 14.0% Javascript 8.4% Jinja 6.3% PLpgSQL 0.4% Other 0.1%
BizWeekNews

BizWeekNews

Sep 2022 - Jul 2024

2022

Building on the foundation of InsiderPeek, BizWeekNews (Business Weekly News) was my attempt at turning raw financial headlines into actionable intelligence. While my previous project focused on "who" was buying, this one focused on the "why"-aggregating and analyzing news across the global stock market to find the signal in the noise.
This was my first real-world playground for Machine Learning. After a year of hoarding news data, I trained a custom model to automatically categorize articles and link them to specific public companies-moving beyond simple keyword matching to something much more sophisticated.

The "Level Up" Tech

NLP & Analytics - Implemented natural language processing to map relationships between companies (e.g., how a news story about Company A might impact Company B) and generated automated summaries for company-specific pages.
The ML Pivot - Shifted from "labeled" news to training a model capable of identifying company relevance in unstructured text, significantly reducing manual data entry.
The "Scraper War" - At its peak, the system was a sophisticated engine of scrapers, though I eventually retired it when the "cat-and-mouse" game of maintaining scrapers against changing website structures started feeling like a second full-time job.
Python NTLK PyTorch PostgreSQL Redis uWSGI Nginx 423 commits
Python 34.6% Javascript 31.8% CSS 25.6% HTML 4.8% Shell 2.3% PLpgSQL 0.7% Other 0.2%
InsiderPeek

InsiderPeek

Dec 2021 - Nov 2024

2021

Born out of the 2020 lockdowns and a newfound interest in the stock market, InsiderPeek was my first deep dive into the world of Python and data engineering. I was frustrated by the clunky, "90s-style" websites used to track SEC insider trading filings, so I decided to build my own dashboard from scratch.
What started as a simple scraper grew into a full-scale learning laboratory. Since this was the "pre-AI" era, I spent my nights digging through documentation to build a custom search engine and a responsive UI. To get the site live, I taught myself the ropes of Linux, renting the smallest DigitalOcean droplet available (1GB RAM!) and figuring out how to make it performant.
The project eventually "retired" when I realized I preferred querying my own database directly over maintaining the UI, but not before it generated some Google Ads revenue and gave me the foundational skills that eventually shifted my professional career toward Data Engineering.

The "Over-Engineered" (But Fun) Tech

Data Orchestration - Built a Python-based scraper for the SEC's EDGAR database, navigating strict rate limits and complex data structures.
Hybrid Storage - Migrated from SQLite to a synchronized system where my "home warehouse" fed a persistent Redis instance on the cloud server to keep memory usage low.
Deployment - Got my hands dirty with the classic web stack: Nginx as a reverse proxy and uWSGI to serve the Django app.
Python Django PostgreSQL Redis uWSGI Nginx 1,063 commits
Python 42.3% Javascript 34.0% CSS 16.3% HTML 5% Shell 1.5% PLpgSQL 0.8%

Education

InsiderPeek

Politecnico di Milano

M.Sc. Chemical Engineering

Sep 2017 - Jul 2020

Thesis: "Study of the kinetic model and plant steady-state simulation for the synthesis of methanol from syngas on synthetic Cu/ZnO/Al2O3 catalyst"

▸ Key Courses
Process Systems Engineering Dynamics and Control of Chemical Processes Process Control and Instrumentation Laboratory Chemical Reaction Engineering Applied Chemical Kinetics Formulation Technology Computational Fluid Dynamics of Reactive Flows Principles of Polymer Chemistry Industrial Organic Chemistry Chemicals and Materials for Energy and Environment
InsiderPeek

Universidad de Conceción

Academic & Professional degree, Chemical Engineering

Mar 2010 - Nov 2016

Thesis: "Polyurethane intumescent coating formulation based on tannins from Pinus Radiata"

▸ Key Courses
Chemical Reactor Design Process Dynamics Process Control Optimization of Processes Separation Process Industries Chemical Process Industries Thermodynamics Physical Chemistry Organic Chemistry Heat Transfer Fluid Mechanics Mass Transfer Transport Phenomena Drawing of Chemical Processes Food Industry Operations Formulation and Evaluation of Projects Business Management Legal Aspects of the Company Safe Handling of Hazardous Substances Modern Adminstration and Techniques for Prevention and Control of Risk Numerical Analysis Statistics Economy Statistical Data Processing and Design of Experiments Mechanics Electromagnetism

Online Courses & Certifications

Self-directed continuous learning

2021 - Present

Targeted online training in data engineering, cloud platforms, and machine learning to complement formal degrees.

Flask in Python: Building a Simple Web Site Using FlaskSkillsoft2021
Flask in Python: An Introduction to Web Frameworks & FlaskSkillsoft2021
Python Design Patterns: Working with Behavioral Design PatternsSkillsoft2020
Python Design Patterns: Working with Structural Design PatternsSkillsoft2020
Python Design Patterns: Working with Creational Design PatternsSkillsoft2020
Python Design Patterns: Principles of Good DesignSkillsoft2020
Python AI Development: IntroductionSkillsoft2020
Python Classes & Inheritance: Advanced Functionality Using Python ClassesSkillsoft2020
Python Classes & Inheritance: Working with Inheritance in PythonSkillsoft2020
Python Classes & Inheritance: Getting Started with Classes in PythonSkillsoft2020
Python Classes & Inheritance: IntroductionSkillsoft2020
Excel with Python: Constructing Data VisualizationsSkillsoft2020
Excel with Python: Performing Advanced OperationsSkillsoft2020
Excel with Python: Working with Excel Spreadsheets from PythonSkillsoft2020
Socket Programming in Python: Advanced TopicsSkillsoft2020
Socket Programming in Python: IntroductionSkillsoft2020
Python Requests: HTTP Requests with PythonSkillsoft2020
Data Structures & Algorithms in Python: Implementing Trees & GraphsSkillsoft2020
Data Structures & Algorithms in Python: Trees & GraphsSkillsoft2020
Data Structures & Algorithms in Python: Implementing Sorting AlgorithmsSkillsoft2020
Data Structures & Algorithms in Python: Sorting AlgorithmsSkillsoft2020
Data Structures & Algorithms in Python: Implementing Data StructuresSkillsoft2020
Data Structures & Algorithms in Python: Fundamental Data StructuresSkillsoft2020
Functions in Python: Gaining a Deeper Understanding of Python FunctionsSkillsoft2020
Functions in Python: Working with Advanced Features of Python FunctionsSkillsoft2020
Functions in Python: IntroductionSkillsoft2020
Conditional Statements & Loops: While Loops in PythonSkillsoft2020
Conditional Statements & Loops: Advanced Operations Using for Loops in PythonSkillsoft2020
Conditional Statements & Loops: The Basics of for Loops in PythonSkillsoft2020
Conditional Statements & Loops: If-else Control Structures in PythonSkillsoft2020
Complex Data Types in Python: Shallow & Deep Copies in PythonSkillsoft2020
Complex Data Types in Python: Working with Dictionaries & Sets in PythonSkillsoft2020
Complex Data Types in Python: Working with Lists & Tuples in PythonSkillsoft2020
Getting Started with Python: IntroductionSkillsoft2020
Spark, Hadoop, and Snowflake for Data EngineeringDuke University2025
AWS CodeDeploySkillsoft2021
Amazon ECS & OpsWorksSkillsoft2021
AWS Cloud Pratitioner 2019: Technology Support ResourcesSkillsoft2021
AWS Cloud Pratitioner 2019: Core AWS ServicesSkillsoft2021
AWS Cloud Pratitioner 2019: AWS Cloud Deployment and OperationSkillsoft2021
AWS Cloud Pratitioner 2019: Security Support ResourcesSkillsoft2021
AWS Cloud Pratitioner 2019: AWS Access ManagementSkillsoft2021
AWS Cloud Pratitioner 2019: Cloud Security & ComplianceSkillsoft2021
AWS Cloud Pratitioner 2019: Shared ResponsabilitySkillsoft2021
AWS Cloud Pratitioner 2019: Architecture Design PrinciplesSkillsoft2021
AWS Cloud Pratitioner 2019: Cloud EconomicsSkillsoft2021
AWS Cloud Pratitioner 2019: AWS Cloud & the Value PropositionSkillsoft2021
JavaScript: Functions & Arrays in JavaScriptSkillsoft2021
JavaScript: Types, Operators, & Control Structures in JavaScriptSkillsoft2021
JavaScript: Getting Started with JavaScript ProgrammingSkillsoft2021
JavaScript: IntroductionSkillsoft2021
Building Web Apps Using Django: Generic ViewsSkillsoft2020
Building Web Apps Using Django: Implementing Login & LogoutSkillsoft2020
Building Web Apps Using Django: Models & User RegistrationSkillsoft2020
Building Web Apps Using Django: Templates & User AdministrationSkillsoft2020
Building Web Apps Using Django: Building a Basic WebsiteSkillsoft2020
Building Web Apps Using Django: Introduction to Web Frameworks & DjangoSkillsoft2020
Deployment and DeliverySkillsoft2021
Source ControlSkillsoft2021
Recording, Posting, and Balancing the BooksSkillsoft2020
Key Accounting Concepts and PrinciplesSkillsoft2020
Building Neural Networks: Development PrinciplesSkillsoft2020

Languages

🇨🇱 Spanish

Native
Reading & Listening100%
Oral & Written Expression100%

🇮🇹 Italian

Advanced (B2)
Reading & Listening90%
Oral & Written Expression80%

🇬🇧 English

Proficient (C1)
Reading & Listening95%
Oral & Written Expression85%

Documents

Passport

🇨🇱 Chile

Passport

🇮🇹 Italy

Driver's License

🇨🇱 Chile

FAQ

Chemical Engineering provided a fantastic foundation in architectural thinking and systemic problem-solving, but I found my true calling when I discovered the agility of the digital world. While both fields require a high-level mindset to design the best solution for complex cases, the 'feedback loop' is orders of magnitude apart. In a chemical process, moving from an idea to a scaled application can take months or years; in Data Engineering, I can design, test, and deploy a solution within the same day. I chose the path that allowed me to iterate faster and see the immediate impact of my work.
I'm drawn to roles that go beyond standard ETL projects defined by complex constraints or 'hardcore' architectural challenges that require creative, first-principles thinking. While my background is rooted in robust data engineering, I am looking to pivot more deeply into Cloud, Big Data, and AI applications. I've already successfully integrated these technologies into my professional and side projects, and I'm now looking for a role where I can apply that toolkit to high-scale, mission-critical problems on a daily basis.
I have been working 100% remotely since 2020 and have found it to be my most productive environment. The lack of a commute allows me to be highly focused and offers the flexibility to commit extra hours whenever a project reaches a critical milestone. That said, I am open to hybrid arrangements if the specific workflow or team dynamic would truly benefit from face-to-face collaboration. For me, it's about choosing the setting that allows me to deliver the highest quality work.
Coming from a consulting background, I've learned that a Data Engineer's best work is invisible if it doesn't integrate well with others. I enjoy acting as a technical bridge helping Backend, Frontend, and DevOps teams navigate our data infrastructure to ensure that the pipelines I build actually serve the broader application's goals.
Automate the repetitive so you have more time to solve the complex. If I have to perform a manual task more than twice, I'll likely spend the next four hours writing a script to ensure I never have to do it a third time.
Even in workflows that require a 'human in the loop' for specific inputs or decisions, I look for ways to streamline the friction. I'm a big proponent of building internal tools using libraries like Textual to create high-performance, terminal-based forms and interfaces that transform a messy manual process into a structured, automated pipeline. For me, if a process exists, it should be as seamless and optimized as the data flowing through it.
Over-engineering simple solutions for my own life.
If I can spend a weekend building a custom Rust-powered parser or a notification engine for something trivial, I'll take that as a win.
Long before I was architecting data pipelines, my first real 'IT' project was an arcade machine. I built it using a Raspberry Pi 4, a screen from a dead notebook, a third-party monitor controller, an old desktop power supply, and a set of speakers pulled from a scrapped car.
It ran RetroPie, and while it was great for playing old classics, its real value was being my first experience into the world of Linux.