Meet Bruno, a dedicated data analyst with a solid foundation and an everlasting curiosity to learn and grow. With skills in Tableau, Snowflake, Adverity, Power BI, Alteryx, R, and Python, he is experienced in the use of data to derive relevant insights that can impact decision-making positively. In his Master of Public Policy, he evaluated the effect of goverment programs using statistical models in R.
Experience in Placements
As part of The Information Lab Team, I contributed to the development, implementation, and maintenance of a marketing analytics ecosystem — an ambitious data infrastructure connecting over 60 dashboards across 11 regional branches of a large health insurance provider. The project aimed to automate data collection, standardize KPIs, and enable real-time marketing insights. My key contributions and achievements include:
End-to-End Pipeline Management
Maintained and enhanced Adverity → Snowflake → Tableau Cloud pipelines, ensuring data quality, reliability, and compliance.
Data Automation
Adapted and maintained Snowflake SQL script generators (Python) to standardize and document data pipelines via GitHub version control.
Reduced manual errors and time spent on stream and SQL table creation by automating template generation and historical data retrieval.
Dashboard Development
Designed and delivered new dashboards for several marketing campaigns, enabling the client to monitor ad performance, conversion metrics, and user engagement in real-time.
Built end-to-end dashboards — from Adverity data extraction and Snowflake data modeling to Tableau Cloud visualization—allowing the client to run tests and optimize ad spend.
Data Expansion
Integrated 4 new social media ad accounts and 14 new metrics into the data model, expanding coverage and analytical depth for regional branches.
Created a Google Ads Conversions Table for all branches, improving budget allocation and performance tracking.
Used a snowpipe to connect to client data in an S3 bucket, making available key Adobe Analytics variables that were important to the client.
Client Enablement
Trained 65 client employees in Tableau Cloud and data visualization principles, improving their data literacy and dashboard adoption.
Developed a Notion feedback database logging over 110 client feedback points to guide iterative improvements.
Prototype Design & Mock Data Generation
Created 4 dashboard sketches (SEO, Campaign, Newsletter, Social Media) using Canva for realistic client reviews.
Coded Python/R scripts to generate realistic mock datasets mirroring Adverity data structures, expediting the prototyping phase.
Experience Before The Data School
Legislative Advisor to Brazilian MP Drawing on data analysis, advised an MP on her bills and reports to the Parliament. Moreover, created a Shiny Dashboard to analyze educational indicators in 75 municipalities to support mayors' decisions in educational policy.
Data Science Consultant at the Hertie School Data Science Lab Guided over 20 master's students in coding and data analysis, contributing to the successful completion of their theses.
Projects
Digital Marketing SiB Project: we built a dashboard that integrated data from several sources - Google Analytics, Excel Sheets, Meta, and Google Ads - and presented it in a clear and structured way in order to facilitate the decision-making process of our client in the digital marketing field.
Synthetic Control Method for Policy Evaluation Workshop: delivered a hands-on workshop about the use of the synthetic control method in policy evaluation. The target group was civil servants at the Federal Senate of Brazil and the course included an introduction to R and example applications;
Coding The Past: a personal blog dedicated to clarifying data science concepts, with a focus on their application in the humanities.
Skills
Data Preparation: Snowflake, Tableau Prep, Alteryx, Power Query, R (dplyr, base R), Python (pandas, numpy), SQL;
Data Visualisation, Dashboards and Storytelling: Tableau, Power BI, R Shiny, Flask, HTML, CSS, Python matplotlib;
Statistics: R and Python (pandas, numpy).