三峰科技有限公司
[外資] 資料庫和ETL開發人員-顧問
9/19 Updated
Array
Full-time
Entry-level
English Required
6 ~ 10 applicants

Salary & Location

Monthly SalaryNT$ 35,000~45,000
高雄市鼓山區

Required

Language Requirements
English
聽/中等、說/略懂、讀/中等、寫/中等
Work Experience
不拘

Job Description

我們提供具有競爭力的薪資、全面的福利計劃以及專業增長和發展的機會。如果您是一位高度積極的個人,喜歡在充滿活力和快節奏的環境中工作,請提交您的簡歷和求職信以供考慮。
Job Summary:
We are seeking a skilled DB (Database) and ETL (Extract, Transform, Load) Developer with 2-3 years of experience to join our team. The successful candidate will be responsible for designing, developing, and maintaining databases and ETL processes. This role requires a strong understanding of database management systems, ETL tools, and data integration concepts. The ideal candidate should have a proven track record in implementing robust and efficient database solutions and ETL workflows.
職位摘要:
我們正在尋找一位具有2-3年經驗的熟練DB(資料庫)和ETL(資料抽取、轉換、加載)開發人員加入我們的團隊。成功的候選人將負責設計、開發和維護資料庫和ETL流程。該職位需要對資料庫管理系統、ETL工具和數據整合概念有深入的了解。理想的候選人應具有在實施強大高效的資料庫解決方案和ETL工作流方面的成功經驗。
Responsibilities:
Design and develop database solutions:
Create and maintain database schemas, tables, indexes, and views.
Optimize database performance and ensure data integrity.
Implement data storage and retrieval strategies for efficient data access.
Collaborate with stakeholders to gather database requirements and translate them into technical specifications.
Develop and maintain ETL processes:
Design and implement ETL workflows to extract data from various sources, transform it according to business rules, and load it into destination systems.
Develop data mapping and transformation logic to ensure data consistency and quality.
Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner.
Perform data validation and reconciliation to ensure accurate data integration.
Develop and maintain ETL processes:
Design and implement ETL workflows to extract data from various sources, transform it according to business rules, and load it into destination systems.
Develop data mapping and transformation logic to ensure data consistency and quality.
Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner.
Perform data validation and reconciliation to ensure accurate data integration.
Data integration and automation:
Collaborate with cross-functional teams to integrate data from different systems and sources.
Identify and implement automation opportunities to streamline ETL processes and improve efficiency.
Develop and maintain data integration interfaces and APIs.
Performance tuning and optimization:
Identify and resolve performance bottlenecks in databases and ETL processes.
Optimize queries and data retrieval to enhance system performance.
Analyze and interpret query execution plans to optimize database performance.
Documentation and reporting:
Create and maintain technical documentation related to database schemas, ETL processes, and data flows.
Generate reports and provide insights on data quality, system performance, and data integration
職責:
設計和開發資料庫解決方案:
創建和維護資料庫結構、表格、索引和視圖。
優化資料庫性能,確保數據的完整性。
實施數據存儲和檢索策略,以實現高效的數據訪問。
與利益相關者合作,收集資料庫需求並將其轉化為技術規格。
開發和維護ETL流程:
設計和實施ETL工作流程,從各種來源提取數據,根據業務規則進行轉換,並將其加載到目標系統。
開發數據映射和轉換邏輯,以確保數據的一致性和質量。
監控和解決ETL流程中的問題,及時識別並解決問題。
執行數據驗證和對賬,以確保準確的數據整合。
性能調優和優化:
識別並解決資料庫和ETL流程中的性能瓶頸。
優化查詢和數據檢索,提升系統性能。
分析和解讀查詢執行計劃,優化資料庫性能。
文件記錄和報告:
建立並維護與資料庫結構、ETL流程和數據流相關的技術文件。
生成報告,提供有關數據質量、系統性能和數據整合指標的見解。
Requirements:
Bachelor's degree in Computer Science, Information Systems, or a related field.
1-3 years of experience as a DB and ETL Developer or similar role.
Strong knowledge of database concepts, SQL, and database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).
要求:
計算機科學、信息系統或相關領域的學士學位。
1-3年作為資料庫和ETL開發人員或類似角色的經驗。
對資料庫概念、SQL和資料庫管理系統(例如Oracle、SQL Server、MySQL、PostgreSQL)有較深入的了解。
Self-Motivation and Learning:
Self-driven individual with a passion for continuous learning and staying up-to-date with industry trends and technologies.
注重細節:
高度注重細節,以確保數據的準確性和質量。
在記錄流程和維護技術文檔方面非常細致。
Educational Requirements
專科以上
Work Schedule
9:00-18:00
Leave Policy
依公司規定

Job Skills

Reviewing financial statements
Financial and business analysis
Reviewing annual budgets
Preparing financial reports
Analyzing managerial accounting information
核閱財務報表 財務及營業分析 審核年度預算 編制財務報告 分析管理會計資訊
Job Category
Data Analyst
Data Engineer
Database Administrator
三峰科技有限公司期待熱誠、積極的工作夥伴共同成長,我們相信團隊合作、信任和合作。我們培養個人發展、參與和合作。我們提倡相互尊重,重視團隊和客戶的反饋,以實現共同成功。歡迎您加入我們的行列。 憑藉多年的專業知識,我們提供銳利的分析洞察來應對客戶挑戰。我們擅長理解獨特的需求並提出正確的問題。我們專注於提供高質量、有效的解決方案,以實現實際成果。 我們的直截了當、實事求是的方法是以結果為導向的。我們提供誠實且可實現的解決方案,避免模糊或令人困惑的答案。你看到的就是你得到的。 三峰科技具有豐富的經驗,轉型全球投資經理、顧問和投資者的前至後台業務。我們的客戶包括全球頂尖的私募股權、房地產、對沖基金和基礎設施。我們的服務套件利用行業最有效的科技平台,打造精簡高效的運營模式。 We offer a competitive salary, comprehensive benefits package, and opportunities for professional growth and development. If you are a highly motivated individual who enjoys working in a dynamic and fast-paced environment, please submit your resume and cover letter for consideration. 我們提供具有競爭力的薪資、全面的福利計劃,以及專業增長和發展的機會。如果您是一位高度積極的個人,喜歡在充滿活力和快節奏的環境中工作,請提交您的簡歷和求職信以供考慮。
6 ~ 10 applicants