Data & BI Engineer
About Me
I am a Data Engineer with over 5 years of experience building scalable data pipelines and automations that transform raw data into strategic insights. My expertise lies in data modeling, ETL/ELT development, and modern data architectures such as Data Lakehouse and Medallion. I combine strong technical skills with business acumen to design data solutions that align with organizational goals.
I hold a postgraduate specialization in Data Engineering and am currently pursuing a second postgraduate degree in Software Engineering. Throughout my career, I have worked extensively with cloud platforms like GCP, AWS, and Azure, and have experience managing data workflows and pipelines using tools such as MageAI, Airflow, and Dagster.
My professional experience includes designing Medallion architectures with SCD Type 2 versioning in Snowflake, automating data ingestion and transformation processes, implementing data quality frameworks, and ensuring compliance with data protection regulations such as LGPD. I have also developed dashboards and reports using Power BI and Google Data Studio to support operational and strategic decision-making.
I am proficient in multiple programming languages and tools including Python, SQL, PySpark, Power Automate, and Excel VBA. Additionally, I have experience working with various databases such as PostgreSQL, ClickHouse, BigQuery, and SQL Server. I am passionate about leveraging data to drive business value and continuously improving data infrastructure and processes.
I am eager to contribute my skills and knowledge to innovative data projects and collaborate with teams to deliver impactful data solutions. I am committed to staying current with emerging technologies and best practices in data engineering and analytics.
Skills
Project ManagementPythonSQLAWSCustomer ServiceAzureCI CDReportingGCPTerraformData AnalyticsPostgreSQLProcess OptimizationSQL ServerKnowledge Management
Education
Postgraduate in Software Engineering
In Progress
Postgraduate in Data Engineering
Completed. Covered IaC with Terraform (AWS, Azure, Databricks), Data Warehouse Modeling & Governance, Data Engineering with Airbyte, DBT & SQL, Data Lake & Lakehouse, PySpark & Apache Kafka (Batch & Streaming)
Bachelor's in Food Engineering
Experience
Designed Medallion architecture with SCD Type 2 versioning in Snowflake. Automated data ingestion processes and optimized pipeline performance. Implemented data quality frameworks and validation routines. Orchestrated data workflows using MageAI (Airflow/Dagster equivalent). Provisioned and managed cloud instances on GCP and AWS. Ensured data compliance with LGPD principles. Extracted and modeled data from Google Ad Manager, Google Ads, Pipedrive, and legal sources (Escavador/Comunica). Implemented CI/CD pipelines in GitHub/Bitbucket (dev/staging/prod). Worked with PostgreSQL (OLTP), ClickHouse, and BigQuery (OLAP).
Set up a secure cloud VM with Ollama & OpenWebUI for LLM-powered analytical usage. Designed and implemented a Lakehouse (Medallion: RAW/BRONZE/SILVER/GOLD) on SQL Server 2019 via ELT using Python and SQL. Automated ETL processes: cleansing, ingestion, and transformation (PowerQuery, Python, Power Automate, Excel). Built and maintained Power BI reports and dashboards. Created SharePoint Wiki pages and optimized internal knowledge management.
Performed ad hoc data integrity report reviews. Tracked and reported key operational indicators. Developed Power BI and Google Data Studio dashboards. Worked with REST APIs, JSON, and SQL (SSMS / SQL Server).
Developed Power BI and Google Data Studio dashboards. Automated workflows using Excel Macro/VBA and Power Automate. Worked with REST APIs, JSON, and SQL (PostgreSQL / DBeaver). Delivered time-event analyses to support operational decisions.
Built Google Data Studio dashboards with core operational KPIs. Automated data processes integrating multiple sources. Managed ERP, WMS, and Shopify routine operations.
Built dashboards to track project KPIs. Automated data processes from multiple sources. Prepared executive presentations for Business Partners and Leaders.
Managed regional inventory planning and B2B/B2C logistics routes. Analyzed product demand fluctuations and led process optimization projects. Provided customer service, internal sales support, and new hire onboarding.