Summary
Overview
Work history
Education
Skills
Languages
Timeline
Hi, I’m

Joao Pimenta

Lisboa,PL
Joao Pimenta

Summary

Joao is currently working in Farfetch’s Marketing department as a Senior Data Engineer.

Supporting Marketing reports evolving automation and migration of data ensuring its quality and completeness (tools used described throughout the CV).
Earlier in his career, the passion for data analysis and transformation made him join the IT consultancy firm FDM receiving SQL and data analysis training. Worked with clients such as Barclays IB and Wonga, allowing him to work in projects involving analysing credit risk and migration of financial products to a centralised Hadoop database. Seasoned Database Administrator with [Number] years of extensive experience designing, coding and testing database solutions in [Type] and [Type] environments. Proficient in working with diverse technologies such as [Type] and [Type]. Motivated to stay informed of latest industry innovations to provide users with most up-to-date solutions. Detail-oriented [Job Title] with significant experience in [Type] and [Type] databases. Offering progressive career history with expertise in technical troubleshooting and maintaining [Type] and [Type] systems.

Overview

8
years of professional experience
4
years of post-secondary education

Work history

Farfetch
Lisboa, Lisboa

Senior Data Engineer
07.2018 - Current

Job overview

  • Owning Digital Marketing Performance Reporting. This involved displaying KPIs such as number of transactions, Transaction Value, app instals, among other metrics attributed to Digital Marketing Campaigns based on a Last Click Model which would attribute a sale based on the last non-direct click within the last 30 days.


  • Owning and maintaining Marketing Costs Data using Third party tool Funnel.


  • Requesting and normalising data from a third party API in order to get Farfetch performance in Apple Store and Google Pay compared to its competitors. KPIs such as app ranking, app rating per country or device platform.


  • Leading data transformation and reporting as a consequence of Privacy changes in Facebook AMM and Apple IDFA

Barclays Investment Bank
London, Canary Wharf

Data Engineer
09.2016 - 07.2018

Job overview

  • Coordinate ETL implementation of a strategic svot of cross asset trade products data based on Hadoop HBase.
    Coordinate process of prioritisation and execution of data reports.


  • Manage different projects of data migration from different sources to our database.


  • Test data on transition
    from Schema-On-Read to Schema-On-Write.


  • Answering to ad-hoc queries for regulatory and internal projects


  • Investigations on missing data and data quality.


  • Manage team’s Kanban board.

Wonga
London, London

Data Analyst
10.2015 - 09.2016

Job overview

Data analysis to optimise decision efficiency on Wonga’s short term loan products. Analysing client’s
credit score to refine the acceptance rules.

Education

Goldsmiths University of London
London

from Programming using Python
04.2018 - 05.2018

University overview

FDM IT Consulting
London

from Data Analysis Foundations
07.2015 - 09.2015

University overview

ISEG - School of Economics and Management
Lisboa

Bachelor of Business Administration from Management
09.2009 - 03.2013

University overview

Skills

  • DBT
  • SQL
  • Python
  • Looker
  • Google Cloud ( Airflow integrated in GCP, Bigquery)


Languages

English
Fluent
Portuguese
Native
Spanish
Intermediate

Timeline

Senior Data Engineer
Farfetch
07.2018 - Current
Goldsmiths University of London
from Programming using Python
04.2018 - 05.2018
Data Engineer
Barclays Investment Bank
09.2016 - 07.2018
Data Analyst
Wonga
10.2015 - 09.2016
FDM IT Consulting
from Data Analysis Foundations
07.2015 - 09.2015
ISEG - School of Economics and Management
Bachelor of Business Administration from Management
09.2009 - 03.2013
Joao Pimenta