Yanru Zhou
About Yanru Zhou
Yanru Zhou is a Software Engineer at Quantcast, specializing in ETL processes and interactive reporting. She holds a Bachelor's degree in Biology from Chongqing University and a Master's degree in Business Intelligence and Analytics from Stevens Institute of Technology.
Work at Quantcast
Yanru Zhou has been employed at Quantcast as a Software Engineer since 2020. In this role, she focuses on utilizing SQL Server Integration Services (SSIS) to perform ETL processes. Her work involves efficiently gathering and matching data from various source and target systems, contributing to the company's data management and analytics capabilities.
Education and Expertise
Yanru Zhou holds a Bachelor's degree in Biology/Biological Sciences from Chongqing University, which she completed from 2010 to 2014. She furthered her education at Stevens Institute of Technology, earning a Master's degree in Business Intelligence and Analytics between 2016 and 2018. Her academic background supports her expertise in data analysis and business intelligence.
Previous Experience at Anthem, Inc.
Before joining Quantcast, Yanru Zhou worked at Anthem, Inc. as a Business Intelligence Developer for a period of four months in 2019 to 2020. In this role, she contributed to data analysis and reporting efforts, enhancing the organization’s ability to leverage data for decision-making.
Analyst Role at Citi
Yanru Zhou began her career as an Analyst at Citi, where she worked for one year in Shanghai, China, from 2015 to 2016. This position provided her with foundational experience in data analysis and reporting, which has been instrumental in her subsequent roles.
Technical Skills and Specializations
Yanru Zhou specializes in creating interactive reports using Tableau, which helps stakeholders gain clear visual insights from data. She has expertise in developing business relationships to understand and implement business requirements effectively. Additionally, she is experienced in writing complex SQL queries, including stored procedures, user-defined functions (UDFs), and triggers, to enhance report performance.