Summary
Overview
Work History
Education
Skills
Additional Information
Certification
Timeline
Courses
Languages
Generic

Caio Scarmocim

Data Analyst
Hamburg,HH

Summary

Certified Tableau Data Analyst focused on translating business requirements into actionable plans and dashboard visualizations. Ready to bring over 5 years of data analysis experience. Sound understanding of Tableau, SQL and relational database concepts. Proven ability to identify business needs and develop strong relationship with clients.

Overview

10
10
years of professional experience
1
1
Certification
4
4
Languages

Work History

Data Analyst

Engel & Völkers
01.2023 - Current
  • Created dashboards to monitor and track real estate market indicators.
  • Developed ETL processes to prepare data for dashboards.
  • Maintained and created new data pipelines in our database
  • Used statistical methods to analyze data and generate useful market insights.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Extracted and interpreted data patterns to translate findings into market insights .
  • Collaborated with stakeholders to identify business needs and data sources.
  • Collaborated with business-unit leaders to identify and prioritize problems.

BI Developer

CBRE
06.2021 - 12.2022
  • Support multiple Facility Management and Project Management teams with analytical solutions
  • Translate business requirements from different teams into technical specifications and Tableau visualizations
  • Gathering requirements during monthly engagement calls with clients
  • Designing, building and deploying BI solutions (SQL,Tableau)
  • Maintaining and enhancing existing dashboards
  • Troubleshooting Data Source and Dashboards
  • Collaborating with teams to integrate data model with multiple systems (data warehouse, flat files)
  • Developing and executing database queries as well as conducting analyses (SQL, DBeaver)
  • Developing and updating technical documentation

Key Achievements

  • Led a PJM dashboard project and delivered it as per agreed deadline, meeting the client's requirements
  • Developed a dashboard to support clients in identifying the rate of missing data from fields used in their reports
  • Brought multiple improvements and shared best practices for dashboard, improving dashboard performance and exceeding clients' expectations

Real Estate Portfolio Analyst

CBRE
10.2019 - 06.2021
  • Data management and input using SaaS systems (Sequentra, Tririga)
  • Performing in-depth analysis to provide accurate results for Variance reports
  • Validating and sending monthly Tableau report from BA to the client
  • Abstracting real estate leases from multiple clients
  • Answering client's queries and tickets
  • Monitoring data quality

Key Achievements

  • Developed a macro to clean data from the variance report which contributed to a greater data accuracy and significant reduction of time for its preparation
  • In cooperation with other team, conducted a comprehensible FTE Capacity Study using data extracted from Salesforce
  • Improved the client's data accuracy by engaging in projects using Excel to compare and identify missing data from previous system

Facility Management Engineer

San Remo Engineering
06.2016 - 05.2018
  • Coordinated maintenance teams on site to deliver all tasks on time and delivered monthly reports
  • Evaluated final results to determine quality levels and isolate root causes of any identified faults.

Education

Bachelor's degree - Civil Engineering

Universidade Positivo
Curitiba, Brazil
12.2017

Erasmus Programme - Urban Management & Development

Erasmus University
Rotterdam, Netherlands
07.2015

Skills

Data analysis

Data visualization and presentations

SQL

Python programming

Data cleaning

Dbt

Additional Information

  • EU Citizenship (Italian)

Certification

Certified Data Analyst, Tableau - Jan 2024

Timeline

Data Analyst

Engel & Völkers
01.2023 - Current

BI Developer

CBRE
06.2021 - 12.2022

Real Estate Portfolio Analyst

CBRE
10.2019 - 06.2021

Facility Management Engineer

San Remo Engineering
06.2016 - 05.2018

Erasmus Programme - Urban Management & Development

Erasmus University

Bachelor's degree - Civil Engineering

Universidade Positivo

Courses

  • Data Warehousing for Business Intelligence Specialization – Coursera

(Feb-22 – Present)

  • Data Analyst with SQL – Datacamp

(Jan-22 / Feb-22)

  • Analyzing Data in Tableau – Datacamp

(Nov-20 / Dec-20)

  • Intermediate VBA – CBRE

(Oct-20)

  • Advanced Excel – CBRE

(Feb-20)

Languages

Beginner,1,Elementary,2,Advanced,5,Advanced,5
Caio ScarmocimData Analyst