
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
Languages
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.
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
Agile Explorer
Issued: Mar 2025