AVAILABLE FOR HIRE · LISBON / REMOTE v.2026
Yulia Carvalho
// data analyst & data engineer

Yulia Carvalho

Grounded in scientific rigor, focused on clarity, precision,
and a disciplined approach to complexity

15+ YRS RESEARCH · 12 PUBLICATIONS · LISBON, PORTUGAL
// 01 - about

A scientist’s analyst.

Hi, I am Yulia. I spent over fifteen years in internationally recognized research environments and applied biomedical settings - building a career at the intersection of molecular biology, data, and systems thinking. My work spanned experimental design, complex data analysis, scientific publications, documentation and interdisciplinary collaboration.

During and after the COVID-19 pandemic, my responsibilities expanded into laboratory operations and clinical-study logistics - equipment coordination, workflow optimization, process design under pressure. Science increasingly became systems management: understanding how people, processes, data, and infrastructure interact when reliability matters.

At 37, I made a deliberate transition into the Data field. My curiosity about visualization (oddly, through watercolor) led me to formal training: I enrolled in the Google Data Analytics program while still employed, later completed an intensive Le Wagon Data Analytics bootcamp, and built applied projects focused on cleaning, modeling, documenting and transforming raw data into usable analytical outputs.

What I enjoy most is what I call “forensic EDA” - a structured, investigative approach to exploratory analysis. For me, analysis starts before dashboards or models. It starts with questioning the integrity of the data itself: cleaning inconsistencies, validating assumptions, identifying anomalies, resolving cross-field conflicts, and tracing how raw data becomes reliable analysis.

I am especially drawn to the engineering side of analytics: building reproducible workflows, defining clear data logic, preparing BI-ready datasets, and documenting pipelines, transformations, and metrics so they can be trusted. I approach datasets the way I once approached experiments - skeptically, methodically, and with respect for the underlying system - until the logic becomes clear.

// 02 - selected projects

What I’ve been building.

DATA ENGINEERING MAY 2026

IPMA Weather Pipeline: Automated Ingestion, Transformation & Live Dashboard

End-to-end data engineering pipeline delivering daily weather observations to a live Streamlit dashboard

Python · BigQuery dbt GitHub Actions Streamlit

A production-grade data engineering pipeline ingesting hourly weather observations from ~197 meteorological stations across Portugal via the IPMA public API. Implements a layered architecture (raw → staging → mart) with automated data quality testing, incremental batch loading, and daily scheduling — powering a live interactive Streamlit dashboard with real-time station monitoring, regional temperature maps, and 24-hour trend analysis.

~4500
observations per day
197
stations monitored
8
automated quality tests
  • Automated Incremental Ingestion: Python script calls the IPMA public API daily, fetching hourly observations from 197 stations across Portugal and appending raw batches to BigQuery — fully scheduled via GitHub Actions with zero manual intervention.
  • Raw Layer Integrity: Append-only raw layer preserves the complete API response history, with an ingested_at timestamp on every row for full auditability and root cause tracing.
  • Multi-Table Pipeline Architecture: Dual-table ingestion pattern — append-only observations and truncate-reload stations — reflecting the different update semantics of each source.
  • Layered dbt Transformation: Two-layer dbt model (staging → mart) applying type casting, sentinel value nullification, wind direction decoding, deduplication on natural key, and a custom 7-region geographic classification of all stations across Continental Portugal, Açores, and Madeira.
  • Automated Data Quality Framework: 8 dbt tests covering null constraints, timestamp validity, and accepted ranges for all measurement fields — pipeline fails automatically if any test is violated.
  • Production-Grade Scheduling: Full pipeline (ingest → dbt run → dbt test) orchestrated via GitHub Actions cron, with automatic failure notifications and run logs for full observability.
  • Live Interactive Dashboard: Custom Streamlit app connected directly to BigQuery mart, featuring a Plotly choropleth map with regional temperature gradients, per-station metric cards with trend indicators, 24-hour temperature area charts, and bilingual EN/PT interface — deployed on Streamlit Community Cloud.
IPMA Weather Pipeline - Portugal weather stations map
IPMA WEATHER PIPELINE
FRONT-END APRIL 2026

Personal Portfolio Website

HTML5 CSS3 Git & GitHub Pages

Designed and deployed a personal portfolio site from scratch using HTML, CSS, and GitHub Pages - focused on typographic hierarchy, responsive layout, and a recruiter-friendly information architecture.

Claude Design was used for minor final design refinements and visual touch-ups.

OPERATIONS ANALYTICS DEC 2025 - JAN 2026

Olist: Retention, Logistics & Risk

Capstone for the Google Data Analytics Professional Certificate

SQL · BigQuery R Kaggle

