Bachelor's degree or above in a related field (Computer Science, Information Systems, Statistics, Mathematics).
5+ years of experience in Data Engineering, ETL, or Data Warehouse development.
Strong SQL skills with experience in MySQL, Oracle, or similar databases.
Hands-on experience with Microsoft Fabric, FineReport, or comparable data platforms.
Preferred knowledge of supply chain, retail, logistics, and sales data domains.
Fluency in spoken and written English and Mandarin.
Responsibilities
Design and maintain integrations for customer Sell-out, Inventory, and external business data.
Integrate logistics data from 3PL providers, covering inventory and transactions.
Develop and maintain integrations with various systems including SAP and CRM platforms.
Establish APIs and other integration interfaces like EDI and SFTP.
Design and maintain the architecture of the enterprise data warehouse.
Create and manage various types of data tables and models.
Implement data governance and quality monitoring structures.
Benefits
Opportunity to work with cutting-edge data solutions and technologies.
Collaboration with Global Headquarters and high-level partners.
Work in a role that is crucial for business analytics and decision-making.
A chance to establish standardized data practices across multiple business domains.
Full Job Description
Job Summary:
Build and manage the U.S. business data platform, covering end-to-end data integration from customers, 3PL providers, external partners, and internal business systems to the data warehouse and BI presentation layer.
Establish a stable, standardized, and scalable data foundation to support business analytics, AI applications, Power BI, self-service analytics, and management decision-making.
Collaborate with the Global Headquarters data team, U.S. business teams, and external partners to ensure alignment with corporate data standards while supporting local business requirements.
Responsibilities:
Design and maintain integrations for customer Sell-out, Inventory, and other external business data.
Integrate logistics data from 3PL providers, including inventory, inbound/outbound transactions, POD, and transportation status.
Develop and maintain integrations with SAP, OMS, TMS, WMS, CRM, GCRM, and GRS systems.
Design and maintain APIs, EDI, SFTP, CSV, Excel, SharePoint, and other integration interfaces.
Design and maintain the enterprise data warehouse architecture, including ODS, DWD, DWS, DM, and Semantic Layer.
Develop fact tables, dimension tables, snapshot tables, bridge tables, and master data models.
Establish data governance, metadata, data lineage, data dictionary, and data quality monitoring.
Align U.S. data models and governance standards with Global Headquarters while supporting regional business enhancements.
Provide reliable data services for BI, AI, business analytics, and ad-hoc reporting.
Qualifications:
Bachelor's degree or above in Computer Science, Information Systems, Statistics, Mathematics, or a related field.
5+ years of experience in Data Engineering, ETL, or Data Warehouse development.
Strong SQL skills and experience with MySQL, Oracle, or similar databases.
Hands-on experience with Microsoft Fabric, FineReport, or similar data platforms.
Knowledge of supply chain, retail, logistics, and sales data domains is preferred.
Fluency in both spoken and written English and Mandarin is required.
