Lucas Patriota Malinski

Professional Summary

Junior Data Engineer with experience building scalable ETL/ELT pipelines in Python and preparing analytical datasets for BI and decision-making. Strong background in data modeling, normalization, and performance-oriented data structures. Hands-on experience with Linux-based environments and automated data pipelines. Fluent in English; Brazil/Canada citizen. Currently pursuing a B.S. in Data Science & Machine Learning.

Technical Projects & Portfolio

Advanced Data Modeling & BI Project

Apr 2026 · Power BI, Power Query, Dimensional Modeling

github.com/lucasmalinski/modelagem_dados_evg

Developed an ETL pipeline using Power Query (M Language) to ingest, clean, and transform raw data from CSV files.
Designed and implemented a Star Schema physical data model, building fact and dimension tables with surrogate keys to ensure referential integrity.
Created dynamic calendar tables to support complex time-based analysis within the data model.
Implemented KPI-oriented data analysis visuals.

Transactional Data Pipeline (Tech Challenge)

Set 2025 · Bash, Airflow, Meltano

github.com/lucasmalinski/banvic_indicium

Designed a scalable ELT architecture simulating a banking environment with isolated Docker networks to secure transactional source DBs.
Implemented Docker-out-of-Docker where Airflow manages ephemeral Sibling Containers (Meltano) via host socket.
Developed Bash scripts for automated environment provisioning and service initialization.

CVM Funds Monitor (CS50 Final Project)

Dec 2025 · Python, Flask, Pandas

github.com/lucasmalinski/cvm_fundos2

Built an OOP-based Flask application (CVMExtractor) to process high-volume CVM financial data (ZIP/CSV) in-memory using io.BytesIO.
Implemented dynamic Pandas logic to parse complex datasets (Swaps, Stocks) based on user requests.

Crypto News ETL Pipeline

Jul 2025 · Python, GitHub Actions

github.com/lucasmalinski/financial-sentiment-pipeline

Developed a Python script for scraping, transformation (deduplication, timestamp parsing), and file management for sentiment analysis.
Architected a GitHub Actions workflow to schedule cron jobs and auto-commit data for persistence (CI/CD).

Homelab & Cloud Engineering (On-Premise)

Feb 2025 · Linux, Proxmox, Docker, Bash

Managed a Debian environment for self-hosted services, handling systemd, permissions, and virtualization via Proxmox LXC containers.
Wrote Bash scripts for boot order dependencies and self-healing network checks.

Professional Experience

Data Intelligence Intern

Dec 2023 – Mar 2024

CAU/BR - Brazilian Council of Architecture and Urbanism Brasília, DF, Brazil

caubr.gov.br/observatorioathis/painel-de-dados/

Served as Technical Liaison between IT and the Presidency, translating technical constraints into business insights.
Modeled and transferred high-volume datasets (Excel/CSV) to BI tools, ensuring reporting integrity.
Integrated ArcGIS into Power BI, mapping R$ 3M+ in investments for the ATHIS Portal.

Lucas P. Malinski

Professional Summary

Technical Skills