- We are committed to equal opportunity and reject any forms of discrimination. The basis for employee selection at DHL Group is qualification, performance, skills and experience.
- 我们致力于提供平等机会,拒绝任何形式的歧视。DHL集团员工选拔的基础是资质、绩效、技能及经验。
职位宗旨
To support the local deployment of the global Pricing 3.0 in China, as well as the maintenance and iteration of various global/local pricing systems, and to prepare relevant analytical data/reports for the implementation of pricing strategies, thereby facilitating business decision-making.
为了支持全球Pricing 3.0项目在中国区落地及维护迭代各类全球/本地定价系统。并为价格策略的实施准备相关分析数据/报告,以便辅助业务决策的制定。
关键职责
-
Monitor scheduled jobs in Local Pricing database (SQL Server), ensure monthly data updates, proactively detect and resolve data anomalies (missing, duplication), and trigger data repair processes as needed.
-
负责 Local Pricing 数据库(SQL Server)定时任务监控,确保月度数据稳定更新,主动发现并处理数据缺失、重复等异常,必要时触发补数或修复流程。
-
Assist in reviewing business logic of Local Pricing database, optimize table structures, indexes, and partitioning strategies, identify bottlenecks, and improve data processing efficiency.
-
协助梳理本地定价数据库业务逻辑,优化表结构、索引及分区策略,定位性能瓶颈,提升数据处理效率。
-
Lead daily operations and iterative improvements of local pricing tools, including regular/annual price package updates, user permission configuration, and basic system settings.
-
主导本地价格工具(日常/年度价格包维护、用户权限配置、系统基础设置)的日常运维及迭代优化。
-
Integrate with global data systems, perform ETL for multi-source data, ensure cross-system consistency and real-time updates; participate in annual and patch testing of global pricing systems, execute test cases, and track defect fixes.
-
对接全球数据系统,完成多源数据 ETL,保障跨系统数据一致性与实时性;参与全球价格系统年度及补丁版本测试,执行测试用例,跟踪缺陷修复。
-
Build core price indicator dashboards using Power BI, track trends across multiple dimensions, and produce regular analytical reports; establish anomaly alert mechanisms to manage abnormal regions/clients and ensure policy compliance.
-
基于 Power BI 搭建价格核心指标监控看板,多维度追踪趋势并输出专题报告;建立异动预警机制,及时管理异常区域/客户,确保价格政策落地。
-
Quickly respond to ad-hoc project-based analysis requests from management, deliver data insights or thematic analysis to support business decision-making.
-
快速响应管理层项目型分析需求,输出数据洞察或专题分析,支撑业务决策。2
Skills / Qualifications技能要求与任职资格
-
Business or Finance Degree preferred
-
商务或财务专业本科优先
-
2+ years of experience in data operations, data/business analysis, pricing experience is a plus
-
2年以上数据运营、数据/商业分析经验,有产品/服务定价经验者优先
-
Familiar with at least one of MySQL, SQL Server, or PostgreSQL, experienced with complex queries, window functions, stored procedures, and other advanced database features.
-
熟悉MySQL/SQL Server/PostgreSQL中至少一种,了解并使用过复杂查询、窗口函数、存储过程等。
-
Skilled in Excel (pivot tables, functions, Power Query), VBA or Python is a plus
-
熟练使用Excel(透视表、函数、Power Query),会VBA或Python者优先
-
Proficient in at least one BI tool; Power BI is a strong plus
-
熟练使用至少一种BI工具,会Power BI者优先
-
Proficient communication skills, spoken and written, in both English and Mandarin
-
优秀的沟通技能,书面和口头的英语和中文