Jiahu i Chen

Part of the Data Analytics group responsible for building data pipelines and backend services that transformed large-scale log data into actionable insights for business operations and engineering teams. Designed and optimized SQL Server schemas, indexes, and views to serve as the foundation for backend reporting services, improving query performance and enabling reliable data retrieval for applications. Developed Python-based ETL and validation scripts to automate ingestion and cleansing of log data, integrating results into downstream APIs and dashboards while reducing data errors by ~35%. Contributed to internal backend tooling by creating RESTful endpoints to expose curated datasets for analytics and visualization platforms (Tableau, React dashboards). Collaborated with data engineers and backend developers to integrate logging pipelines with service-oriented systems, ensuring data quality, scalability, and timely delivery to stakeholders.

Part of the Data Analytics group responsible for building data pipelines and backend services that transformed large-scale log data into actionable insights for business operations and engineering teams. Designed and optimized SQL Server schemas, indexes, and views to serve as the foundation for backend reporting services, improving query performance and enabling reliable data retrieval for applications. Developed Python-based ETL and validation scripts to automate ingestion and cleansing of log data, integrating results into downstream APIs and dashboards while reducing data errors by ~35%. Contributed to internal backend tooling by creating RESTful endpoints to expose curated datasets for analytics and visualization platforms (Tableau, React dashboards). Collaborated with data engineers and backend developers to integrate logging pipelines with service-oriented systems, ensuring data quality, scalability, and timely delivery to stakeholders.

Developed Splunk queries to structure raw log data and collaborated with data engineering teams to design schemas and views in SQL Server. Created interactive data visualizations using React and Tableau to deliver actionable insights for stakeholders. Implemented Python scripts for data validation, successfully reducing errors by approximately 35%.