Raphael is available for hire

Raphael Carvalho

Verified Expert in Engineering

Data Analyst and Software Developer

Belo Horizonte - State of Minas Gerais, Brazil

Toptal member since July 26, 2022

Expertise

Data Cleaning Dashboards Data Visualization Data Analysis Data Analytics Data Warehousing Amazon RDS Pandas NumPy SQL Tableau Business Intelligence (BI)Google Sheets Python 3 Google Sheets API LinkedIn API

Bio

Raphael is a seasoned data and business analyst specializing in dashboard creation, data storytelling, and web analytics. His work has helped companies understand their major growth levers and improve their conversion rate and audience through A/B testing and channel development. Raphael is a business-oriented professional and generates business value through data analysis. He works well in small teams and on blank canvas projects where a high level of abstraction and creativity is needed.

Portfolio

Oberst BV

Data Warehousing, Google BigQuery, Google Analytics, Startups...

XP Inc

Google Data Studio, Microsoft Power BI, Google BigQuery, Azure Databricks

Zoetis - Main

Business Strategy, Business Analysis, SQL, Azure, Tableau, Statistical Modeling...

Experience

SQL - 7 years Tableau Desktop Pro - 7 years Python 3 - 6 years Google Analytics - 4 years Facebook Marketing API - 3 years APIs - 3 years Apache Airflow - 2 years Google Search Console - 2 years

Availability

Part-time

Preferred Environment

Python 3, Tableau Desktop Pro, APIs, SQL, Amazon S3 (AWS S3), Data Analytics, BigQuery, Microsoft Power BI, Google Cloud Platform (GCP), Microsoft Azure

The most amazing...

...thing I've developed is a cloud data warehouse from scratch that combines data from multiple sources, such as the main database and third-party APIs.

Work Experience

Data Warehouse Developer

2022 - PRESENT

Oberst BV

Built a data warehouse from scratch, consuming data from different data sources, like the company database and 3rd-party software APIs, such as Accuranker, Plausible, and WeCanTrack.
Developed numerous data tools to be consumed by business users, such as automated dashboards, spreadsheets, email reports, etc.
Developed ad hoc analysis, such as improving the website's CTR and SERP position on search engines, improving on-page merchant CTR, etc.

Technologies: Data Warehousing, Google BigQuery, Google Analytics, Startups, Google Search Console, Google Cloud Platform (GCP), APIs, Plausible, AccuRanker, Management

Analytics Senior Lead

2022 - PRESENT

XP Inc

Took responsibility for equity research content platforms.
Developed SEO diagnosis and action plans for all content platforms.
Developed KPI monitoring systems for all content platforms.

Technologies: Google Data Studio, Microsoft Power BI, Google BigQuery, Azure Databricks

Business Analyst

2022 - 2023

Zoetis - Main

Developed an automated email reporting system that served as a basis for campaign performance discussions.
Performed ad hoc analysis such as past campaign performance and NPS survey analysis.
Delivered customer targeting lists for email marketing campaigns.

Technologies: Business Strategy, Business Analysis, SQL, Azure, Tableau, Statistical Modeling, Business Intelligence (BI), Azure Databricks, Azure Blob Storage API

Business Consultant

2022 - 2023

Qconcursos

Consulted to find opportunities that increased the company's performance in terms of customer acquisition and developed action plans for the team to test, learn, and scale based on findings.
Designed numerous A/B tests to improve the website conversion rate for new sign-ups.
Developed a new customer acquisition framework that coordinated efforts from all funnel steps, awareness, consideration, conversion, and sources, both organic and inorganic.

Technologies: Tableau, Amplitude, Metabase, Google Analytics, Google Search Console, Business Intelligence (BI), Data Visualization, Data Analysis, Google BigQuery, Strategy, Operations, Marketing Mix, Business, APIs, SQL, Microsoft Power BI, Google Data Studio, MacOS, Amazon S3 (AWS S3), Excel 365, Google Sheets API, Google Sheets, Data Warehousing, Python, PostgreSQL, Tableau Desktop Pro, Digital Marketing, Google SEO, Data Analytics, Reports, Business Logic

Senior Business Analyst

2021 - 2022

Nubank

Developed a system that automatically extracts data from all Nubank's publications across Facebook, Instagram, LinkedIn, TikTok, Twitter, and YouTube, built using Python and orchestrated by Apache Airflow running on an AWS EC2 machine.
Oversaw and guided Nubank's blog team to increase the blog audience by 25% year-over-year, focusing on SEO improvements, paid media optimization, and email marketing.
Supervised Nubank's national brand campaign that used a vast mix of online and offline channels, measuring the short-term impacts on the website, blog, and social media.

Technologies: SQL, Tableau, Google Analytics, Python 3, Scala, Apache Airflow, Business Intelligence (BI), Data Visualization, Data Analysis, Google BigQuery, Strategy, Operations, Finance, Marketing Mix, Business, Big Data, Amazon Web Services (AWS), APIs, LinkedIn API, X (formerly Twitter) API, YouTube API, TikTok API, Instagram API, Facebook Marketing API, Spark, Google Data Studio, MacOS, Big Data Architecture, Data Engineering, Amazon S3 (AWS S3), Excel 365, Google Sheets API, Google Sheets, Data Warehousing, ETL, Data Integration, Python, PostgreSQL, Tableau Desktop Pro, Digital Marketing, Google SEO, Data Analytics, Reports, BigQuery, Business Logic

