Joao Fonseca

Data Engineer | Python, SQL, Azure, Airflow, dbt | Lakehouse & Data Pipelines | EU-remote B2B

Salary / Daily rate

Porto, Portugal

Mobility: Porto, Lisbon, ...

Freelance, open to permanent contract

Can come onsite

Skills

PythonSQL QueriesAzuredbtApache AirflowGoogle Cloud PlatformData EngineeringSnowflakeGitFastAPIAWSDatabricksPostgreSQLETLPySpark

Languages

English (Fluent)SpanishFrench

About me

Intro

I am a Data Engineer focused on building reliable data pipelines, lakehouse platforms, and analytics systems. My work is centered on Python, SQL, Azure, AWS, Airflow, dbt, Snowflake, Databricks, and PostgreSQL, with a focus on ingestion, orchestration, transformation, data quality, and analytics engineering. My main project is an Azure Lakehouse ETL Platform built with Azure Data Factory, ADLS Gen2, Databricks (PySpark), and Delta Lake, structured around a Bronze → Silver → Gold architecture. The platform includes a data quality layer, execution logs, and reproducible pipeline runs. I have also built: - A GitHub Events Data Pipeline using Python, S3, Airflow, and Athena, focused on ingestion reliability and orchestration - A dbt + Snowflake analytics platform with dimensional modeling (SCD2), tests as data contracts, and documented lineage - A PostgreSQL-based analytics platform (PHC) with Python ingestion pipelines and business KPI modeling I focus on building data systems that are reliable, testable, and production-oriented, not just transformations. Open to Data Engineering opportunities in EU-remote environments, with a preference for B2B / contract work.

Links

Work experience

Data Engineer (B2B / Contract)

Famous Satellite Unipessoal LdaFreelance

Jan 2020 - Present

6 years 10 months

European Union

Modern Data Stack focused Data Engineer delivering production-grade ELT pipelines and analytics-ready data platforms. Core areas of execution: • Design and development of dbt models (staging → intermediate → marts) • Snowflake-based data warehousing and performance-aware SQL modeling • End-to-end ELT workflows (ingestion → transformation → structured datasets) • Data quality testing, validation and documentation best practices • Git-based version control and structured delivery workflows Selected work includes: • A production-oriented dbt + Snowflake analytics platform • An end-to-end analytics pipeline (ingestion, transformation and reporting-ready datasets) Focused on reliability, reproducibility and production-minded data engineering.

Technical Consultant | Telecom & Data Automation

Famous Satellite Solutions

Feb 2016 - Dec 2019

3 years 11 months

Vila Nova de Gaia, Portugal

Founder & Technical Consultant with extensive experience in telecom infrastructure, automation and systems integration. Led technical operations in real-world environments, focusing on reliability, structured execution and system-level problem solving. Core areas of responsibility: • Automation workflows and system integrations • API integrations and relational database interactions • Structured data handling and reporting preparation • Operational troubleshooting in production environments • Implementation of least-privilege access and reproducible execution principles This role developed strong systems thinking, operational discipline and delivery accountability — foundations now applied directly to modern Data Engineering platforms.


Education

Tokio School

Big Data Specialist, Data Processing and Data Processing Technology/Technician

2024 - 2025

1 year 1 month

Big Data Engineer (Professional Program) focused on Python, SQL, data warehousing, ETL pipelines, and modern data stack practices.

Polytechnic Institute of Porto (ISEP)

Bachelor’s Degree, Computer Engineering (focus: Databases & Networks)

2010 - 2013

3 years 1 month

Tokio.

Big Data & Analytics Engineering


Licenses & certifications

Big Data

Issued: Aug 2025

Certified by Tokio School

Agile Explorer

Issued: Mar 2025

Certified by IBM

The best place to find your next move

© 2026. All Rights Reserved.