Guilherme B.
Senior Consultant
Experience
Aug 2024 - Present
1 year 5 monthsSenior Consultant
Izertis
- Building and optimizing data models in Power BI using Power Query, DAX, and Dataflows to ensure accurate transformations and strong performance.
- Developing and maintaining ETL processes and data queries in SQL to extract, transform, and load data from multiple sources.
- Using Python for basic data manipulation, automation, and data validation tasks.
- Integrating and consolidating data from cloud platforms, databases, and APIs to enable comprehensive reporting and analytics.
- Developing interactive dashboards and reports to support financial forecasting, budgeting, and business performance tracking.
- Collaborating with business stakeholders to gather requirements, define KPIs, and translate them into actionable insights.
- Ensuring data quality, governance, and consistency across all layers of the BI environment.
Jan 2020 - Jul 2024
4 years 7 monthsFaro, Portugal
Business Intelligence Associate
Metyis
- Designed, developed, and optimized Business Intelligence and Data Analytics solutions with a focus on Power BI, SQL, and ETL pipelines using Azure Data Factory.
- Built and maintained interactive dashboards, data models, and reports in Power BI to support business performance analysis and decision-making.
- Developed and optimized SQL queries, views, and stored procedures for efficient data extraction and transformation.
- Created and maintained ETL workflows in Azure Data Factory to integrate and automate data from multiple sources.
- Worked with SSAS to design analytical models and enable multidimensional reporting.
- Used Python for basic data automation and validation tasks.
- Served as Team Visualization Leader, coordinating tasks, guiding team members, and managing client interactions to ensure timely, high-quality project delivery.
- Collaborated with stakeholders to define KPIs, improve data accuracy, and deliver actionable insights aligned with business objectives.
Dec 2018 - Dec 2019
1 year 1 monthFaro, Portugal
Business Intelligence Developer
Yourdata
- Supported the design and implementation of Business Intelligence solutions focused on Power BI and SQL.
- Developed interactive dashboards and reports in Power BI to visualize key business metrics and trends.
- Wrote and optimized SQL queries for data extraction, cleaning, and analysis from multiple data sources.
- Assisted in building data models and improving report performance through proper relationships and data transformations.
- Collaborated with senior analysts and business users to gather requirements and ensure the delivery of accurate insights.
- Gained foundational experience in data visualization, report automation, and database management.
Summary
Highly analytical BI professional with over 5 years of experience in designing and developing data-driven solutions using Power BI, SQL, and Azure Data Factory, with additional experience in SAP Analytics Cloud. Skilled in building interactive dashboards, optimizing data models, and implementing ETL processes that transform raw data into actionable insights. Experienced in coordinating visualization teams, managing client communication, and ensuring high-quality delivery within tight deadlines. Thrives in fast-paced, dynamic environments and is committed to continuous learning and improvement.
Languages
Portuguese
NativeEnglish
AdvancedSpanish
ElementaryEducation
Sep 2015 - Jul 2018
University of Algarve
B.Sc. · Management · Faro, Portugal
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
Claudio D.
Data Engineer
View Profile
Olivier H.
Senior Consultant
View Profile
Reinhold S.
Senior Software Developer
View Profile
Konstantin G.
Requirements engineer, Python Developer
View Profile
Moez S.
Business Intelligence & Controlling
View Profile
Bernd S.
Business Data Analyst | PowerBI & Microsoft SQL Server
View Profile
Petru K.
ETL, DWH, BI Solution Design, Architecture & Development.
View Profile
Tarek S.
Cloud Analytics Developer
View Profile
Vitali H.
Power BI Expert
View Profile
Marco S.
Business Analyst, Data Warehouse Developer
View Profile
Friedbert W.
Data Analyst / Business Analyst
View Profile
Guido K.
BI Consultant / SSRS Expert
View Profile
Philipp G.
Building a Modern Compensation System
View Profile
Marco A.
Data & Operations Analyst
View Profile
Davide M.
Senior Data Architect/Engineer
View Profile
Eduard V.
Tech Lead Customer Base Documentation Automation
View Profile
Stefan C.
BI Developer
View Profile
Willi Z.
Data Analyst
View Profile
Kauan D.
Data Analyst
View Profile
German P.
Microsoft BI Specialist
View Profile
Thomas R.
MS Power BI / MS SQL Developer
View Profile
Simon S.
Cloud Data Platform Product Owner & Project Manager
View Profile
Enes A.
Data Analyst
View Profile
Germo G.
BI Development
View Profile
Evrim I.
T-SQL Database Expert
View Profile
Henok A.
Founder and Managing Director
View Profile
Tobias B.
Project Management, Consulting
View Profile
Ivan G.
Founder, CEO; Qlik Sense, MS Power BI Solution Architect
View Profile
Marco C.
Global Process Owner Business Intelligence
View Profile
Martin T.
Freelance, Interim Controller
View Profile
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.