Marçal Oliveira

Senior Data Architect | GCP (BigQuery, Cloud SQL) | BI & ETL Specialist | AI-Assisted Development | 20+ Years in Analytics

Rio de Janeiro, Rio de Janeiro, Brazil

About

Senior Data Architect and BI Engineer with 20+ years of experience designing and delivering end-to-end analytical ecosystems — from OLTP to semantic layers and BI dashboards. I specialize in GCP (BigQuery, Cloud SQL, Cloud Storage, Pub/Sub, Cloud Functions, Cloud Composer), dimensional modeling (SCD2, Star Schema, Snowflake), and enterprise ETL (PowerCenter, Pentaho, JasperETL). My approach combines architecture, governance, and performance with modern AI-assisted development, using generative models to accelerate Python, SQL, and DAX development while maintaining strict technical validation. I have supported major enterprises across telecom, finance, retail, ERP, and SaaS environments — always focused on business value and clarity of information. Currently open to remote international opportunities as a Senior Data Engineer, Data Architect, BI Engineer, or Cloud Data Specialist.

Experience

  • Data Architect / Analyst at Qintess
    Jan 2024 - Nov 2025 · 1 yr 11 mos

    Data modeling for OLTP and analytical layers (GCP/BigQuery). Governance, automation and optimization of pipelines using Cloud Composer. Support for BI teams and integration initiatives.

  • Data Architect / Analyst at Foursys
    Jan 2022 - Jan 2024 · 2 yrs 1 mo

    ETL development using PowerCenter. Oracle/DB2 integration and data governance. Analytical modeling and performance optimization.

  • Data Architect / Analyst at Claro Brasil
    Oct 2019 - Jan 2022 · 2 yrs 4 mos

    Tableau reporting and Pentaho ETL workflows. Data integration across MySQL, MongoDB and SQL Server environments.

  • Professional Development — Independent Study at Self-employed
    Mar 2015 - Oct 2019 · 4 yrs 8 mos

    Strengthened technical skills in Data Engineering, BI and Cloud environments. • Hands-on practice with Power BI and QlikView through independent projects. • Studied data modeling, ETL concepts, analytical design and modern cloud architectures. • Continuous learning focused on SQL performance tuning and BI visualization techniques.

  • BI/DW Architect at MXM Sistemas
    Oct 2013 - Feb 2015 · 1 yr 5 mos

    BI module development for MXM ERP (JasperETL + QlikView). Technical leadership in architecture and delivery.