Renato AragónSenior Data Engineer & Data Architect

AWS · PySpark · Apache Iceberg · Python · GenAI

Senior Data Engineer, Data Architect and Technical Lead with 14+ years designing enterprise data platforms, ETL/ELT pipelines, and cloud-native architectures in regulated and high-volume environments. Background combining hands-on engineering, product ownership, data governance, and cross-functional alignment — operating across architecture, automation, analytics, and executive stakeholder-facing responsibilities. Also a builder: founder of multiple SaaS products in production across Brazil and Portugal.

Available for B2B remote contracts · EU

Results

What I actually deliver

Monthly billing reconciliation

Before

12 days

After

Real-time dashboard

Partner onboarding signature

Before

8 hours / signature

After

8 seconds

Internal report generation

Before

2 business days

After

Under 2 minutes

Daily tax authority emails

Before

1,500+ reviewed manually

After

Automated ingestion + tracking

Revenue data visibility

Before

No real-time financial data

After

Live P&L + payroll + ledger

Company revenue supported

Before

~R$8M avg/month

After

R$25M+ avg/month

Platform and data infrastructure built over 2 years at AG Capital Group

Technical

Core Expertise

Architecture

Cloud-native Data Platforms · Lakehouse · Distributed Processing · Platform Modernization

Leadership

Technical Lead · Product Ownership · Architecture Decisions · Cross-functional Alignment

Cloud & Data

AWS Glue · EMR · Athena · S3 · Lambda · Step Functions · RDS · OCI (Oracle Cloud Infrastructure) · Azure Databricks · Azure Data Factory

Data Engineering

PySpark · Apache Iceberg · Apache Kafka · Event-Driven / Streaming · ETL/ELT · Lakehouse · Incremental Processing

Backend & Integration

Python · PostgreSQL · Next.js · REST APIs · HubSpot API · Microsoft Graph · GenAI

Infrastructure

Terraform · Docker · CI/CD · GitHub Actions

Governance & Ops

Data Quality · Lineage · Deduplication · Schema Evolution · Dashboards

Databases

PostgreSQL · MySQL · SQL Server · Redshift · Snowflake

Work history

Experience

Hiscox

(via B2B Contract)Ongoing2026 – Present

Senior Data Engineer

  • Senior Data Engineer on a cloud data platform in the insurance domain, building and modernising data-integration pipelines.
  • Develop and migrate file-integration pipelines on Azure Databricks (PySpark / pandas) and Azure Data Factory.
  • Re-engineer legacy SQL-based transformation logic into a modern object-oriented dataframe framework, used as a baseline for new integrations.
  • Implement validation, mapping and error-handling rules, with parity testing against production outputs.
  • Deliver through Azure DevOps (Git branching, pull requests, release pipelines) in a regulated financial-services environment.

Aragón Dataguard

Ongoing2013 – Present

Founder, Lead Data Engineer & Data Architect

  • Designed cloud-native data platforms and automation systems for clients across Brazil and Portugal, translating operational requirements into scalable technical solutions.
  • Led end-to-end technical delivery: architecture, ETL design, cloud infrastructure, and client-facing stakeholder alignment.
  • Built event-driven data pipelines with Apache Kafka — a transactional-outbox pattern streaming PostgreSQL changes to Kafka to power near-real-time KPIs and cross-product analytics.
  • Also built and operates a portfolio of proprietary SaaS products in production: PsycoHub (digital practice for psychologists), NutriPro (nutritionists), Sola Beauty (beauty professionals), Dockly (agency project management), and LaboraHub (talent marketplace for Portugal & Spain).
  • Stack: Python · PostgreSQL · AWS · Next.js · AI integrations.

BMW Group

(via B2B Contract)2024 – 2026

Senior Data Engineer

  • Designed and modernized enterprise batch pipelines using AWS Glue and EMR integrated with BMW Cloud Data Hub (CDH).
  • Implemented complex PySpark transformation layers for large-scale automotive and operational datasets.
  • Contributed to a cloud migration from OCI to AWS, mapping Oracle Cloud Infrastructure services to their AWS equivalents (Object Storage → S3, Data Flow → Glue/EMR, Autonomous Data Warehouse → Redshift/Athena) and re-platforming the associated pipelines.
  • Applied Apache Iceberg transactional patterns: upserts, schema evolution, and time travel.
  • Supported scalable infrastructure patterns using Terraform and cloud-native orchestration.
  • Collaborated within regulated enterprise environments with governance and analytics stakeholders.

