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

Pedro Roque

Verified Expert  in Engineering

Business Intelligence Analyst and Developer

Location
Belo Horizonte - State of Minas Gerais, Brazil
Toptal Member Since
March 3, 2022

Pedro is a problem solver and a passionate data person. Currently working at a data consulting company as an analytics engineer, he is in charge of creating data models and transformations using DBT and SQL, creating Python scripts to get data from APIs, web scraping, and orchestrating using Prefect. Pedro also has experience with reporting data, data visualization (Microsoft Power BI, Tableau, Looker), data engineering (Python, APIs), and data analysis (Snowflake, BigQuery, SQL-Server).

Data QueriesDAXData ModelingWeb ScrapingData VisualizationData ReportingData AnalysisBI ReportsData CleaningExcel ReportingData AnalyticsAnalyticsUser Interface (UI)Data EngineeringSQLPower AutomateDBT (Data Build Tool)

Portfolio

Fernandez Holdings, Inc
Microsoft Power BI, DAX, Power Query, SQL, Dashboards, ODBC, BI Reporting
GES Graphite, Inc.
Tableau, ETL, SQL, Data Analysis, Business Intelligence (BI), Sales Reports...
205 Data Lab
Python, Data Build Tool (dbt), Snowflake, Looker, APIs, SQL, Excel 365...

Experience

Data Modeling - 5 yearsExcel 365 - 5 yearsMicrosoft Power BI - 5 yearsSQL - 5 yearsData Transformation - 5 yearsData Preparation - 5 yearsDAX - 5 yearsPython - 3 years

Availability

Part-time

Preferred Environment

Microsoft Power BI, SQL, Data Build Tool (dbt), BI Reports

The most amazing...

...thing I've done is structure the BI area and all reports for each sector in the companies I have worked for.

Work Experience

Senior Power BI Developer

2023 - PRESENT
Fernandez Holdings, Inc
  • Created Power BI reports and dashboards for their clients.
  • Improved existing Power BI reports, including clean-up, optimization, and refactoring.
  • Created dataflows with multiple data sources to standardize data transformations.
Technologies: Microsoft Power BI, DAX, Power Query, SQL, Dashboards, ODBC, BI Reporting

Business Intelligence Expert

2022 - PRESENT
GES Graphite, Inc.
  • Comprehended and treated data sources from the CRM, including Sales, Financial, and Supply Chain Data.
  • Created dashboards and reports based on client needs using Tableau Desktop and Tableau Prep.
  • Provided support on the ETL side, using DataSelf and Tableau Prep.
Technologies: Tableau, ETL, SQL, Data Analysis, Business Intelligence (BI), Sales Reports, Sales, Microsoft SQL Server, SQL Server Management Studio (SSMS), Communication, Data Queries, Data Transformation, Data Preparation, Data Modeling, Data Visualization, Data Reporting, Dashboards, Reports, Data Analytics, Analytics, Data Warehousing, ELT, Reporting, BI Reports, Excel Reporting, Data Pipelines, Data, BI Reporting

Analytics Engineer

2021 - PRESENT
205 Data Lab
  • Created data pipelines using ELT and reverse ETL tools such as Census and Hightouch using a data build tool (dbt). Wrote transformation queries and used Git to do version control. Utilized Snowflake, BigQuery, and PostgresSQL as databases.
  • Built SQL data models in a data build tool (dbt) and advanced queries in Snowflake.
  • Web-scraped for multiple websites, including job boards and the clothing marketplace.
  • Developed integrations with some APIs to get scooter data.
  • Created data reports for the board and managers in tools like Tableau, and Power BI.
  • Built over 15 dashboards using Tableau, Power BI, and Looker.
Technologies: Python, Data Build Tool (dbt), Snowflake, Looker, APIs, SQL, Excel 365, Business Intelligence (BI), Dashboards, Data Analysis, Data Modeling, Data Preparation, Data Reporting, Data Visualization, ETL, Web Scraping, Data Transformation, REST APIs, Reports, Data Analytics, Analytics, Google Sheets, Data Engineering, Tableau, Microsoft SQL Server, SQL Server Management Studio (SSMS), Excel 2013, Microsoft Excel, Dimensional Modeling, MySQL, Reporting, BI Reports, CSV File Processing, Office 365, Excel 2016, ELT, Data Cleaning, Tableau Prep Flow, Communication, Google BigQuery, SharePoint, Data Queries, Web Services, Data Integration, Cloud, Data Warehousing, JSON, Git, PostgreSQL, Power Query, Excel Reporting, Data Pipelines, Pandas, API Integration, Data, LinkedIn API, ODBC, Google Docs, Google Sheets API, BI Reporting

Power BI Developer

2023 - 2023
Meridian Property Company
  • Created a Power BI report including budget, schedule, and med equipment.
  • Improved client's data structure and implemented new sources to control project schedule.
  • Supported the client with the Power BI implementation.
Technologies: Microsoft Power BI, Microsoft Excel, BI Reporting

Power BI Expert

