Senior Data Engineer · Insurance data · Platform builder

Renato Aragón

I turn messy, multi-source data into pipelines, contracts and products that hold up in production. At Hiscox I build and modernise insurance data integrations across six European markets. As founder of Aragón Tecnologia I own a portfolio of SaaS products end to end, from architecture to the cloud bill, with a squad of AI agents I supervise.

Porto, Portugal · PT / EN / ES · remote across the EU

14+ yrsin data, since 2012
6 marketsinsurance integrations
10+apps in production
−60%AWS run-rate
Renato Aragón
const renato = {
  role: "Senior Data Engineer",
  focus: "reliable data platforms",
  cloud: ["Azure", "AWS"],
  agents: "supervised, scored, accountable",
  approach: "evidence over assumptions",
  scope: "architecture to operations"
}

// about

Engineering that earns trust.

I work across data integration, migration, modelling, orchestration, and platform reliability. A green pipeline is not proof to me: I trust a release when its output reconciles row by row, its contract is explicit, and the decision behind it is written down. When something breaks, I go to the root cause and protect what is shared.

I also bring a product owner's perspective. Through Aragón Tecnologia, I take products from idea to production and remain accountable for what happens afterwards. That operational responsibility shapes how I design data systems and how I lead technical work.

// results

Before → after.

What the platforms changed for the people using them.

Monthly billing reconciliation12 daysreal-time dashboard
Partner onboarding signature8 hours8 seconds
Internal report generation2 business daysunder 2 minutes
Tax-authority emails1,500+ a day, read by handautomated ingestion and tracking
Revenue visibilityno real-time datalive P&L, payroll and ledger
Policy-migration rolloutone broker at a timesix brokers to UAT in 16 working days
Build time per broker3 dayshalf a day, with no new framework code
Delivery against planscheduled for later sprintsup to two weeks early
Parity with the legacy flowmanual output comparisonzero differences on 555 real rows

The first five at AG Capital Group, the last four at Hiscox. A capacity run then took the modernised flow to 50,000 rows.

// stack

The toolkit.

Data & Pipelines

  • Python
  • PySpark
  • Pandas
  • Athena
  • Databricks
  • Azure Data Factory
  • SQL Server / T-SQL
  • Kafka
  • Spark Structured Streaming
  • Airflow
  • dbt
  • DuckDB
  • Delta Lake
  • Iceberg
  • MLflow
  • ETL / ELT
  • Data modelling

Cloud & DevOps

  • AWS
  • Azure
  • Azure DevOps
  • Terraform
  • Docker
  • Linux
  • Nginx
  • CI/CD
  • Blue-green deploys
  • AWS Graviton (ARM64)
  • AWS SSM
  • Cost optimization

Web & Product

  • Next.js
  • React
  • TypeScript
  • Node.js
  • Tailwind

Storage & AI

  • PostgreSQL
  • Prisma
  • Redis
  • REST APIs
  • LLM integration
  • Agent orchestration
  • AI agents
  • Voice (STT / TTS)

// experience

Where I've worked.

2026 — present

Senior Data Engineer

Hiscox · B2B contract

Insurance data integration for Europe: bordereaux from brokers and coverholders in Ireland, France, Germany, Spain and the Benelux, validated, transformed and routed to policy systems on Azure Databricks, Data Factory and SQL Server.

  • Designed the reusable pattern for a policy-system migration and rolled it out to six brokers through configuration alone. The first real file reconciled row by row across every output, with zero loss or duplication.
  • Turned rule-class activation into a metadata-driven dispatch, so new integrations no longer need orchestrator changes.
  • Modernised legacy robot-driven flows into a Python business-rules framework. Traced a failure hidden behind a green pipeline to a notebook namespace collision, isolated 43 shared helpers without side effects, and validated the result at 50,000 rows.
  • Release engineering across SQL (DACPAC), Databricks and Data Factory through Azure DevOps, plus production defect triage down to the root cause.
Aug 2024 — Jan 2026

Senior Data Engineer

BMW Group · B2B contract

Enterprise batch pipelines for large-scale automotive and operational data, in a regulated, international environment.

  • Designed and modernised batch pipelines on AWS Glue and EMR, integrated with the group's cloud data hub.
  • Built complex PySpark transformation layers, and applied Apache Iceberg upserts, schema evolution and time travel.
  • Contributed to a cloud migration from OCI to AWS, mapping services and re-platforming the pipelines that depended on them.
  • Scaled infrastructure patterns with Terraform and cloud-native orchestration.
2018 — 2026

Senior Data Engineer · Technical Lead & Coordinator

AG Capital Group · B2B contract

Led the evolution of a central analytics and operational platform: 14+ integrated systems, 8 business units and 324 daily users.

  • Architected ETL pipelines integrating financial systems, CRM, the tax authorities and Microsoft Graph.
  • Led the migration of an AWS data lake to OCI, re-architecting storage, ingestion and processing without disrupting daily operations.
  • Built governed Snowflake ELT models and analytical layers for finance and commercial teams, with audit layers, deduplication and a real-time P&L tied to the ledger and payroll.
  • Cut operational effort by over 40% through modernisation, automation and GenAI. Coordinated cross-functional teams and mentored engineers.
