Wendy Chai
@wendychai
Analytics Developer specializing in SQL development, data modeling, and scalable pipeline optimization.
What I'm looking for
I’m an Analytics Developer with over 4 years of experience across analytics and data roles, specializing in SQL development, data modeling, and pipeline optimization. I focus on improving the reliability and usability of complex, legacy data backends.
In my current role, I led complex SQL development and optimization projects with independent ownership of legacy data areas to improve backend robustness and query performance. I built and maintained end-to-end data pipelines for global supply chain operations, acting as a primary point of contact for complex data issues.
I also develop KPI-focused Tableau dashboards and drive team alignment by documenting standard operating procedures (SOPs) and data workflows in Confluence and Miro. To reduce technical debt, I audited and cleaned large-scale datasets in Google BigQuery to prepare environments for future-state analytical models.
Previously, I managed APAC forecasting data processes, reduced reporting timelines through Power Query-based validation, and maintained Power BI dashboards for key stakeholders. Earlier, I automated data transformation with Python and SQL ETL scripts, monitored daily ETL operations, and ensured data integrity using Excel control workbooks with Power Query and VBA.
Experience
Work history, roles, and key accomplishments
Led complex SQL development and optimization projects by taking independent ownership of legacy data areas to improve backend robustness and query performance. Built and maintained end-to-end data pipelines and created Tableau dashboards for global supply chain KPI reporting while documenting SOPs and data workflows to support team collaboration.
Managed monthly data loading for FedEx APAC and MEISA marketing datasets, improving data validation and checks to reduce reporting timelines. Maintained Power BI dashboards, performed data reconciliation to ensure integrity across multiple sources, and supported air freight forecasting through market research and ad-hoc analysis.
Developed automation solutions for data transformation processes using Python and SQL, significantly reducing manual processing time to ensure timely data delivery for stakeholders. Wrote and debugged ETL scripts, monitored daily ETL operations against a five-day loading window, and maintained Excel control workbooks (Power Query and VBA) to validate post-load data integrity.
Education
Degrees, certifications, and relevant coursework
UCSI University
Bachelor of Science, Actuarial Science
Completed a Bachelor of Science in Actuarial Science at UCSI University in 2021.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Interested in hiring Wendy?
You can contact Wendy and 90k+ other talented remote workers on Himalayas.
Message WendyFind your dream job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
