leandro@portfolio:~

Data Analyst | SQL, Python, dbt | Automations & Data Engineering

Limassol, Cyprus

leandrocassius@proton.me · @leandro_cassius

$
leandro@portfolio:~ cat about.txt

Professional Summary

Data Analyst with 4+ years of experience querying data using SQL, cleaning data and creating predictive models with Python, and visualizing data in order to get insights. Currently collaborating with the BI team on data engineering and analytics engineering tasks, such as ELT pipeline development, data modeling in Amazon Redshift, and pipeline automation.

I've worked across the full stack of analytics work: building API ingestion pipelines, modelling data with dbt, running A/B tests and causal inference analysis, and using NLP to surface content and trend patterns. Before that, in marketing analytics, I built segmentation models and funnel analysis that shaped acquisition strategy. What ties it all together is a low tolerance for manual, repeatable work, and that's what I actually really like about using my programming skills in analytics: if I'm doing the same anything twice, I automate it.

Languages

  • Portuguese (Native)
  • English (Fluent)
  • Spanish (Fluent)
  • Russian (Fluent)
  • Italian (Advanced)
leandro@portfolio:~ cat skills.txt

Core Competencies

  • ELT Pipeline Development
  • Data Modeling & Warehouse Design
  • SQL Transformation Layers
  • Incremental Data Loading
  • Workflow Orchestration
  • Data Quality & Validation
  • API Ingestion & Pipeline Automation
  • Dashboard & BI Development

Python · SQL · BigQuery · Amazon Redshift · PostgreSQL · Airflow · pandas · Tableau · YouTube API

leandro@portfolio:~ cat experience.txt

Professional Experience

TheSoul Group — Data Analyst (NLP, Content Insights) · 2024–Present

  • Contributing to the design and development of an analytics dashboard connecting multiple data sources to Amazon Redshift, assisting the BI team with incremental ingestion pipelines for competitor data via the YouTube API and automated alerts on hit video detection
  • Assisting the BI team in building a multi-source data model in Amazon Redshift integrating posting cadence, view decay, and RPM distributions to support content lifecycle value metrics
  • Contributing to an automated ELT ingestion pipeline using the YouTube Data API to incrementally load channel, video, and metadata records into a structured analytical store for competitive benchmarking
  • Built a text processing pipeline applying TF-IDF, K-means clustering, and classification to transform raw YouTube metadata into structured trend signals for downstream reporting
  • Implemented data quality and validation checks using Python and pandas to enforce schema consistency and detect missing values across ingestion workflows

Kaverto — Data Analyst (Marketing & Experimentation) · 2022–2024

  • Built SQL-based analytical pipelines to aggregate campaign performance metrics across paid acquisition channels, enabling statistical comparison and ROI attribution reporting
  • Modeled behavioral segmentation tables using SQL aggregations and Python transformations to expose user lifecycle patterns, feeding into lifecycle messaging strategies
  • Engineered funnel conversion models in SQL to track drop-off across acquisition stages, used by marketing to drive data-backed budget reallocation decisions
  • Developed automated reporting workflows using Python and Tableau to surface acquisition performance, cohort retention, and funnel conversion trends to stakeholders
leandro@portfolio:~ ls projects/
leandro@portfolio:~ cat education.txt

Education

B.Sc. Economics — Higher School of Economics

leandro@portfolio:~ open certificates/

Certificate

Google Data Analytics Professional Certificate Coursera · 2022

Specialization in data analysis with SQL, R, Tableau, and Google BigQuery