Guilherme C.Data Analyst
Skills
Postgraduate in Business Management (MBA) and Marketing (BA) with specialization in Data Science and Analytics from USP/Esalq. Possesses a strong foundation in data analysis and Business Intelligence, encompassing the creation and development of comprehensive databases essential for decision-making processes. Exhibits excellent proficiency in verbal and written communication, negotiation, and networking. Effectively collaborates within teams and operates independently with a strategic and analytical approach.
Accumulates around five years of professional experience in data analysis, covering a broad spectrum of data types. Proficient in Power BI, Excel, ETL, PowerQuery, DAX, Data Visualization, Supermetrics, and Social Media Analytics, with substantial knowledge in SQL, Python, and R.
Senior BI Analyst
3/1/2023 - Present
Conducted in-depth analysis and performance monitoring of social networks including Facebook, Instagram, Twitter, YouTube, and LinkedIn. Performed qualitative and quantitative analysis of audience engagement metrics and brand image on digital platforms. Engaged in scenario analysis and generated insights with actionable conclusions and recommendations. Developed comprehensive dashboards and reports using industry-leading tools.
Demonstrated advanced analytical skills and insight generation capabilities. Proficient as a Power BI Developer with strong expertise in Business Intelligence (BI), Excel, and other BI tools. Specialized in data modeling, database management, DAX, Supermetrics, ETL processes, and PowerQuery. Exhibited strong command of data analysis tools such as Google Sheets, Microsoft Excel, and Google Data Studio. Proved adept in problem-solving and showcased significant analytical capacity in delivering meaningful data-driven strategies.BI Analyst
9/1/2022 - 3/1/2023
Responsible for business intelligence in a global beverage sector company, performing data analysis extracted from diverse sources including CRMs, databases, and market collection management platforms. Provided simplified and visually appealing insights using Power BI and Excel to aid in decision-making. Actively participated in strategic meetings with both clients and internal teams. Developed expertise in data extraction and analysis, proficiency in Power BI, and advanced skills in Excel.BI Analyst
7/1/2022 - 10/1/2022
Handled responsibilities for the BI area of the purchasing department with a focus on creating and maintaining projects and structuring the data area. Emphasis placed on data automation and analysis for strategic decision-making. Demonstrated expertise in strategic planning, UX design for data visualization products using Excel and Tableau, and data segmentation for strategic decision making. Developed and maintained BI projects and data infrastructure, as well as ETL processes. Gathered requirements and defined metrics for new KPIs, while also ensuring data maintenance and modeling.BI Analyst
9/1/2021 - 4/1/2022
Developed, constructed, and maintained ETL processes while gaining experience with various trade marketing solution platforms. Mapped, documented, and supported projects, gathering requirements for and developing business intelligence and data infrastructure initiatives. Designed UX products focused on data visualization, specifically dashboards, and structured new BI and Excel projects. Ensured the accuracy and maintenance of internal databases. Acquired basic knowledge of Python and MySQL.Market Intelligence
12/1/2020 - 12/1/2020
Managed information flow for the largest site of a significant commemorative action in São Paulo, overseeing the processing of over 30,000 reports with 3,500 hires within 12 days. Developed expertise in collecting, validating, and analyzing data through a specific application. Utilized and maintained the Promo Marketing Report information system while coordinating closely with Trade and Selection teams. Conducted training sessions for more than 1,000 promoters and stockers, ensuring seamless operation and data integrity throughout the project.
Computer Technician at Senac Brazil
2011 - 2013Marketing at Anhembi Morumbi University
2015 - 2016Business Management at Anhembi Morumbi University
2021 - 2022
Guilherme is available for hire
Hire Guilherme C.All Howdy Candidates are vetted for skills and english proficiency.