Cake Job Search

1.數據架構與ETL開發 i.數據整合：將分散在各部門的原始數據彙總志資料倉庫。 ii.資料建模：建立資料模型，確保查詢效率與數據一致性。 iii.資料品質監控：建立數據稽核機制，確保看板上的數據準確性，並與各單位的數據窗口對接校正。2.視覺化看板設計與維護 i.需求分析：與經營管理者溝通，理解業務痛點，並將其轉化為關鍵績效指標。 ii.看板開發：使用BI工具設計互動式儀錶板，提供即時、直觀的業務分析。 iii.報表自動化：將過往耗費人力手作的Excel報表自動化，提升各單位提供數據的效率。3.商業洞察與分析支持 i.異常偵測：透過數據監控發現業務異常點（如生產良率下滑、庫存週轉異常），主動向決策者提供預警。 ii.專案協作：擔任數位轉型小組的技術核心，協助各部門種子人員理解數據意義，並指導其使用 BI工具。4.系統優化與文件化 i.效能調校：持續優化 SQL 查詢與資料庫索引，確保大數據量下的報表載入速度。 ii.技術文件：編寫數據字典與作業標準書，確保數據定義在公司內部達成共識。

- Set up and execute extract, transformation, and load (ETL) functions to build a data pipeline.- Extraction and analysis of large data sets from MySQL.- Performance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilized.- Delivering clear analysis and reporting of core business metrics to shareholders.- Creation and management of reports and dashboards.- Data management.- Enhance and optimize existing reporting processes.- Ad hoc analysis and reporting to clients and shareholders.- Aid in reconfiguring existing architecture and database structure to address our shareholder's evolving needs.- Daily maintenance and monitoring of all BI-related databases and dashboards, including proficient handling of emergencies.- Providing actionable insight to drive the growth of core products.Our Stack MySQL (Must)Python (Good to have)AirFlow (Good to have)AWS (Good to have)Metabase (Good to have)Redshift (Good to have)Linux (Good to have)