Data Analyst, Catalog Onboarding 商品目錄分析師
Summary
Develops SQL queries, maintains ETL pipelines, and analyzes catalog data to ensure data integrity. Automates workflows, builds dashboards, and applies generative AI to support decision-making in an e-commerce environment.
What will you do?
- 開發與最佳化 SQL 查詢,協助團隊快速且準確地取得商品目錄與營運資料,並改善查詢效能。
- 維護 ETL 資料流程,涵蓋資料擷取、轉換、驗證與載入,確保流程能穩定執行,並妥善處理失敗、重跑與異常狀況。
- 整合來自不同來源的商品資料,處理欄位對應、格式不一致、重複紀錄及資料衝突等問題,提升資料的一致性與可用性。
- 建立資料品質檢核機制,追蹤並調查資料完整性問題,釐清問題責任與處理方式,並與相關利害關係人合作完成修正。
- 自動化日常資料作業與分析流程,減少重複性人工操作,並為流程加入資料驗證、監控及例外處理機制。
- 建立並分析營運指標、儀表板與報表,從數據中找出異常、趨勢及問題根因,提出具體且能被執行的改善建議。
Basic Qualifications
- 具備 SQL 查詢開發經驗,能處理較複雜的資料查詢,並可針對查詢效能進行分析與最佳化。
- 具備 ETL 或資料管線的開發、維護經驗,了解資料擷取、轉換、驗證、載入及異常處理的完整流程。
- 能整合及分析多來源的結構化資料,並處理欄位差異、資料格式、重複值與衝突紀錄。
- 對資料品質具有責任感,能建立驗證規則、追蹤問題、分析原因,並推動問題修復。
- 具備資料流程自動化經驗,能將重複性工作轉換為可執行、可驗證且可監控的流程。
- 能從資料中辨識模式與異常,建立可驗證的假設,並審慎區分相關性與真正的問題根因。
- 能將營運需求轉換為清楚的指標、分析結果及行動建議。
- 具備儀表板或商業報表開發經驗,能從使用者需求及指標定義出發,完成資料驗證與結果呈現。
- 曾在資料工作流程中使用生成式 AI 或提示工程,並具備檢查輸出、辨識錯誤及調整提示內容的實際經驗。
- 能獨立安排工作優先順序、管理交付內容及相依事項,並在發現風險時主動溝通與升級。
- 具備商務英文能力
Preferred Qualifications
- 具備 2年以上 SQL 與 Python 相關實務經驗。
- 熟悉 Python,並曾用於資料讀取、清理、轉換、驗證、除錯或流程自動化。
- 曾建置 Google Sheets 自動化流程,或使用 Google Sheets 進行營運資料追蹤、更新與驗證。
- 能閱讀 SQL query plan,並曾透過索引調整、查詢邏輯改善或降低資料掃描量來提升效能。
- 曾負責端到端資料管線,包括資料擷取、轉換、驗證、載入、監控與失敗復原。
- 曾將人工或重複性資料作業,改造成可執行、可自動驗證且便於後續維護的流程。
- 曾針對生成式 AI 的提示方式進行測試,並比較不同提示對輸出品質、穩定性或可重現性的影響。
- 曾獨立完成儀表板或報表,包含釐清業務問題、定義指標、選擇呈現方式、安排資料更新及驗證輸出結果。
- 具備商品資料、產品資料、主資料或其他多來源結構化資料的比對、標準化與品質分析經驗。
- 能清楚說明自己直接負責的範圍、交付成果、相依關係、問題升級界線及最終影響。
招募流程
- 履歷審查 → 電話面談 → 線上面試 → 錄取通知
- 實際流程可能依職位需求、面試安排或其他情況有所調整。
- 面試時程與結果將透過應徵時提供的電子郵件地址通知。
招募流程
- 若職缺提前招募額滿,本職缺可能於原定截止日前關閉。
- 若應徵者於申請或面試過程中提供不實資訊,Coupang 有權撤回錄取通知。
- 符合法定就業保障資格者,將依適用法令辦理。
Skills
As published by greenhouse · 16 questions
Basics
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter, Location
Short answers (4)
- LinkedIn Profile optional
- - Name of Relative(s) / 親屬姓名: optional
- - Relationship / 關係: optional
- - Working Org / Team / 任職組織/團隊: optional
Pick from a list (12)
- Coupang Corporation or its affiliates and subsidiaries* (or collectively referred to as “Coupang”) does not collect, process or use any personal information other than the types of information specified in this Consent. Please ensure that your resume does not include any personal information other than the types specified in this Consent.
- 1. What is your nationality?
- 1. (Required) By submitting your resume, you consent to the required collection, processing, use, required provision/transfer, and consignment of personal information as set forth in our Privacy Policy (https://privacy.coupang.com/en/land/jobs/).
- 2. (Optional) Name, contact information, email address, nationality, educational background, work experience, qualifications, national merit status (for special hiring program applicants only), relative’s name/relationship/team and application history are collected and used on an ongoing basis for recruitment purposes and may be provided to any of our affiliates and subsidiaries*, other than the company to which you originally applied, for the purpose of reviewing and conducting recruitment for similar positions. Personal information collected and provided will be retained for the duration of the year-round recruitment retention period defined in the Privacy Policy. You may refuse to provide consent, but such refusal may prevent the year-round hiring from progressing normally or may result in the restriction of opportunities in the hiring process of companies other than the one you applied.
- 3. (Optional) Recordings of the interview process and transcriptions of interview audio maybe collected and used for the following purposes: i) to record the interview process, ii) to transcribe and document interview audio, iii) to summarize interview results, iv) to verify the interview process and evaluation results, v) to improve the hiring procedures, vi) to check candidate fit for other open positions, vii) to review past interview records. Collected personal information are retained for 4 years from the notification of hiring result, and then deleted. You may refuse to provide this consent, and refusal will not affect the recruitment process.
- 4. (Optional) Coupang or its affiliate or subsidiary company* will send recruitment notifications through transmission media such as phone, email, and SMS using the contact information and email address based on your consent.
- 5. (Optional) Coupang or its affiliate or subsidiary company* will conduct reference checks on you within the following scope based on your consent: Additional reference checks may be conducted on applicants who applied for a job at Coupang and passed interviews, and Coupang arranges means to conduct reference checks. Coupang may collect other personal information about you, including integrity information collected from public sources and the performance evaluation information collected from your former employer or colleagues.
- 1. I understand that working with Relatives in the Coupang group of companies (collectively, the "Coupang Group") -- where they can influence each other’s work -- can potentially create conflicts of interest. Therefore, such a situation requires prior approval from the People Operations. In view of the above, I hereby confirm that I DO NOT have any Relatives working in any company within the Coupang Group or serving on the Board of Directors of any company within the Coupang Group;
- 1. Are you currently, or have you been a government official, public servant, or employee of a public institution who may be subject to post employment or reemployment restrictions under applicable laws or regulations?
- 2. Do you acknowledge and agree that where required under applicable laws or regulations: optional
- You have the right to inquire/access, request a copy, supplement/correct, delete, suspend the collection, processing, or use and suspend the transfer of your personal information that Coupang holds. Exercising certain rights, such as deletion of personal information, may result in the restriction of the hiring process. If you wish to exercise any of these choices, please contact our privacy representative at [candidatedataremove@coupang.com].
- Document Policy