Jialu Yan

Data Solutions Manager @Monks

New York, NY, US

Designed and maintained automated data pipelines to support marketing performance reporting across multiple clients, including SC Johnson, Hulu, Helen of Troy, and The Estée Lauder Companies - Built end-to-end campaign data workflows using Tracer, GCP, BigQuery, and Looker, enabling scalable cross-channel reporting and reducing manual data processing - Helped clients rebuild or update their taxonomy mappings, streamlining integration of campaign metadata from clients to internal systems - Optimized ads tagging system in Tracer to improve consistency and accuracy in campaign classification, significantly enhancing data quality in downstream dashboards and reports - Developed modular dashboards and client-ready reporting templates to support paid media measurement, creative testing, and KPI tracking - Partnered with marketing strategists and data analysts to translate business goals into reliable, actionable data deliverables - Created custom data QA processes and validation layers to ensure consistency and accuracy across large-scale campaign data - Led onboarding and enablement sessions for both clients and internal teams across taxonomy mapping platform, new taxonomy standards, BigQuery tables, and GCP dashboards, ensuring alignment on data structure, flow, and reporting logic

The University of Akron

Master of Science (MS), Polymer Science

Stevens Institute of Technology

Master of Science (MS), Business Intelligence and Analytics

East China University of Science and Technology

Bachelor of Engineering (BE), Polymer Materials and Engineering