• Designed and maintained scalable ETL pipelines using SQL and AWS (Redshift, Glue, S3, Lambda), improving data processing efficiency by 50%.
• Optimized SQL queries and transformations to support real-time analytics across multiple programs.
• Automated ingestion and cleaning of large datasets, reducing manual intervention by 40% and improving reliability.
• Conducted integrity audits, identifying anomalies and reducing error rates by 20%.
• Collaborated with analytics and compliance teams to ensure outputs aligned with city-wide standards.
• Authored documentation and usage policies, improving team adoption by 30%.