A comprehensive operational analytics study of Brazil's Olist marketplace - diagnosing the structural drivers of customer dissatisfaction, logistics failure, and seller performance risk. Integrates SQL data engineering with R-driven statistical modeling: regression analysis, risk scoring, and route-level segmentation.

100K+
orders analyzed
18
business questions
1
dashboard
  • Integrated Multi-Source Analytical Pipeline: Developed an end-to-end data pipeline connecting cloud-based warehousing to a statistical environment, integrating transaction, logistics, and sentiment data into a unified layer for advanced modeling.
  • Validated Predictive Satisfaction Models: Applied multiple linear regression models to isolate the drivers of customer satisfaction, establishing delivery delay as the dominant predictor while evaluating the relative insignificance of other factors.
  • Strategic Seller Risk Framework: Engineered a composite risk scoring system that prioritizes accounts for intervention by weighing historical lateness, delay severity, and total business value at risk.
  • Geographic Infrastructure Diagnostics: Conducted origin–destination route analysis to distinguish between individual seller inefficiencies and systemic regional logistics constraints, identifying high-impact corridors that require infrastructure optimization.
  • Advanced Feature Engineering: Developed diagnostic indicators, including category-relative fulfillment benchmarks and volumetric classifications, to capture the handling complexity and physical realities of marketplace logistics.
  • Quantified Business Exposure: Established a framework to link poor customer reviews with financial risk, providing a data-driven basis for calculating the return on investment for operational improvements.
  • Seasonal Moderation Modeling: Implemented interaction regression models to analyze how holiday periods influence customer expectations, measuring the degree to which seasonal shopping events amplify the negative impact of delivery delays.
  • Rigorous Data Modeling Protocols: Implemented strict granularity controls throughout the analysis to ensure there are no potential statistical distortions in multi-item transactions.
Olist project cover - shipping route map
GOOGLE DATA ANALYTICS
ENVIRONMENTAL ANALYTICS NOV 2025

Biodiversity Loss in Europe

Graduation project for the Le Wagon Data Analytics Bootcamp

In collaboration with Pascal Niessing and Clara Martin Santasusana

Python SQL Google Colab Looker Studio

A structured environmental data analysis examining the relationship between land-use patterns, protected-area coverage, and the Biodiversity Intactness Index across EU countries. Integrates multi-source datasets and applies comparative analysis to identify cross-country structural patterns influencing biodiversity outcomes.

27
EU countries
5
data sources
1
team graduation project
  • Multi-Source Environmental Modeling: Integrated land-use, protected-area, and biodiversity datasets into a unified analytical framework for cross-country evaluation.
  • Structural Pattern Comparison: Examined how differences in land-use composition and conservation coverage relate to biodiversity intactness, identifying recurring patterns across EU countries.
  • Dashboard-Based Communication: Built Looker Studio dashboards to present environmental indicators clearly and support technical discussion of the findings.
  • Reproducible Data Documentation: Maintained clear methodology and data lineage to support transparency, traceability, and reproducibility.
Biodiversity project cover
LE WAGON
// 03 - toolkit

The toolkit.

6 GROUPS
Languages & Markup
SQL CTEs · window functions · validation
Python
Python data analysis · basic scripting
R
R analysis · reporting
HTML5
HTML5 semantic structure · portfolio build
CSS3
CSS3 responsive styling · layout basics
Data Engineering
BigQuery
BigQuery warehouse SQL · cost-aware queries
dbt data modeling (raw → staging → marts)
Airflow
Airflow orchestration concepts · DAGs
Fivetran ELT pipeline concepts
DuckDB local analytics
λ Analysis Libraries
pandas
pandas data wrangling & transformation
numpy
NumPy numerical operations
BS
BeautifulSoup basic web scraping
R
tidyverse · lubridate data manipulation
Σ Statistics & Modeling
Statistical analysis regression · hypothesis testing · diagnostics
scikit-learn
scikit-learn regression, classification, model evaluation
Prophet time series forecasting
Visualization & BI
Power BI
Power BI dashboards · DAX · modeling
Looker Studio
Looker Studio reporting dashboards
matplotlib
matplotlib · seaborn static visualizations
Plotly
Plotly interactive charts
gg
ggplot2 visual analysis in R
Workflow & Tools
Git
Git version control
GitHub
GitHub repositories · project publishing
VS Code
VS Code · RStudio development environments
Jupyter
Jupyter · Colab interactive notebooks for analysis
Kaggle
Kaggle published projects and experimentation
Bash
CLI · Bash terminal workflows
// 04 - experience

Where I’ve worked.

