携程数据仓库工程师(MJ026476)
社招全职5年以上旅游业务AI & BI地点:上海状态:招聘
任职要求
1.计算机科学、软件工程、信息管理或相关专业本科及以上学历。 2.5年以上数据仓库相关项目经验,熟悉数据仓库建设流程,对数据治理、数据资产运营都体系化落地经验 3.精通 SQL 语言,熟悉大数据体系,包括但不限于Spark、Hive、Flink、Paimon等。 4.熟悉并了解主流的数仓理论,包括Kimball建模、指标体系理论 5.具备良好的沟通能力,能够清晰地向非技术人员解释数据领域概念。 6.具备良好的团队合作精神,能够与不同部门紧密合作。 加分项 :有PB级数仓构建经验的优先,有团队管理经验的优先 具备国际化经验或背景,熟悉不同国家和地区的市场环境和商业文化的优先。
工作职责
1.参与离线和实时数据仓库架构设计和开发,构建高效、稳定、可扩展的数据仓库系统。 2.负责数据仓库模型设计,包括星型模型、雪花模型、星座模型等,并制定数据仓库开发规范。 3.负责数据资产的运营,结合业务现状,解决数据资产生产、消费过程中的卡点,提升相关团队的用数体验 4.开发和维护 ETL/ELT 数据 pipeline,确保数据高效、准确地从源系统加载到数据仓库 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.
相关职位
社招JVVJP
1、负责字节跳动旗下幸福里/今日头条/游戏业务/西瓜视频/搜索业务/小说/审核/搜索等一个或多个业务线的数据仓库架构设计、建模和ETL开发; 2、参与数据治理工作,提升数据易用性及数据质量,与数据工具团队紧密合作; 3、理解并合理抽象业务需求,发挥数据价值,与业务团队紧密合作。
更新于 2021-04-12
社招2年以上
1. 基于阿里云DataWorks平台,完成数据采集、清洗、加工、建模及报表开发,支撑复杂业务场景的数据需求; 2. 深入理解业务逻辑,与业务部门高效沟通,将模糊需求转化为清晰的数据开发方案; 3. 负责ETL任务开发与维护,确保数据流程的准确性、稳定性与时效性; 4. 管理数据血缘关系,维护数据文档(如数据字典、处理逻辑说明),保障数据可追溯性; 5. 分析数据异常问题,快速定位原因并推动解决,确保业务决策数据的可靠性; 6. 协助优化数据使用流程,提升业务方数据获取和分析效率。
更新于 2025-05-28
社招住宿业务AI &
1、负责离线和在线数据的采集、清洗和加载; 2、负责通过专项分析,输出专项分析报告,为业务决策和监控提供数据支持; 3、负责携程大量商户/用户数据的分析和提炼。
更新于 2025-06-17