•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%.