Avatar of Jack Lin.
Jack Lin
Data Engineer
Profile
Posts
18Connections
Print
Avatar of the user.

Jack Lin

Data Engineer
- Design and deploy BI visualization and report - Evaluate and improve existing BI system - ETL for data processing
寶雅國際股份有限公司
淡江大學
台灣新北市板橋區新北市

Professional Background

  • Current status
    Employed
  • Profession
    Data Engineer
  • Fields
    Retail
  • Work experience
    4-6 years (4-6 years relevant)
  • Management
    I've had experience in managing 1-5 people
  • Skills
    Power BI
    sql語言
    Excel
    Trinity
    Python
    MySQL
    MongoDB
  • Languages
    English
    Intermediate
  • Highest level of education
    Bachelor

Job search preferences

  • Desired job type
    Full-time
    Interested in working remotely
  • Desired positions
    大數據分析,資料科學家,資料工程師,AI工程師
  • Desired work locations
    Taipei City, Taiwan
  • Freelance
    Part-time freelancer

Work Experience

資料工程師

May 2018 - Present
2018年 導入Power BI建立部門BI儀表板 ✔ PowerQuery資料清理 ✔ PowerPiviot(DAX)資料建模 ✔ PowerView視覺化報表 ✔ Power BI報表開發、維護、效能調校 2020年 整合數據資料庫 ✔ SQL、Python清洗內部營運資料庫 ✔ MySQL資料庫建置、資料維護、定期備份、效能調教 2022年 導入Trinity ETL建立Data Flow 目的:確保資料間正確性 ✔ 提案採購伺服器 ✔ 提案採購ETL Trinity工具 ✔ 規劃數據管線、資料相依性 ✔ Trinity ETL設計、JCS排程管理 ✔ LineAPI自動化提醒 ✔ API資料串接(91APP、蝦皮、沃提利) 2023年 導入Greenplum資料倉儲 目的:提升大數據應用即時性 ✔ 提案採購Greenplum分散式資料庫 ✔ Power BI API串接 ✔ 建立Power BI DataMart資料集 ✔ Power BI透過Direct Query優化更新效率

Education

Bachelor’s Degree
資訊創新與科技學系通訊組
2009 - 2014