Richard Guo
About Richard Guo
Richard Guo is a Lead Engineer with over 20 years of experience in ETL and ELT consulting. He has held various roles in notable organizations, including BMO, Scotiabank, and Next Pathway Inc., where he has contributed to significant data integration and transformation projects.
Work at Next Pathway Inc.
Richard Guo has been serving as Lead Engineer at Next Pathway Inc. since 2016. In this role, he focuses on developing advanced data solutions and engineering practices. His responsibilities include leading projects that involve the migration of data warehouses to cloud-based platforms, ensuring efficient data integration and transformation.
Previous Experience in Data Engineering
Prior to his current position, Richard Guo held several roles in data engineering and analytics. He worked at BMO as a Senior ETL and Big Data Consultant from 2014 to 2016, and at Scotiabank as a Senior Programmer Analyst from 2011 to 2014. He also had a brief tenure at Wal-Mart Canada as a Senior Data Warehouse Developer in 2012 and worked as an Analyst at Munich Reinsurance America, Inc. from 2010 to 2011.
Board Membership at Toronto Big Data Professionals Association
Richard Guo served on the Board of Directors for the Toronto Big Data Professionals Association from 2016 to 2020. His involvement in this organization reflects his commitment to the data community and his efforts to promote best practices in big data technologies.
Education and Expertise in Computer Science
Richard Guo studied Computer Science at East China Normal University, where he earned his Bachelor’s degree from 1992 to 1996. His educational background laid the foundation for his extensive career in data engineering, which spans over 20 years, focusing on ETL and ELT consulting.
Technical Contributions and Innovations
Richard Guo has made significant contributions to data engineering through various projects. He led the design and development of a SQL translation engine that converts traditional data warehouse SQL to modern platforms like Hadoop and cloud solutions. Additionally, he designed a Retail Credit Risk Report using technologies such as Hadoop and Spark, and developed a code generation engine that automates Spark code creation from ETL repositories.