2013 — present

Founder, Lead Data Engineer & Data Architect

Aragón Tecnologia

Data platforms and automation for clients in Brazil and Portugal, and a portfolio of SaaS products built and run end to end.

  • Event-driven pipelines with Kafka and a transactional outbox, streaming PostgreSQL changes into near-real-time KPIs and cross-product analytics.
  • Products in production: PsycoHub, NutriPro, Sola Beauty, Dockly and LaboraHub.
  • Re-platformed the fleet onto ARM64 (AWS Graviton) and built Jhonny, a voice-driven chief of staff that supervises a squad of AI agents.

education Postgraduate in Big Data & Analytics, UNISUL (in progress, 2024–2026) · Business Administration studies, UDESC

languages Portuguese (native) · English (C1) · Spanish (intermediate)

// recent

Recently shipped.

Operations work behind the products: cheaper infrastructure, accountable AI agents, and monitoring that watches itself.

ARM64 re-platform

Moved a multi-app production fleet from x86 to ARM64 (AWS Graviton) with no data loss. Each app was deployed and verified on the new platform before any traffic moved. CI stays on x64 and cross-packages the ARM builds of Prisma engines and native modules (sharp, canvas). Everything is defined in Terraform, and secrets move between hosts end-to-end encrypted. The AWS run-rate is about 60% lower.

AWSARM64TerraformFinOps

Jhonny: a squad of AI agents

A voice-driven chief of staff that supervises the AI coding agents working across my repositories. Each agent gets a weekly scorecard (delivery, rigour, reliability, autonomy) and a critical review. Two in-house agents keep watch on cloud cost and the security posture. A holographic HUD shows the whole squad orbiting the core in real time.

AI agentsMulti-agentVoiceNext.js

Monitoring that watches itself

Uptime, database health and TLS expiry are checked every five minutes, from outside the cloud they monitor, with alerts only when a state changes. A GitHub Actions watchdog confirms the monitor is alive, and the monitor confirms the watchdog in turn, so if the monitor goes silent, that silence is itself an alert.

ObservabilityGitHub ActionsTelegram

// work

Products I've built & operate.

Vertical SaaS through Aragón Tecnologia software and data architecture with applied AI, built for trust, security, and precision.

Full portfolio at aragontecnologia.com →

// open source

Engineering in the open.

Public data engineering projects: real patterns, tested and CI-checked, built in small reviewed pull requests. Synthetic data only.

kafka-retail-streaming

↗

Real-time retail events through Kafka (KRaft) and Spark Structured Streaming: windowed aggregations with watermarks, a dead-letter queue, an Iceberg sink with exactly-once semantics, and CDC with Postgres and Debezium.

KafkaSparkCDC

spark-retail-etl

↗

Production-shaped batch ETL with PySpark: incremental loads over a high-watermark, partitioned outputs, quality gates with volume anomaly detection, run summaries for observability, and architecture decision records.

PySparkData QualityCI

dbt-duckdb-analytics

↗

Analytics engineering with dbt and DuckDB: staging to marts with four layers of data tests, from column contracts and referential integrity to cross-layer revenue reconciliation. Runs end to end at zero cost.

dbtDuckDBTesting

terraform-aws-datalake

↗

Reusable Terraform module for an AWS data lake on S3, Glue and Athena: secure by default, plan-time input validation that mirrors the real API constraints, and fmt, validate and tflint gates in CI.

TerraformAWSIaC

airflow-retail-orchestration

↗

Apache Airflow orchestrating a retail medallion pipeline (bronze, silver, gold) with a data-quality gate, retries and idempotent backfills. Runs locally, no cloud.

AirflowMedallionData Quality

delta-lakehouse-mlflow

↗

A medallion lakehouse on Delta Lake feeding an MLflow-tracked churn model, over synthetic SaaS product-analytics data. Runs locally, no cloud.

Delta LakeMLflowLakehouse

kanban-streaming-metrics

↗

Kanban flow metrics on a live event stream: throughput, cycle time, WIP and percentile-based delivery forecasting with Kafka and PySpark Structured Streaming.

KafkaStreamingForecasting

data-mapping-framework

↗

Maps heterogeneous sources (CSV, JSON, SQL, Parquet) into a canonical model and runs business rules over it, splitting valid rows from rejects with every violated rule reported per row.

PythonPandasIntegrations

nl-to-sql

↗

Natural language to SQL with an LLM: the model proposes, a deterministic guard disposes. A minimal lexer normalizes each query and blocks anything that is not a single read-only SELECT.

LLMDuckDBSafety

meucomboio-pt

↗

A real product in the open: next-train departures and trip planning for Portugal on CP's open GTFS data. Daily sync pipeline with a quality gate, service-calendar aware planning, pricing from CP's public API, and a dbt analytics layer.

ProductGTFSdbt

inventario-familiar

↗

Self-hosted portal for families in an estate process: shared documents, automatic income splitting and individual statements. A dbt + DuckDB analytics layer sits on top, with a reconciliation gate that fails CI if a single cent goes unaccounted for. Synthetic data only.

ProductdbtPostgres

More on github.com/renatoaragon →

// contact

Let's build something.

Based in Porto and open to remote data engineering and architecture roles across the EU.