Raphael Carvalho, Developer in Belo Horizonte - State of Minas Gerais, Brazil
Raphael is available for hire
Hire Raphael

Raphael Carvalho

Verified Expert  in Engineering

Bio

Raphael is a data consultant with 10+ years of experience helping companies extract insights and drive strategy through data. He's worked with Brazil's top fintech firms like Nubank and XP Inc., and is now an analyst and consultant with international clients in the US and Europe. His expertise spans GA4 and BigQuery for web analytics, behavioral insights, and attribution modeling; data warehousing, ensuring reliable and scalable data pipelines; and custom dashboards (Looker Studio and Tableau).

Portfolio

Relay Insights LLC
Google BigQuery, Looker Studio, BigQuery, Google Analytics 4, Google Analytics...
Insight Factory, LLC
Funnel Analysis, Business Intelligence (BI), BigQuery, Google Analytics...
Natural Lifestyle Brands LLC
Data Engineering, Google BigQuery, Python, ETL, SQL...

Experience

  • Tableau Desktop Pro - 9 years
  • Python 3 - 9 years
  • SQL - 9 years
  • APIs - 7 years
  • Facebook Marketing API - 5 years
  • Google Search Console - 5 years
  • Google Data Studio - 5 years
  • Google Analytics 4 - 3 years

Availability

Full-time

Preferred Environment

Python 3, Tableau Desktop Pro, APIs, SQL, Data Analytics, BigQuery, Google Cloud Platform (GCP), Google Analytics 4, Google Analytics API

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 3rd-party APIs.

Work Experience

BigQuery Data Engineer

2025 - PRESENT
Relay Insights LLC
  • Developed custom queries on GA4 BigQuery Export to extract insights from Google Analytics 4 data.
  • Set up the GA4 BigQuery Export for new GA properties.
  • Conducted teach-in sessions to help end users query GA4 data on BigQuery.
Technologies: Google BigQuery, Looker Studio, BigQuery, Google Analytics 4, Google Analytics, Google Cloud Platform (GCP)

Business Data Analyst

2024 - PRESENT
Insight Factory, LLC
  • Developed custom queries on GA4 BigQuery Export data to evaluate internal traffic and engagement, sales funnel, and internal search.
  • Conducted ad-hoc analyses to evaluate the effectiveness of the sales funnel and campaign performance (Search and Google Shopping).
  • Developed BigQuery-connected Google Spreadsheet solutions that automatically pull data from BigQuery to the spreadsheet for further analysis.
Technologies: Funnel Analysis, Business Intelligence (BI), BigQuery, Google Analytics, Google BigQuery, Sales Funnel, Funnel Marketing, Funnel Optimization, User Journeys, User Journey Maps, Know Your Customer (KYC), Google Shopping

Data Engineer

2024 - PRESENT
Natural Lifestyle Brands LLC
  • Developed a data warehousing solution in BigQuery using Google Cloud Functions to integrate data from TikTok Affiliates, Hubspot CRM, and Google Spreadsheet reports.
  • Built Looker Studio dashboards to monitor affiliate performance and company sales through the affiliate program.
  • Developed custom campaign analysis to report on affiliate adhesion and engagement on monthly campaigns.
Technologies: Data Engineering, Google BigQuery, Python, ETL, SQL, Google Cloud Platform (GCP), BigQuery, APIs, Dashboards, Data Analysis

Data Analyst

2023 - PRESENT
Nova Flex Led, LLC
  • Developed and maintained Tableau dashboards to analyze and report on company sales.
  • Integrated sales data via API (Opportunity, Quotes, and Orders) from Salesforce to create a dataset to report on sales data.
  • Conducted ad-hoc analyses to evaluate the effectiveness of the customer acquisition funnel.
Technologies: Python, Data Analysis, Data Visualization, Reporting, Salesforce

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, API Integration, Looker Studio, Google Analytics API, Google Analytics 4

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, API Integration, Looker Studio, Google Analytics API, Google Analytics 4

Data Analyst

2024 - 2025
Realm Living Inc
  • Built dozens of Looker dashboards to support company growth and enhance operational reporting.
  • Conducted ad-hoc analyses to evaluate the effectiveness of the customer acquisition funnel.
  • Created analytical tables on Amazon Athena to power Looker dashboards and support ad-hoc business insights.
Technologies: Looker, Google Data Studio, SQL, Python, Data Analysis, Data Visualization, Amazon Athena

Data Analyst

2023 - 2024
Restor3D, Inc.
  • Developed a LookerStudio dashboard to evaluate and report on the company's operational effectiveness.
  • Integrated data from Monday.com and internal operational tables to create BigQuery tables that support ad hoc analysis and dashboards.
  • Conducted ad-hoc analyses to evaluate the effectiveness of the design and manufacturing process of 3D parts.
Technologies: Microsoft Power BI, Data Analysis, Data Engineering, BI Reporting, Data Visualization, ETL

Data Analyst

2023 - 2023
Uncommon Entertainment LLC
  • Integrated data from the GeekSeat API into BigQuery to support dashboard creation.
  • Developed a LookerStudio dashboard to monitor pricing on US events.
  • Conducted ad-hoc analyses to evaluate pricing fluctuation throughout the event sales cycle.
Technologies: Data Visualization, Data Engineering, ETL, REST APIs, Google Data Studio, BigQuery, Google BigQuery

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, Looker Studio, Google Analytics 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, API Integration, Looker Studio, Google Analytics API, Google Analytics 4

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, API Integration, Looker Studio, Google Analytics API, Google Analytics 4

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, Looker Studio, Google Analytics API, Google Analytics 4

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, API Integration, Looker Studio, Google Analytics API

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, Google Analytics API, YouTube API, REST APIs, Azure Blob Storage API

Tools

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

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, Salesforce

Storage

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

Frameworks

Spark

Other

Google Data Studio, 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, API Integration, Looker Studio, Google Analytics 4, BI Reporting, Funnel Analysis, Sales Funnel, Funnel Marketing, Funnel Optimization, User Journeys, User Journey Maps, Google Search Console, APIs, Big Data, Big Data Architecture, Data Engineering, Human Resources (HR), Logistics, Finance, Operations, Google SEO, Know Your Customer (KYC), Amplitude, Metabase, Azure Databricks, Business Strategy, Business Analysis, Statistical Modeling, Startups, AccuRanker, Microsoft Azure, Data Science, Google Shopping

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.

1

Share your needs

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

Choose your talent

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

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