
Jay
Full Stack Data Engineer, ETL, APIs and BI Automation
Skills

Bekijk mijn diensten


Portfolio
Werkervaring
Automated Data Workflow & Reporting System
HSBC • Fulltime
Jan 2024 - Apr 2026 • 2 yrs 3 mos
Built an end-to-end automated data workflow system for collecting, processing, and visualizing business data from multiple sources. The project included API integrations, automated ETL pipelines, structured database storage, and dashboard reporting. Implemented scalable data processing workflows using Python, Spark, SQL, and cloud-based solutions. Connected APIs and databases to automate recurring reporting tasks and business analytics workflows. Designed interactive Power BI dashboards with KPI tracking, automated reporting, and real-time business insights to support operational and management decisions.
Data Lead
Tencent Holdings • Fulltime
Nov 2018 - Nov 2023 • 5 yrs
Driving the end-to-end delivery of anenterprise-grade analytics platform to enable large-scale digital transformation anddata-driven decision-making. Designed real-time analytics frameworks that improved production efficiency by 15% and achieved over RMB 1M in annual cost savings through effective targeting andoptimization. Managed cross-functional teams, aligned business requirements, and led taskplanning and stakeholder communication to ensure successful implementation ofanalytics solutions with well-defined performance measurements. Built a PB-scale data warehousing layer supporting ACID analytics and self-service BIreporting, empowering business users to independently explore data and track state-of-business priorities.
Data engineer
Alibaba • Fulltime
Jun 2014 - Nov 2018 • 4 yrs 5 mos
Designed and built an enterprise data platform integrating ERP, CRM, and IoT data tomap end-to-end customer engagement journeys and support omni-channel e-commerce strategies. Developed Tableau visualization systems and business analysis models using Kylinand Impala to track performance marketing, measure campaign success, and supportdata-driven decision making. Implemented a scalable data warehouse and recommendation system to enable real-time insights, identifying opportunities for business growth potential and userconversion. Conducted quantitative analysis to resolve large-scale data skew and data qualityissues, reducing ETL failure rates by 40%+ and improving query latency to sub-10seconds for seamless business reporting.