William E.Data Analyst
Skills
Chemical Engineer with extensive experience in data analysis and business intelligence. Proficient in data analysis, programming, and management of relational databases, including both relational and dimensional data modeling. Capably utilizes an array of business intelligence tools to deliver innovative and efficient technical solutions, consistently ensuring high-quality outcomes.
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 - 2022Big Data and Data Science at Unique College
2023 - 2024
Complete SQL for Data Analysis at Udemy
8/1/2023Data Science with Python at Udemy
7/1/2023Microsoft Power BI for Data Science v2 at Data Science Academy
6/1/2023DAX and ETL with Power BI: Loading Data at Alura
11/1/2021Analyze Data with SQL at Codecademy
4/1/2021Excel VBA Macros at Udemy
3/1/2021
William is available for hire
Hire William E.
All Howdy Candidates are vetted for skills and english proficiency.