2023 - 2023
Pnc Management, LLC
  • Created out-of-the-box reports with Power BI and Power BI paginated reports.
  • Developed data extraction from BigQuery and analyzed the data.
  • Exported report data to Microsoft SharePoint and delivered it daily.
Technologies: Microsoft Power BI, Google BigQuery, SharePoint, Data Pipelines, API Integration, Data, BI Reporting

Data Analyst

2022 - 2023
MagicLinks, Inc
  • Owned dashboard reporting and database maintenance using Tableau Desktop, Databricks, and PostgreSQL.
  • Prepared ad-hoc metrics at request using Databricks, Tableau Desktop, and Tableau Prep.
  • Developed data integrations using Python to pull data from REST APIs.
Technologies: Tableau, Tableau Server, Tableau Desktop Pro, SQL, Data Analytics, Business Intelligence (BI), Data Analysis, Communication, Databricks, Data Queries, Azure Databricks, Data Reporting, Dashboards, Reports, REST APIs, APIs, Analytics, Data Integration, Data Warehousing, JSON, Data Engineering, Google Sheets, ELT, Reporting, BI Reports, PostgreSQL, Excel Reporting, Google Analytics, Data Pipelines, Pandas, API Integration, Data, ODBC, Google Docs, Google Sheets API, BI Reporting

Power BI Specialist

2022 - 2022
Team Construction Management, Inc.
  • Developed paginated reports in Power BI paginated reports builder.
  • Optimized the process to build new paginated reports.
  • Provided data training based on client needs (Power BI Paginated Reports).
Technologies: Microsoft Power BI, Azure, Communication, Data Queries, Data Visualization, Data Reporting, Dashboards, Business Intelligence (BI), Data Analysis, Reports, Data Analytics, Analytics, Reporting, BI Reports, Power Query, Excel Reporting, Data Pipelines, Data, BI Reporting

Power BI Developer for Transportation Compliance Solution

2022 - 2022
CayCan Safety Consulting Ltd.
  • Provided PowerBI dashboard with accurate data and professional visuals.
  • Integrate Power BI with an external data source provider.
  • Provided feedback based on client needs to improve the data reporting process.
Technologies: Data Engineering, Microsoft Power BI, Dashboards, Data Visualization, Data Analytics, Data Analysis, Business Intelligence (BI), Communication, Data Queries, Data Transformation, Data Preparation, Data Modeling, ETL, Data Reporting, Reports, REST APIs, APIs, Analytics, Reporting, BI Reports, Excel Reporting, Data Pipelines, API Integration, Data, BI Reporting

Data Tech Lead

2020 - 2022
Take Blip
  • Created a dashboard to present customer success and operations results to the board.
  • Managed active contracts and the churn dashboard, which allowed the tracking of churn activities, their causes, and reasonings month after month.
  • Worked on the customer satisfaction dashboard, allowing the tracking of our NPS, CSAT, and other surveys.
  • Created customer portfolio management dashboards, which show patterns indicating which customers are more likely to churn, allowing the CSM team to take proactive actions.
  • Created data reports for the board and managers in tools like Tableau, and Power BI.
  • Build over 15 dashboards, including more than 30 KPIs using Tableau, and Power BI.
Technologies: SQL, Microsoft Power BI, Python, Excel 365, Business Intelligence (BI), Dashboards, Data Analysis, Databricks, Data Modeling, Data Preparation, Data Reporting, Data Visualization, DAX, ETL, Spreadsheets, Web Scraping, T-SQL (Transact-SQL), Data Transformation, REST APIs, Reports, Data Analytics, Analytics, Google Sheets, Microsoft SQL Server, SQL Server Management Studio (SSMS), Excel 2013, Microsoft Excel, Dimensional Modeling, MySQL, Reporting, BI Reports, CSV File Processing, Office 365, Excel 2016, ELT, Data Cleaning, Tableau Prep Flow, Tableau, Communication, SharePoint, Data Queries, APIs, Data Warehousing, JSON, Power Query, Excel Reporting, Data Pipelines, Pandas, API Integration, Data, ODBC, Google Docs, Google Sheets API, Azure Data Factory, BI Reporting

BI Analyst | Business Intelligence

2019 - 2020
Mercantil do Brasil
  • Created the management dashboard with the leading indicators of the sector.
  • Automated 15 reports using SQL and Power BI, reducing update time by 90%.
  • Developed the productivity dashboard for the team.
  • Built the tickets dashboard, which allows the root cause study to be carried out in an agile way.
Technologies: SQL, Microsoft Power BI, Python, Excel 365, Data Modeling, Data Transformation, Business Intelligence (BI), Data Analysis, Data Reporting, Spreadsheets, Web Scraping, ETL, Data Preparation, DAX, Dashboards, T-SQL (Transact-SQL), Data Visualization, Reports, Data Analytics, Analytics, Microsoft SQL Server, SQL Server Management Studio (SSMS), Excel 2013, Microsoft Excel, Dimensional Modeling, Reporting, BI Reports, CSV File Processing, Office 365, Excel 2016, Data Cleaning, Tableau, Communication, Data Queries, Power Query, Excel Reporting, Data Pipelines, Pandas, API Integration, Data, ODBC, Azure Data Factory, BI Reporting

