Raphael is available for hire
Hire RaphaelRaphael Carvalho
Verified Expert in Engineering
Data Analyst and Software Developer
Location
Belo Horizonte - State of Minas Gerais, Brazil
Toptal Member Since
July 26, 2022
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
XP Inc
Google Data Studio, Microsoft Power BI, Google BigQuery, Azure Databricks
Qconcursos
Tableau, Amplitude, Metabase, Google Analytics, Google Search Console...
Nubank
SQL, Tableau, Google Analytics, Python 3, Scala, Apache Airflow...
Experience
Availability
Full-time
Preferred Environment
Python 3, Tableau Desktop Pro, Google Analytics, Data Visualization, Redshift, APIs, SQL, MacOS, Amazon S3 (AWS S3), Google Sheets, Data Analytics, BigQuery, Snowflake
The most amazing...
...thing I've developed is a conversion monitoring system that enabled A/B tests, which increased the company's conversion rate by 20%.
Work Experience
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 Consultant
2022 - PRESENT
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 focused on improving the website conversion rate for new sign-ups.
- Developed a new customer acquisition framework that coordinated efforts from all funnel steps (awareness, consideration, and conversion) and sources (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 - PRESENT
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 was 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, 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=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).
Skills
Languages
Python 3, SQL, Python, Snowflake, R, Scala
Libraries/APIs
Facebook Marketing API, Instagram API, Twitter API, LinkedIn API, Google Sheets API, YouTube API
Tools
Tableau Desktop Pro, Google Analytics, Apache Airflow, Tableau, Google Optimize, Google Sheets, BigQuery, Microsoft Power BI
Paradigms
Business Intelligence (BI), ETL
Platforms
MacOS, Amazon Web Services (AWS), Docker
Storage
Redshift, Amazon S3 (AWS S3), PostgreSQL, Data Integration, MariaDB, MySQL
Other
TikTok API, Business, Marketing Mix, Strategy, Data Visualization, Data Analysis, Google BigQuery, Excel 365, Data Warehousing, Digital Marketing, Data Analytics, Reports, Business Logic, Dashboards, Reporting, 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
Frameworks
Spark
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