
Joaquin Amiel Marcora
Development
Prague, Czech Republic
Skills
Data Analysis
GCP (Google Cloud Platform)
Python
Pandas
Looker Studio
Power BI (Microsoft)
Microsoft Office Suite
SQL
BigQuery (Google)
Apache Airflow
About
Joaqun Amiel Marcora's skills align with System Developers and Analysts (Information and Communication Technology). Joaqun also has skills associated with Programmers (Information and Communication Technology). Joaqun Amiel Marcora has 7 years of work experience.
View more
Acomplishments
I did a complete clustering analysis for a bank client, considering the type of purchase, type of card usage, volume and frequency (using python, SQL, airflow and Power BI). From data ingestion data, data processing, create and tuning the model, and score clients in the following months, using an airflow pipeline and ingesting the scoring in SQL tables. Showing the results in a Power BI dashboard.
Working with a colleague, we finished a project which consist on read an Excel file with information of one hospital, and though a ETL process we develop a dashboard with a report which measure some key performance indicators and compare this with the expected values. This project added value for the company, because they couldn’t deal properly with 46 Excel files with between 10 and 12 sheets each one from different hospitals.
Work Experience
PRINCIPAL ONLINE MARKETING DATA SPECIALIST
Gen Digital
September 2023 - Present
- Skills: Python, GCP, BigQuery, MS Office, Power BI
- - Work with the marketing team to identify areas for automation within the user acquisition process (reports in power bi using data.ai api, GCP information and data from the cube).
- - Semi-Automate the weekly installs forecast in Excel using data from the cube, GCP, and Google ads saving an estimate of 20 working hours per week.
LEAD DATA ANALYST
Carma project
October 2022 - February 2024
- Airflow, Python, R, GCP, BigQuery, postgres, Github, Looker Studio, Metabase, MS Office.
- - Automate process using public data (Geographic) and data from DWH (Postgres) through pipelines in the cloud (Airflow - GCP) to make dashboards (Looker Studio, Metabase) and ad hoc analysis. Streamlined client presentations, reducing the preparation time by over 75% and eliminating associated errors. Successfully deployed a RF regression on GCP to predict how many cars can the company tag per zip code.
ATTRIBUTION DATA SCIENTIST
Entain, Gambling Facilities and Casinos
December 2020 - October 2022
- Implementation of acquisition and retention ML models with DDA. Automated campaign optimization by integrating acquisition model outputs. Implementation of MMM to measure impact of offline channels on deposits. Leveraged data from GA, Fivetran and Appsflyer to build marketing dashboards (using CPM, CPC, CAC, ROAS), automating the production of tables, views and email alerts. Developed an A/B testing algorithm using t-test methods.
DATA SCIENTIST
N5 Now, Fintech
February 2019 - July 2020
- Implementation of Churn, LTV and Clusterization model, storing the results in SQL tables and dashboards. Lead the development of analytics modules through designing wireframes, coding functions and making features/ user stories. Defined how to optimize a marketing campaign, developing a functional POC. Implemented an algorithm based on t-test to establish the control group size in marketing campaigns (UCG, CG, JCG). Mentored and supervised an intern, ensuring successful performance.
BUSINESS INTELLIGENCE CONSULTANT
Adagio
April 2017 - January 2019
- Created SQL-powered dashboards to illustrate performance metrics. Automated ETL processes for data extraction from XLS files. Produced KPIs to analyze and report on hospital operations. Universidad de Montevideo, Education | Uruguay PROFESSOR: PROBABILITY AND STATISTICS | 3/2015 - 9/2016 | 1yr 7 mos Do the program, the approval requirements, the presentations (PPT of the theoretical classes), the exercises and the class dictation with a good performance ratify with a contract extension.