Nov 2025 - Present
Lisbon, PT · remote
6 mos
Data Analytics & BI - Self-Directed Projects
Self-employed
Independent Data Analyst - end-to-end analytics, portfolio development, applied upskilling in SQL, Python, R, Power BI, and ETL tools.
  • Built end-to-end analytics projects covering data cleaning, validation, exploratory analysis, metric design, dashboard development, and business insight generation.
  • Developed a detailed e-commerce analytics project structured around 18 interconnected business questions across customer behavior, logistics, operations, and retention.
  • Created reproducible analytical workflows in Kaggle and GitHub, with strong emphasis on documentation, data quality, and transparent business logic.
  • Designed Power BI dashboards and supporting metric documentation to translate complex analysis into clear, decision-oriented reporting.
  • Continued formal upskilling through the Google Data Analytics Certificate and Le Wagon Data Analytics Bootcamp.
  • Developed and launched a personal portfolio website hosted on GitHub Pages to present projects, technical skills, and professional background.
Apr 2023 - Feb 2025
Lisbon, PT · on-site
1 yr 11 mos
Laboratory Data Manager
GIMM - Gulbenkian Institute for Molecular Medicine
Mission Lab
  • Owned laboratory quality assurance - improving workflow structure, data traceability, and documentation standards through SOP creation and process guidance.
  • Participated in the implementation and configuration of a LIMS tailored to laboratory needs - defining required sections, records, and operational data structures.
  • Migrated legacy laboratory records into the LIMS, including Excel trackers, equipment maintenance logs, and related operational data.
  • Authored the SOP for LIMS use to standardize system adoption, data handling, and operational consistency across the lab.
  • Applied data-driven resource tracking to monitor consumable usage, forecast needs, optimize inventory, and reduce waste.
  • Managed core lab operations - equipment maintenance, supplier coordination, and safety compliance - supported by structured logs and monitoring.
  • Coordinated biological sample inflow, processing, and logistics, ensuring accurate registration, tracking, and reporting.
Nov 2020 - Mar 2023
Lisbon, PT · on-site
2 yrs 5 mos
COVID-19 Diagnostic Specialist
iMM - Instituto de Medicina Molecular
COVID-19 Molecular Diagnostic Unit
  • Managed the planning, coordination, and execution of 200,000+ COVID-19 diagnostic tests under enhanced BSL-II conditions, ensuring accurate tracking, prioritization, and timely reporting.
  • Performed qPCR result analysis and prepared structured reports for patients and external entities with strong focus on data accuracy, completeness, and traceability.
  • Contributed to the design and optimization of laboratory protocols by calculating minimum tolerances, analyzing consumable usage patterns, and streamlining workflows - reducing cost without compromising diagnostic quality.
  • Applied domain knowledge, basic statistics, and digital tools to validate and maintain SINAVE data, ensuring data integrity, consistency, and up-to-date records for surveillance and reporting.
Oct 2018 - Nov 2020
Lisbon, PT · on-site
2 yrs 2 mos
Research Fellow
iMM - Instituto de Medicina Molecular
Vascular Morphogenesis Laboratory
  • Oversaw lab management and maintenance while supporting molecular cloning, virus production, and mouse colony genotyping - ensuring documentation, traceability, and protocol compliance.
  • Collected, organized, and analyzed experimental data from confocal microscopy and molecular assays, using spreadsheets and image-analysis tools to quantify results, assess variability, and support statistically sound conclusions.
  • Contributed to individual scientific projects and collaborated with PhD students and postdocs - helping design experiments, interpret data, and troubleshoot protocols based on quantitative readouts and controls.
  • Helped prepare figures, datasets, and method descriptions for internal reports, presentations, and publications, reinforcing a rigorous, reproducible, and data-driven approach.
Nov 2012 - Jan 2017
Frankfurt, DE · on-site
4 yrs 3 mos
Scientific Researcher / PhD Student
Institute of Cardiovascular Regeneration, Goethe University
Center for Molecular Medicine

Project I: “Epigenetics of stem cells: uncovering the role of noncoding RNAs” - identification and characterization of histone-H3-bound long noncoding RNAs in mouse stem cells.
Project II: “Identification and characterization of long noncoding RNAs in murine heart” - screening for positionally-conserved heart-expressed, -enriched or -specific lncRNAs and their molecular and functional characterization.

  • Handled large, complex sequencing and microarray datasets, integrating multiple experimental readouts.
  • Applied statistical methods to assess significance, validate findings, and interpret high-dimensional data in a robust, reproducible way.
  • Prepared and delivered presentations at scientific conferences and internal meetings, clearly communicating complex results, methods, and limitations to diverse audiences.
  • Contributed to peer-reviewed publications by designing and performing experiments, analyzing data, and documenting results - reinforcing a rigorous, evidence-based, data-driven research approach.
