Raphael is available for hire

Raphael 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是一位经验丰富的数据和业务分析师，专门从事仪表板创建, data storytelling, and web analytics. 他的工作帮助公司了解他们的主要增长杠杆，并通过A/B测试和渠道开发提高他们的转化率和受众. Raphael是一位以商业为导向的专业人士，通过数据分析产生商业价值. 他在小型团队和空白画布项目中工作得很好，这些项目需要高度的抽象和创造力.

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

Portfolio

Oberst BV

数据仓库，谷歌BigQuery，谷歌分析，创业公司...

XP Inc

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

Zoetis - Main

业务策略，业务分析，SQL, Azure, Tableau，统计建模...

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...

...我从头开始开发了一个云数据仓库，它结合了来自多个数据源的数据, 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.
开发了许多供业务用户使用的数据工具, such as automated dashboards, spreadsheets, email reports, etc.
Developed ad hoc analysis, 比如提高网站在搜索引擎上的点击率和SERP排名, improving on-page merchant CTR, etc.

Technologies: 数据仓库，谷歌BigQuery，谷歌分析，创业公司, Google Search Console, Google Cloud Platform (GCP), APIs, Plausible, AccuRanker, Management

Analytics Senior Lead

2022 - PRESENT

XP Inc

负责股票研究内容平台.
为所有内容平台制定SEO诊断和行动计划.
为所有内容平台开发KPI监控系统.

技术:Google Data Studio, Microsoft Power BI, Google BigQuery, Azure Databricks

Business Analyst

2022 - 2023

Zoetis - Main

开发了一个自动电子邮件报告系统，作为竞选活动绩效讨论的基础.
执行特别分析，如过去的活动表现和NPS调查分析.
为电子邮件营销活动提供客户目标列表.

Technologies: 业务策略，业务分析，SQL, Azure, Tableau，统计建模, Business Intelligence (BI), Azure Databricks, Azure Blob Storage API

Business Consultant

2022 - 2023

Qconcursos

咨询，寻找机会，提高公司的业绩，在获取客户和制定行动计划的团队进行测试, learn, and scale based on findings.
设计了大量的A/B测试，以提高网站的新注册转化率.
开发一个新的客户获取框架，协调所有渠道步骤的努力, 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

开发了一个系统，可以自动从Facebook上的所有Nubank出版物中提取数据, Instagram, LinkedIn, TikTok, Twitter, and YouTube, 使用Python构建，并由运行在AWS EC2机器上的Apache气流编排.
监督和指导Nubank的博客团队，使博客读者同比增长25%, focusing on SEO improvements, paid media optimization, and email marketing.
监督Nubank的全国品牌活动，该活动使用了大量的线上和线下渠道, 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

管理一个数据分析师团队，提供每两周和每月的业务绩效报告, developed ad-hoc analysis and queries, built and maintained managerial and executive dashboards, and helped departments define and monitor KPIs.
监督自助数据平台的创建，该平台为全公司40多名员工提供服务. 它使员工可以根据需要请求自定义和预定义的报告，而无需向数据团队提交申请.
理想化并执行了许多专注于企业对企业客户获取的A/B测试.

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%.
为公司不同部门的多个数据项目提供重要服务, such as marketing, sales, customer service, management, product and growth, and strategy, 并深入参与了Sympla官方kpi的定义.
管理有65个Tableau用户的Tableau实现，并监督1300个仪表板的环境.

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

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

样本数据分析侧重于评估社区平台与Nubank业务的相关性，并分析信用卡调查的结果. 这个项目是建立在虚拟数据之上的，结论是基于这个模拟数据得出的.

FOREX Data Pipeline

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

该项目包括一个数据管道，从IQ Option的API中提取外汇数据，并将其存储在Amazon Redshift中，以进行进一步的预测分析.

其目的是在每个货币对中建立二元预测模型，以协助交易者进行谈判.

Finding the Best Linear Regression Model in R

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

该项目旨在为每个数据集找到最佳的线性回归模型. 它接收了一个数据集，并模拟了所有可能的回归模型组合. 该函数对最显著的变量进行排序和选择, generated all the possible model combinations, 并返回赤池信息准则(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, 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

Paradigms

商业智能(BI)， ETL，管理，数据科学

Platforms

MacOS、亚马逊网络服务(AWS)、Docker、Azure、谷歌云平台(GCP)

Storage

Redshift, Amazon 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, 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, Plausible, AccuRanker, Microsoft Azure

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

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring