Pricing Analyst 价格分析师
DHL · Beijing
* 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
- 优秀的沟通技能，书面和口头的英语和中文