AG Capital Group

(via B2B Contract)2018 – 2026

Senior Data Engineer / Technical Lead & Coordinator

  • Led evolution of centralized analytics and operational platform across 14+ integrated systems, 8 business units, and 324 daily users.
  • Architected ETL pipelines integrating financial systems, CRM (HubSpot API), fiscal authorities (Receita Federal), and Microsoft Graph.
  • Led the full migration of the AWS-based data lake to OCI (Oracle Cloud Infrastructure), re-architecting storage, ingestion, and processing layers with no disruption to daily operations.
  • Built and operated standardized Snowflake data pipelines over ~2 years, delivering governed ELT models and analytical layers for finance and commercial teams.
  • Developed governance mechanisms: audit layers, deduplication strategies, real-time P&L integrated with accounting ledger and payroll.
  • Reduced operational effort by over 40% through platform modernization, cloud-native automation, and GenAI integration for commercial teams.
  • Acted as Technical Lead, Coordinator, and architecture reference — coordinating cross-functional teams across engineering, analytics, and business units, mentoring engineers, and driving data-driven culture at scale.
Bachelor's in Business Administration · UDESC (Universidade do Estado de Santa Catarina), BrazilPostgraduate in Big Data & Analytics · UNISUL, Brazil (in progress, 2024–2026)PortugueseNative · EnglishC1 · SpanishIntermediateAuthorized to work in Portugal and the European Union.

Social proof

What colleagues say

Renato has an exceptional ability to manage conflicts and deliver high-quality solutions under challenging deadlines. His rational approach was fundamental for communication between the technical and business teams. An exceptionally talented and dedicated professional whose skills were invaluable to the success of our projects.

Carlos Henrique Oliveira

Software Engineer · Itaú Unibanco

Renato has the gift of empowering his team to perform and realize their potential. He is always attentive to the team's wellbeing and ready to help. I had the opportunity to learn a lot about strategic management thanks to his immense analytical vision and ease of communication.

Gabriel Ratão

Data Engineer | Spark | Big Data

Renato is a reference in leadership, with a sharp eye for company strategy, without losing his human perspective for each person on the team. He always motivates team members to find solutions to daily challenges while providing support and knowledge to overcome them.

Carlos Escanhoela Júnior, Ph.D.

Data Analyst | Power BI | Python | BI

Renato quickly becomes part of the brain of the company and supports critical and fundamental decisions for business success. A professional with enormous technical capacity, vast experience across different business perspectives, who leads a team with great empathy and performance.

Mario Hidetatsu

Network Engineer | DevOps | SecOps

Renato has an exceptional ability to manage conflicts and deliver high-quality solutions under challenging deadlines. His rational approach was fundamental for communication between the technical and business teams. An exceptionally talented and dedicated professional whose skills were invaluable to the success of our projects.

Carlos Henrique Oliveira

Software Engineer · Itaú Unibanco

Renato has the gift of empowering his team to perform and realize their potential. He is always attentive to the team's wellbeing and ready to help. I had the opportunity to learn a lot about strategic management thanks to his immense analytical vision and ease of communication.

Gabriel Ratão

Data Engineer | Spark | Big Data

Renato is a reference in leadership, with a sharp eye for company strategy, without losing his human perspective for each person on the team. He always motivates team members to find solutions to daily challenges while providing support and knowledge to overcome them.

Carlos Escanhoela Júnior, Ph.D.

Data Analyst | Power BI | Python | BI

Renato quickly becomes part of the brain of the company and supports critical and fundamental decisions for business success. A professional with enormous technical capacity, vast experience across different business perspectives, who leads a team with great empathy and performance.

Mario Hidetatsu

Network Engineer | DevOps | SecOps

Let's work together

“You've seen what I build — for clients and for myself. Let's talk about what I can build for you.”

I'm available for B2B remote contracts across EU. If you're building or modernising a data platform, reach out directly.