Howdy Logo
Image of William E.

William E.
Data Analyst

Sql
Python
Bio

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

William is available for hire

Hire William E.
Check icon

All Howdy Candidates are vetted for skills and english proficiency.