Raphael is available for hire
Hire RaphaelRaphael Carvalho
Verified Expert in Engineering
Data Analyst and Software Developer
Belo Horizonte - State of Minas Gerais, Brazil
Toptal member since July 26, 2022
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
Forbes LLC - Main
SQL, Looker Studio, Google BigQuery, Business Intelligence (BI)...
Relay Insights LLC
Google BigQuery, Looker Studio, BigQuery, Google Analytics 4 (GA4)...
Insight Factory, LLC
Funnel Analysis, Business Intelligence (BI), BigQuery, Google Analytics...
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 (GA4) - 3 years
Preferred Environment
Python 3, Tableau Desktop Pro, APIs, SQL, Data Analytics, BigQuery, Google Cloud Platform (GCP), Google Analytics 4 (GA4), 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
Senior Data Analyst
2025 - PRESENT
Forbes LLC - Main
- Was the main BI focal point for Forbes Membership and Forbes Vetted.
- Developed new LookML datasets and Looker dashboards.
- Created and maintained new datasets to solve for membership and vetted business questions.
Technologies: SQL, Looker Studio, Google BigQuery, Business Intelligence (BI), Google Analytics 4 (GA4), Looker, Looker Modeling Language (LookML)
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 (GA4), 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 Ads
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 (GA4)
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 (GA4)
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 (GA4)
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 (GA4)
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 (GA4)
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=sharingA 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_dataThe 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.
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_RThe 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, Looker Modeling Language (LookML)
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 (GA4), 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 Ads
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