Liau Jiang Jie
Data Analyst/ Data Engineer
Subang Jaya
Summary
Knowledgeable Data Engineer with robust background in data architecture and pipeline development. Proven ability to streamline data processes and enhance data integrity through innovative solutions. Demonstrates advanced proficiency in SQL and Python, leveraging these skills to support cross-functional teams and drive data-driven decision-making.
Overview
4
4
years of professional experience
Work History
Data Engineer
Cipta X Sdn Bhd
07.2024 - Current
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
- Built interactive dashboards using Tableau / Superset to support business decision-making and translated business requirements into data visualizations and KPI reports.
- Scheduled and orchestrated data pipelines using Apache Airflow, ensuring timely data availability.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
Account Support Analyst
NCR
06.2023 - 06.2024
- Run Daily, Weekly, Monthly, Customize, and ad hoc reports when required; Gather information for the Critical Care Process when needed such as perform root cause business analysis of problems
- Queried databases for information needed for report processing.
- Streamlined reporting procedures by creating user-friendly dashboards for easy access to key performance indicators.
- Enhanced customer satisfaction rates through detailed analysis of customer feedback data and subsequent improvements in service offerings.
- Bangsar South
Data Analyst
Publicis Groupe
09.2022 - 11.2022
- Analytics setup - implementation of data tracking for social analytics and web analytics
- Data processing - data prep including data cleansing, standardization, etc
- Data analysis - deriving insights out of a given dataset
- Reporting - both automated and manual reporting which may include numbers crunching.
- Internship, Kuala Lumpur
Education
Bachelor of Science - Information System
Sunway University
Subang Jaya, Selangor, Malaysia11-2022
Skills
Technical Skills
ETL Development & Data Pipeline Design
Data Warehousing
SQL (Query Optimization, Indexing)
Python (Data Processing, API Development)
RESTful APIs & JSON Handling
Data Analysis & Visualization
Dashboard Design & Data Storytelling
Data Engineering
Apache Airflow (Workflow Orchestration)
Apache Kafka (Streaming)
Databricks / Apache Spark
Meltano
Cloud & Platforms
AWS
Salesforce (https://trailblazerme/id/ljiangjie)
BI & Analytics Tools
Tableau
Apache Superset
Google Analytics / Data Studio
SAS software
Tools
Opencode (GLM model under ZAi)
Docker
GitHub (Version Control and CI/CD Development)
VS code
HeidiSQL
PuTTY
Postman
Timeline
Data Engineer
Cipta X Sdn Bhd
07.2024 - Current
Account Support Analyst
NCR
06.2023 - 06.2024
Data Analyst
Publicis Groupe
09.2022 - 11.2022
Bachelor of Science - Information System
Sunway University