Pedro is available for hire
Hire PedroPedro Roque
Verified Expert in Engineering
Business Intelligence Analyst and Developer
Belo Horizonte - State of Minas Gerais, Brazil
Toptal member since March 3, 2022
Bio
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).
Portfolio
BCG - X
Microsoft Power BI, Business Intelligence (BI), Data Visualization, DAX...
Fernandez Holdings, Inc
Microsoft Power BI, DAX, Power Query, SQL, Dashboards, ODBC, BI Reporting, Git...
GES Graphite, Inc.
Tableau, ETL, SQL, Data Analysis, Business Intelligence (BI), Sales Reports...
Experience
- Microsoft Power BI - 7 years
- Excel 365 - 5 years
- Data Transformation - 5 years
- SQL - 5 years
- DAX - 5 years
- Data Modeling - 5 years
- Data Preparation - 5 years
- Python - 3 years
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
Power BI Expert
2026 - PRESENT
BCG - X
- Designed and developed high-quality, visually appealing Power BI dashboards and reports.
- Translated business requirements into effective data models and visualizations.
- Optimized data queries and performance within Power BI.
- Collaborated with stakeholders to iterate on dashboard design and functionality.
- Ensured consistency in design, usability, and data accuracy across reports.
- Provided recommendations to improve reporting structure and user experience.
- Maintained and enhanced existing dashboards as needed.
Technologies: Microsoft Power BI, Business Intelligence (BI), Data Visualization, DAX, Power Query, Data Analysis, Power Query M, Data Build Tool (dbt), Databricks, Azure Databricks
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, Git, GitHub, Azure DevOps, Azure, Architecture, Microsoft, Business Analysis, PostgreSQL, Power BI Desktop, Power BI Report Server, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
Business Intelligence Expert
2022 - 2026
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, Git, Tableau Desktop, Amazon Web Services (AWS), Amazon S3 (AWS S3), AWS Lambda, GitHub, Architecture, Business Analysis, PostgreSQL, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
Analytics Engineer
2021 - 2024
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 PostgreSQL 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, Fivetran, Apache Airflow, Tableau Desktop, Amazon Web Services (AWS), Amazon S3 (AWS S3), dbt Cloud, Hex, RudderStack, Prefect, AWS Lambda, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M
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, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, Tableau Desktop, Amazon Web Services (AWS), GitHub, Architecture, Business Analysis, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Power BI Report Server, Key Performance Indicators (KPIs), Trend Analysis, Power Query M
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, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, Transact-SQL (T-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 (ADF), BI Reporting, Fivetran, GitHub, Architecture, Microsoft, Business Analysis, Power BI Desktop, Business, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, Transact-SQL (T-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 (ADF), BI Reporting, Fivetran, Azure DevOps, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
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, Transact-SQL (T-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, Fivetran, Architecture, Microsoft, Business Analysis, Power BI Desktop, Key Performance Indicators (KPIs), Trend Analysis, Power Query M, RESTFul APIs
Experience
Power BI Report for a Transportation Company
https://github.com/pedrohsroque/BI-Portfolio/tree/main/Transportation_CompanyA 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.
Some information was obfuscated to remove sensitive data.
Personal LinkedIn Data Analysis
https://github.com/pedrohsroque/linkedin_dashboardA 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.
KPIs.
- Number of connections.
- Number of certifications.
- Time experience.
End-to-end Data Pipeline
https://github.com/pedrohsroque/BI-Portfolio/tree/main/Agriculture_CompanyAn 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.
• Ingesting data using APIs and Python.
• Transforming data using Data Build Tool (dbt) over PostgreSQL (running on AWS).
• Reporting using Tableau.
• Orchestrating via Prefect.
Education
2015 - 2020
Bachelor's Degree in Electrical Engineering
Federal Center for Technological Education of Minas Gerais | CEFET-MG - Minas Gerasi, Brazil
Certifications
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
Skills
Libraries/APIs
REST APIs, Pandas, ODBC, Google Sheets API, LinkedIn API
Tools
Microsoft Power BI, Spreadsheets, Tableau, Git, Google Sheets, Excel 2013, Microsoft Excel, Excel 2016, Tableau Prep Flow, Power Query, Google Docs, Tableau Desktop, dbt Cloud, GitHub, Power BI Desktop, Power BI Report Server, Prefect, Looker, Tableau Desktop Pro, Google Analytics, Apache Airflow
Languages
SQL, Python, Transact-SQL (T-SQL), Power Query M, Snowflake, Visual Basic, Excel VBA, Visual Basic for Applications (VBA)
Paradigms
ETL, Business Intelligence (BI), Dimensional Modeling, Azure DevOps, Database Development
Platforms
Microsoft, Databricks, Microsoft Power Automate, Azure, Amazon Web Services (AWS), Hex, RudderStack, AWS Lambda, Confluent, Apache Kafka, SharePoint
Storage
JSON, Microsoft SQL Server, SQL Server Management Studio (SSMS), Data Pipelines, MySQL, PostgreSQL, Amazon S3 (AWS S3), Data Integration
Frameworks
Streamlit
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, Excel Reporting, API Integration, Data, BI Reporting, Architecture, Business Analysis, Business, Key Performance Indicators (KPIs), Trend Analysis, RESTFul APIs, ELT, Communication, Google BigQuery, Excel Macros, Fivetran, Development, Web Services, Command-line Interface (CLI), Rivery, Data Warehousing, Cloud, Sales Reports, Sales, Tableau Server, Relational Database Services (RDS), Azure Databricks, Azure Data Factory (ADF)
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