Loading profile…
Sergio Gonçalves
Looking for a jobData Analysis Intern
I build Power BI dashboards and SQL analyses that improve reporting speed, data quality, and operational decisions.
PortugalData Analysis Intern at ARKIA
About
At Arkia, I built five interactive Power BI dashboards and BigQuery SQL queries that reduced weekly reporting time by 40% and accelerated access to critical information by 50%.
I've also consolidated financial data for Centro Paroquial de Paderne and developed churn and retail sales analytics projects using SQL, Power BI, DAX, Power Query, Excel, and ETL processes.
Experience
Data Analysis Intern
Developed 5 interactive Power BI dashboards using DAX and Power Query, reducing weekly reporting time by 40%. Built complex SQL queries in BigQuery, accelerating access to critical information by 50%.
Power BIDAXPower QuerySQLBigQueryETLData Cleaningdata transformationData ValidationData Storytelling
Financial Data Analyst
Analyzed and consolidated monthly financial data in advanced Excel using pivot tables, VLOOKUP and macros, reducing month-end closing time by 25%. Structured and maintained financial databases with over 10,000 records per year, ensuring data integrity and traceability for audits.
Pivot TablesMacrosData Integrity
Education
Escola Data Tech Florida
Master of Data Analytics program covering advanced SQL, data modeling, Power BI, DAX, storytelling with data, applied statistics, and A/B testing.