BI Analyst | Business Intelligence

2018 - 2019
Accenture Brasil
  • Managed the dashboard to present the operation's results to the board.
  • Developed an application for decision-making in cases of tax change, reducing the average call handling time by 20%.
  • Reduced opportunity identification in the volume of calls opened by suppliers by 25%.
  • Developed automation capable of generating reports sent quarterly to several suppliers, reducing the activity time by 90% and providing final savings of 20 hours per month.
Technologies: Microsoft Power BI, SQL, Python, T-SQL (Transact-SQL), Dashboards, Business Intelligence (BI), Data Analysis, Data Reporting, Spreadsheets, Web Scraping, ETL, Data Preparation, DAX, Data Visualization, Reports, Data Analytics, Analytics, Microsoft SQL Server, SQL Server Management Studio (SSMS), Excel 2013, Microsoft Excel, Dimensional Modeling, Reporting, BI Reports, CSV File Processing, Excel 2016, Data Cleaning, Communication, Data Queries, Data Transformation, Data Modeling, Power Query, Visual Basic, Excel Reporting, Excel VBA, Visual Basic for Applications (VBA), Excel Macros, Data Pipelines, Pandas, Data, BI Reporting

Power BI Report for a Transportation Company

https://github.com/pedrohsroque/BI-Portfolio/tree/main/Transportation_Company
A Power BI report that contains information about truck inspections. The project was developed using Power BI and data from a forms system and deployed using Power BI service, using gateways to schedule refreshes.

Some information was obfuscated to remove sensitive data.

Personal LinkedIn Data Analysis

https://github.com/pedrohsroque/linkedin_dashboard
A small project using the data from LinkedIn. I used Power BI to transform, model, and visualize the data in this project.
KPIs.
- Number of connections.
- Number of certifications.
- Time experience.

End-to-end Data Pipeline

https://github.com/pedrohsroque/BI-Portfolio/tree/main/Agriculture_Company
An end-to-end project using data from three different data sources.
• Ingesting data using APIs and Python.
• Transforming data using Data Build Tool (dbt) over PostgreSQL (running on AWS).
• Reporting using Tableau.
• Orchestrating via Prefect.

Languages

SQL, Python, T-SQL (Transact-SQL), Snowflake, Visual Basic, Excel VBA, Visual Basic for Applications (VBA)

Libraries/APIs

REST APIs, Pandas, ODBC, Google Sheets API, LinkedIn API

Tools

Microsoft Power BI, Spreadsheets, Tableau, Google Sheets, Excel 2013, Microsoft Excel, Excel 2016, Power Query, Google Docs, Looker, Git, Tableau Desktop Pro, Google Analytics

Paradigms

ETL, Business Intelligence (BI), Dimensional Modeling, Database Development

Storage

JSON, Microsoft SQL Server, SQL Server Management Studio (SSMS), Data Pipelines, MySQL, Data Integration, PostgreSQL

Other

Excel 365, Data Queries, Data Transformation, Data Preparation, DAX, Data Modeling, Web Scraping, Data Visualization, Data Reporting, Dashboards, Data Analysis, Reports, Data Build Tool (dbt), APIs, Data Analytics, Analytics, Data Engineering, Reporting, Data-level Security, BI Reports, User Interface (UI), CSV File Processing, Office 365, Data Cleaning, Tableau Prep Flow, Excel Reporting, API Integration, Data, BI Reporting, ELT, Communication, Google BigQuery, Excel Macros, Development, Web Services, Command-line Interface (CLI), Confluent, Rivery, Data Warehousing, Cloud, Sales Reports, Sales, Tableau Server, Prefect, Relational Database Services (RDS), Azure Databricks, Azure Data Factory

Platforms

Databricks, Microsoft Power Automate, Apache Kafka, Azure, SharePoint, Amazon Web Services (AWS)

Frameworks

Streamlit

2015 - 2020

Bachelor's Degree in Electrical Engineering

Federal Center for Technological Education of Minas Gerais | CEFET-MG - Minas Gerasi, Brazil

JUNE 2022 - PRESENT

Hands On Essentials - Data Applications Builders Workshop

Snowflake

MAY 2022 - PRESENT

Hands On Essentials - Data Warehousing Workshop

Snowflake

APRIL 2022 - APRIL 2024

dbt Fundamentals

dbt

JULY 2021 - JULY 2022

Academy Accreditation - SQL Analyst Associate

Databricks

JULY 2021 - JULY 2022

Academy Accreditation - Databricks Lakehouse Platform Essentials

Databricks

OCTOBER 2019 - PRESENT

Introducing to Data Modeling for Power BI Video Course

SQL BI

SEPTEMBER 2019 - PRESENT

Introducing DAX Video Course

SQL BI

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