Data Analytics Manager

2020 - 2021

Sympla

Managed a team of data analysts that provided bi-weekly and monthly business performance reports, developed ad-hoc analysis and queries, built and maintained managerial and executive dashboards, and helped departments define and monitor KPIs.
Oversaw the creation of a self-service data platform that served more than 40 employees across the company. It made it possible for employees to request custom and pre-defined reports on demand without submitting a ticket to the data team.
Idealized and executed many A/B tests focused on business-to-business customer acquisition.

Technologies: Python 3, R, Tableau, Google Analytics, Business Intelligence (BI), Data Visualization, Data Analysis, Google BigQuery, Redshift, Strategy, Operations, Finance, Human Resources (HR), Marketing Mix, Business, Big Data, Amazon Web Services (AWS), Google Optimize, APIs, SQL, Microsoft Power BI, Google Data Studio, MacOS, Big Data Architecture, Data Engineering, Amazon S3 (AWS S3), Excel 365, Google Sheets API, Google Sheets, Data Warehousing, ETL, Data Integration, Python, PostgreSQL, Tableau Desktop Pro, Digital Marketing, Google SEO, Data Analytics, Reports, BigQuery, MariaDB, MySQL, Business Logic

Senior Data Analyst

2016 - 2020

Sympla

Implemented conversion data points and developed a measuring model based on sessions that map every step of the purchase funnel; through this model, A/B tests were developed, improving the conversion rate by 20%.
Provided vital services to several data projects inside different departments of the company, such as marketing, sales, customer service, management, product and growth, and strategy, and was deeply involved in defining Sympla's official KPIs.
Managed the Tableau implementation with 65 Tableau users and oversaw the environment of 1300 dashboards.

Technologies: Tableau, SQL, Google Analytics, Python 3, R, Business Intelligence (BI), Data Visualization, Data Analysis, Google BigQuery, Redshift, Strategy, Operations, Finance, Human Resources (HR), Marketing Mix, Business, Big Data, Amazon Web Services (AWS), Google Optimize, APIs, Microsoft Power BI, Google Data Studio, MacOS, Big Data Architecture, Data Engineering, Amazon S3 (AWS S3), Excel 365, Google Sheets API, Google Sheets, Data Warehousing, ETL, Data Integration, Python, PostgreSQL, Tableau Desktop Pro, Digital Marketing, Google SEO, Data Analytics, Reports, BigQuery, MariaDB, MySQL, Business Logic

Experience

Data Analysis Sample

https://drive.google.com/file/d/1mlWEI-WdKrnhl2JsK6lIfKxNCoSTUFJM/view?usp=sharing

A sample data analysis focused on evaluating a community platform's relevance to Nubank's business and analyzing results from a credit card survey. The project was built upon dummy data, and the conclusions were based on this mock data.

FOREX Data Pipeline

https://github.com/rapha-carvalho/forex_data

The project consisted of a data pipeline that extracted foreign exchange data from IQ Option's API and stored it in Amazon Redshift for further predictive analysis.

The objective was to develop binary predictive models in each currency pair to assist traders in their negotiations.

Finding the Best Linear Regression Model in R

https://github.com/rapha-carvalho/regressor_utils_R

The project aimed to find the best linear regression model for each dataset. It received a dataset and simulated every possible combination of regression models. The function ranked and selected the most significant variables, generated all the possible model combinations, and returned the model with the lowest Akaike information criterion (AIC).

Education

2021 - 2021

Specialization in Data Engineering

Udacity - Remote

2019 - 2021

Specialization in Big Data

ESPM - São Paulo, São Paulo

2015 - 2018

Bachelor's Degree in Business Administration

IBMEC - Belo Horizonte, Brazil

Certifications

APRIL 2022 - PRESENT

Tableau Desktop Specialist

Tableau

Skills

Libraries/APIs

Facebook Marketing API, Instagram API, TikTok API, X (formerly Twitter) API, LinkedIn API, Google Sheets API, Pandas, NumPy, YouTube API, Azure Blob Storage API

Tools

Tableau Desktop Pro, Google Analytics, Apache Airflow, Tableau, Google Optimize, Google Sheets, BigQuery, Microsoft Power BI

Languages

Python 3, SQL, Python, Snowflake, R, Scala

Paradigms

Business Intelligence (BI), ETL, Management

Platforms

MacOS, Amazon Web Services (AWS), Docker, Azure, Google Cloud Platform (GCP), Plausible

Storage

Redshift, Amazon S3 (AWS S3), PostgreSQL, Data Integration, MariaDB, MySQL

Frameworks

Spark

Other

Business, Marketing Mix, Strategy, Data Visualization, Data Analysis, Google BigQuery, Excel 365, Data Warehousing, Digital Marketing, Data Analytics, Reports, Business Logic, Dashboards, Reporting, Amazon RDS, Data Cleaning, Data Aggregation, Google Data Studio, Google Search Console, APIs, Big Data, Big Data Architecture, Data Engineering, Human Resources (HR), Logistics, Finance, Operations, Google SEO, Amplitude, Metabase, Azure Databricks, Business Strategy, Business Analysis, Statistical Modeling, Startups, AccuRanker, Microsoft Azure, Data Science

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring