Aiqing Lan
Data Crawling Engineer at SkyHive- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Japanese Elementary proficiency
-
English Professional working proficiency
-
Chinese Native or bilingual proficiency
Topline Score
Bio
Experience
-
SkyHive
-
United States
-
Software Development
-
1 - 100 Employee
-
Data Crawling Engineer
-
Jun 2022 - Present
-
-
-
AMZing Marketing Agency -> Amazon Marketing & SEO Experts
-
Canada
-
Advertising Services
-
1 - 100 Employee
-
Data Specialist, Digital Marketing
-
Jul 2021 - Present
*Data expert in the company, collecting, processing, storing, querying, analyzing and visualizing digital marketing data (from ‘raw’ to database and from database to visualization)*Built ETL data pipelines including extracting data (using API or web scraping), cleaning data, creating tables in databases and loading data into databases.*Designing and building the company’s data warehouse from scratch in local server and cloud environment using MySQL/NoSQL*Used Excel, Tableau or Power BI to generate visualized report or interactive dashboard based on data queried from databases*Using machine learning technique to optimize the performance of digital campaigns*Amazon Merchant Service expert that provides consultation for amazon sellers of different backgrounds.
-
-
-
-
Data Engineer
-
Apr 2021 - Mar 2022
*Wrote Python codes to improve the efficiency of data processing procedure in the ETL pipeline. It includes web scraping, language processing, image processing, and API.*Troubleshooting for Python codes written by external contractors*Did Search Engine Optimization research for consumer goods*Managed product data of more than 10 thousand products on E-commerce websites *Wrote Python codes to improve the efficiency of data processing procedure in the ETL pipeline. It includes web scraping, language processing, image processing, and API.*Troubleshooting for Python codes written by external contractors*Did Search Engine Optimization research for consumer goods*Managed product data of more than 10 thousand products on E-commerce websites
-
-
-
Kelowna & District Share Society
-
Canada
-
Non-profit Organizations
-
1 - 100 Employee
-
Data Technician (Volunteer in Non-Profit)
-
Sep 2020 - Dec 2020
*Used MS Office and Libre Office (Linux) to create electronic forms and process data for charity programs*Fixed Linux system issues in admin office of the store *Used MS Office and Libre Office (Linux) to create electronic forms and process data for charity programs*Fixed Linux system issues in admin office of the store
-
-
-
The University of British Columbia
-
Canada
-
Higher Education
-
700 & Above Employee
-
PHD Student/Candidate
-
Sep 2016 - Dec 2019
*Data Modeling, Analysis and Visualization on Efficient Fast Refill of Compressed Natural Gas*System Design and Mathematical Calculation for a Novel Electronic Cooling Technique on Micro-structured Surfaces *Data Modeling, Analysis and Visualization on Efficient Fast Refill of Compressed Natural Gas*System Design and Mathematical Calculation for a Novel Electronic Cooling Technique on Micro-structured Surfaces
-
-
Education
-
The University of British Columbia
Master's degree, Mechanical Engineering -
Xi'an Jiaotong University
Master's degree, Power Engineering -
MIANYANG HIGH SCHOOL
High School Diploma, Top 0.3% in National College Entrance Exam -
Xi'an Jiaotong University
Bachelor's degree, Energy and Power Engineering & Automation -
National Tsing Hua University
Visiting Student