Nov 2011 - Oct 2012
Bad Nauheim, DE · on-site
1 yr
Invited PhD Student Researcher
Max Planck Institute for Heart and Lung Research
Department of Cardiac Development and Remodeling
  • Researched lncRNAs in embryonic stem cells; performed global transcriptome analysis during cardiac differentiation.
  • Co-authored a paper in Nucleic Acids Research (2012) on “Noncoder,” a web interface for exon-array detection of lncRNAs.
Nov 2010 - Aug 2011
Tenancingo, MX · on-site
10 mos
R&D Technician
Probiomed S.A. de C.V.
NL Biotechnologies LLC
  • Recombinant viral hepatitis vaccine development.
// 05 - education

Foundations.

Sep 2005 - Jul 2010
Kazan, RU
MSc - Molecular Biology / Microbiology
Kazan Federal University
Oct 2008 - May 2010
Kazan, RU
Diploma - Psychology
Kazan Federal University
// 06 - certificates & training

Continuous learning.

PRINCE2 Foundation Certificate in Project Management
PeopleCert® / AXELOS Global Best Practice
Issued Jan 2024
ETL in Python and SQL
LinkedIn Learning
Issued Feb 2026 · course completion
Marketing Digital & Plano de Negócio (PME)
IEFP - Instituto do Emprego e Formação Profissional
Issued Jul 2025 · course completion
Intermediate dbt
DataCamp
Issued Jun 2026 · course completion
Artificial Intelligence Fundamentals
IBM SkillsBuild
Issued Jun 2026 · badge
// 07 - publications

Peer-reviewed work.

A non-genetic model of vascular shunts informs on the cellular mechanisms of formation and resolution of arteriovenous malformations

Cardiovascular Research · Sep 2024

Show ↗

Competition for endothelial cell polarity drives vascular morphogenesis in the mouse retina

Developmental Cell · Oct 2022

Show ↗

Endothelial cell invasion is controlled by dactylopodia

PNAS · Apr 2021

Show ↗

Endothelial cell invasiveness is controlled by myosin IIA-dependent inhibition of Arp2/3 activity

Preprint · BioRxiv · Sep 2020

Show ↗

A systems immunology approach identifies the collective impact of 5 miRs in Th2 inflammation

JCI Insight · Jul 2018

Show ↗

A novel long non-coding RNA Myolinc regulates myogenesis through TDP-43 and Filip1

Journal of Molecular Cell Biology · Apr 2018

Show ↗

Airn regulates Igf2bp2 translation in cardiomyocytes

Circulation Research · Feb 2018

Show ↗

Long Noncoding RNA MANTIS Facilitates Endothelial Angiogenic Function

Circulation · Mar 2017

Show ↗

Logic programming to infer complex RNA expression patterns from RNA-seq data

Briefings in Bioinformatics · Dec 2016

Show ↗

Epigenetic Regulation of Angiogenesis by JARID1B-Induced Repression of HOXA5

Atherosclerosis, Thrombosis, and Vascular Biology · May 2015

Show ↗

Long noncoding RNA MALAT1 regulates endothelial cell function and vessel growth

Circulation Research · Mar 2014

Show ↗

Bacillus pumilus strains with inactivated genes of extracellular serine proteinases

Microbiology · Feb 2013

Show ↗

Noncoder: a web interface for exon array-based detection of long non-coding RNAs

Nucleic Acids Research · Sep 2012

Show ↗
// 08 - honors & awards

Recognition.

Future Leaders Exchange (FLEX) Scholarship Program

American Councils for International Education

Aug 2004 - May 2005

Finalist of the 2004 FLEX Scholarship Program - Lake Gibson High School, Lakeland, FL, USA. Certificate of Academic Excellence.

Excellence in Learning

Gymnasium 19, Kazan, Russia

Jun 2005

Silver medal for excellence in learning (overall GPA 5.0 / 5.0).

Short-term Research Grant

Justus-Liebig-Universität Gießen, Germany

Nov 2009 - Dec 2009

Collaboration grant between Kazan Federal University and Justus-Liebig-Universität Gießen. Internship at the Laboratory of Dr. Christoph Lämmler.

// 09 - professional principles

How I work.

I value clearly defined responsibilities, accountability, and disciplined execution of established processes. Operational structure and methodological rigor are, to me, essential for producing reliable and reproducible outcomes - and reliability builds trust.

I believe that transparent communication, constructive feedback, and openness to dialogue form the foundation of effective and strong professional collaboration. A culture of continuous improvement is, in my view, essential for both individual growth and high-quality outcomes - it is the environment in which meaningful progress happens.

// 10 - let's connect

Let’s connect.

If you have questions about my projects, ideas for improvement, or simply want to talk about data, research, or career paths in analytics, I would be happy to chat.

I genuinely enjoy exchanging ideas, learning from different professional paths, and building meaningful connections with people working across data, science, analytics, and technology.