Franz Renzo C.

🚀 Data Engineer | Medallion Architecture | Cloud ETL | Large-Scale Data Migration I help companies turn fragmented, messy data into reliable, analytics-ready datasets using modern data engineering best practices. I’m a Data Engineer with 4+ years of experience designing, migrating, and operating scalable data pipelines across AWS and Alibaba Cloud, with deep hands-on experience delivering production-grade data platforms using the Medallion Architecture (Bronze / Silver / Gold). I’ve led and executed large-scale migrations (3,000+ tables & pipelines) from APIs, SFTP/static files, SQL, and NoSQL systems into cloud data warehouses—ensuring data quality, automation, and long-term maintainability. 🏗 What I Specialize In - End-to-End Data Pipelines (ETL / ELT) - Batch & incremental ingestion (historical backfill + CDC-style updates) - APIs, SFTP, OSS/S3, SQL & NoSQL sources - Python, SQL, Pandas, PySpark–based transformations - Fully automated pipelines with validation & monitoring 🏛 Scalable Architecture I design data platforms using a clear, scalable architecture - From Ingested data stored as-is for traceability and replay to Curated, business-ready tables optimized for BI & reporting ☁ Cloud & Big Data Platforms AWS and Alibaba Cloud (Cloud environment), AWS Glue, Databricks and Alibaba Data Studio (ETL & orchestration), Amazon Redshift and Alibaba MaxCompute (Data Warehousing), OSS and S3 (Cloud Object Storage), QuickSight and PowerBI (Data Visualizations) I’m comfortable working in hybrid and multi-cloud environments and migrating legacy workflows into modern cloud-native architectures. 📊 Analytics-Ready Data Delivery -Dimensional modeling (fact & dimension tables) -Performance-optimized warehouse designs BI-ready datasets for: AWS QuickSight, Power BI / Power BI Service, Excel dashboards -Clear documentation for analysts and stakeholders 🧪 Data Quality, Reliability & Operations -Reusable data quality frameworks: Null checks, Duplicate detection, Schema & type validation -Unit testing & system integration testing for pipelines -Automated backfilling, archiving, and recovery -Monitoring, alerting, and operational runbooks 🧠 Real-World Experience Highlights -Migrated 3,000+ tables and pipelines from heterogeneous systems into cloud data platforms -Led a year-long fintech migration program, coordinating 10+ data engineers -Replaced manual and Alteryx-based workflows with scalable AWS Glue pipelines -Delivered large-scale analytics datasets into Amazon Redshift and Alibaba MaxCompute -Solved real production issues related to partitions, storage states, and pipeline failures 🛠 Tech Stack Snapshot -Languages & Scripting: Python, SQL, PySpark, Pandas, RegEx -ETL & Orchestration: AWS Glue, Alibaba Data Studio, DataWorks, Alteryx, Custom ETL -Data Warehousing: Amazon Redshift, Alibaba MaxCompute, SQL / NoSQL Databases -BI & Reporting: AWS QuickSight, Power BI, Excel Dashboards -Other: Data modeling, pipeline automation, backfilling, documentation, team leadership How I Work: ✅ Production-first mindset ✅ Clean, maintainable pipelines ✅ Clear communication with technical & non-technical teams ✅ Comfortable owning complex migrations end-to-end I don’t just “move data.” I build data systems that teams can trust. 💬 Let’s talk about your data platform. Whether you need a one-time migration, a new Medallion-based warehouse, or help stabilizing existing pipelines—I can help.