Lincoln Macêdo

Remote, Brazil

• ·Own a GA4 behavioral data product (web + app) processing 800M–1.86B events/month with PySpark and Delta Live Tables (DLT), validating data quality on every table.
• ·Designed a 25+ table Delta Lake model (sessions, checkout, revenue, attribution) with governance (CDF, deletion vectors, row tracking) and Unity Catalog, orchestrated by Databricks Workflows and GitHub Actions CI/CD.
• ·Optimized BigQuery data models with partitioning, clustering and materialized views, improving query performance and reducing compute costs.
• ·Improved processing efficiency by ~33% and cut infrastructure costs by 10%+ through Spark job optimization, cluster tuning and instance right-sizing.
• ·Led an AWS migration POC ingesting ~1.5 TB via AWS DMS (CDC), validating 20%+ cost savings versus the incumbent solution.

Remote, Brazil

• ·Led data migrations from Google Sheets to BigQuery for 4 clients, redesigning ELT pipelines with Python and SQL to improve reliability and query performance.
• ·Moved ~30% of projects fully to BigQuery, removing external API dependencies and saving USD 4,500+/year in subscription costs.
• ·Implemented medallion architecture (bronze, silver, gold) and integrated GA4, Google Ads, X, Spotify and Kwai data into centralized BigQuery warehouses.
• ·Built 15+ Power BI and Looker Studio dashboards for enterprise brands such as Petrobras, Riachuelo and Boticário.

Remote, Brazil

• ·Built and maintained GCP data pipelines (BigQuery, Cloud Storage) and Supermetrics ETL/ELT integrations for 16 enterprise clients, reducing manual work.
• ·Developed 40+ dashboards in Power BI, Looker Studio and Tableau, replacing 70%+ of PowerPoint-based reporting.
• ·Analyzed 400+ marketing campaigns and UX behavior (Contentsquare, Hotjar) for clients such as AbbVie, AstraZeneca, Bayer, Novartis and Sanofi.