William E.

Data Analyst

Data Analyst
6/1/2022 - Present

Developed proficiency in creating ETL pipelines in Snowflake using SQL, significantly enhancing the efficiency and security of data handling processes. Managed and maintained dashboards on a regional level in Power BI and Tableau, supplying critical information for strategic decision-making. Optimized DataFlows in Power BI, facilitating agile and precise data analysis with updates completed in under 30 minutes. Standardized processes through comprehensive documentation of dashboards, improving information sharing. Supported the commercial team with data analysis that informed better sales strategies and negotiations. Created reports to detect discrepancies by evaluating price elasticity. Conducted research for both internal and external clients, delivering insightful presentations on the findings. Automated and maintained the weekly delivery of raw data using Python, reducing errors and ensuring data accuracy.

Data Analyst Intern
5/1/2021 - 5/1/2022

Supported the extraction of market insights through SQL, applying KPI trees and the GE matrix to enhance decision-making. Utilized SQL to extract data and apply variation/contribution metrics, improving strategic decisions and driving goal achievement. Automated and improved processes, optimizing the productivity of routine tasks and allowing more time for analysis and strategy. Developed the Harpy application via Power BI to provide detailed customer analytics and better understand the purchasing behavior of partner companies.

Chemical Engineering at Universidade Federal de Itajubá (Federal University of Itajubá)
2014 - 2022

Big Data and Data Science at Unique College
2023 - 2024

Complete SQL for Data Analysis at Udemy
8/1/2023

Data Science with Python at Udemy
7/1/2023

Microsoft Power BI for Data Science v2 at Data Science Academy
6/1/2023

DAX and ETL with Power BI: Loading Data at Alura
11/1/2021

Analyze Data with SQL at Codecademy
4/1/2021

Excel VBA Macros at Udemy
3/1/2021