Rafael Ignaulin

Portland, OR (Remote)

• Cut Spark data reads 98% (multi-terabyte per run down to tens of GB), cutting AWS costs 70%.
• Automated A/B test measurement with Airflow: 99.5% faster, weeks to minutes, ~50x more iterations.
• Own the clickstream fact table (billions of rows, hundreds of GB, millions of rows added daily) powering Marketing and Digital Experience analytics on Databricks/Spark/Airflow.
• Built an LLM analytics agent (Claude Sonnet, Streamlit, MLflow) turning plain-English questions into SQL, with confidence scoring on every answer.
• Built a FastMCP/FastAPI server exposing a dozen-plus analytics tools to Cursor via YAML-based tool registration — no code changes to add a tool.
• Contributed a dozen loader classes to the team's Databricks/Airflow job library (task orchestration, Delta load/validate, A/B testing, freshness checks).
• Debugged a large production analytics API: root-caused routing/table/RLS bugs and built a cache-validation test suite covering dozens of metrics.

São Paulo, Brazil (Remote)

• Own end-to-end a client segmentation and advisor-allocation platform (Spark, Kafka, Delta Lake) impacting 40M+ customers at a digital bank.
• Built a 6-zone medallion lakehouse on S3/Delta Lake, orchestrated by Airflow across EMR and Kubernetes, across 8 repositories.
• Designed CDC ingestion (Kafka/MSK, Debezium) and a real-time update engine keeping segmentation current every 15-20 minutes.
• Built a reusable data-quality framework adopted across every ingestion pipeline on the platform.
• Designed the advisor-allocation algorithm and set the engineering standards (testing, CI/CD, alerting) across the team's 8 repositories.
• Progressed Mid-Level → Senior → Lead across the engagement.

Remote — Global

• Founded the B2B consultancy all contract work above runs through — Data Warehouses, Lakes, and Lakehouses on AWS/Azure with Spark, Kafka, Airflow, Terraform.
• Delivered from 15+ countries across 6+ timezones while holding enterprise contracts, always aligned to client hours.

São Paulo, Brazil (Remote)

• Designed and tuned Amazon Redshift Data Warehouse with star/snowflake schemas, optimizing queries across 20+ tables with billions of rows for 10x performance gain.
• Promoted Junior → Mid-Level; transitioned out in Oct 2024 as isTech contract work became the focus.