携程数据仓库工程师(MJ028026)
社招全职5年以上旅游业务AI & BI地点:上海状态:招聘
任职要求
1.计算机科学、软件工程、信息管理或相关专业本科及以上学历。 2.5年以上数据仓库相关项目经验,熟悉数据仓库建设流程,对数据治理、数据资产运营都体系化落地经验 3.精通 SQL 语言,熟悉大数据体系,包括但不限于Spark、Hive、Flink、Paimon等。 4.熟悉并了解主流的数仓理论,包括Kimball建模、指标体系理论 5.具备良好的沟通能力,能够清晰地向非技术人员解释数据领域概念。 6.具备良好的团队合作精神,能够与不同部门紧密合作。 加分项 :有PB级数仓构建经验、国际化经验或背景,熟悉不同国家和地区的市场环境和商业文化、飞猪等OTA行业的优先。
工作职责
1. 赋能客服服务部门,参与客服系统的离线和实时数据仓库架构设计和开发,构建高效、稳定、可扩展的数据仓库系统。 2. 负责数据建设体系规划、模型设计、建设与运营,解决数据生产、消费过程中的卡点。 3. 沉淀并维护模型指标,提升指标复用性与分析效率,完善客服板块数据建设方法论,提升相关团队的用数体验。 4. 优化数据仓库性能,解决数据查询和数据加载的性能瓶颈,对现有数据模型及架构进行升级改造。 5. 推动数据产品化和服务化,设计体系化数据产品方案,与相关团队协作并推动产品落地。
包括英文材料
学历+
数据仓库+
https://www.youtube.com/watch?v=9GVqKuTVANE
From Zero to Data Warehouse Hero: A Full SQL Project Walkthrough and Real Industry Experience!
https://www.youtube.com/watch?v=k4tK2ttdSDg
数据治理+
https://www.ibm.com/think/topics/data-governance
Data governance is the data management discipline that focuses on the quality, security and availability of an organization’s data.
https://www.youtube.com/watch?v=uPsUjKLHLAg
Building data fabric eliminates the technological complexities of data governance so users can connect to the right data at the right time, regardless of where it resides.
SQL+
https://liaoxuefeng.com/books/sql/introduction/index.html
什么是SQL?简单地说,SQL就是访问和处理关系数据库的计算机标准语言。
https://sqlbolt.com/
Learn SQL with simple, interactive exercises.
https://www.youtube.com/watch?v=p3qvj9hO_Bo
In this video we will cover everything you need to know about SQL in only 60 minutes.
大数据+
https://www.youtube.com/watch?v=bAyrObl7TYE
https://www.youtube.com/watch?v=H4bf_uuMC-g
With all this talk of Big Data, we got Rebecca Tickle to explain just what makes data into Big Data.
Spark+
[英文] Learning Spark Book
https://pages.databricks.com/rs/094-YMS-629/images/LearningSpark2.0.pdf
This new edition has been updated to reflect Apache Spark’s evolution through Spark 2.x and Spark 3.0, including its expanded ecosystem of built-in and external data sources, machine learning, and streaming technologies with which Spark is tightly integrated.
Hive+
[英文] Hive Tutorial
https://www.tutorialspoint.com/hive/index.htm
Hive is a data warehouse infrastructure tool to process structured data in Hadoop. It resides on top of Hadoop to summarize Big Data, and makes querying and analyzing easy.
https://www.youtube.com/watch?v=D4HqQ8-Ja9Y
Flink+
https://nightlies.apache.org/flink/flink-docs-release-2.0/docs/learn-flink/overview/
This training presents an introduction to Apache Flink that includes just enough to get you started writing scalable streaming ETL, analytics, and event-driven applications, while leaving out a lot of (ultimately important) details.
https://www.youtube.com/watch?v=WajYe9iA2Uk&list=PLa7VYi0yPIH2GTo3vRtX8w9tgNTTyYSux
Today’s businesses are increasingly software-defined, and their business processes are being automated. Whether it’s orders and shipments, or downloads and clicks, business events can always be streamed. Flink can be used to manipulate, process, and react to these streaming events as they occur.
相关职位
社招住宿业务AI &
1、负责离线和在线数据的采集、清洗和加载; 2、负责通过专项分析,输出专项分析报告,为业务决策和监控提供数据支持; 3、负责携程大量商户/用户数据的分析和提炼。
更新于 2025-06-17
社招JVVJP
1、负责字节跳动旗下幸福里/今日头条/游戏业务/西瓜视频/搜索业务/小说/审核/搜索等一个或多个业务线的数据仓库架构设计、建模和ETL开发; 2、参与数据治理工作,提升数据易用性及数据质量,与数据工具团队紧密合作; 3、理解并合理抽象业务需求,发挥数据价值,与业务团队紧密合作。
更新于 2021-04-12