携程Business Analysis Manager for Global Marketing/Operations(MJ035783)

工作描述

任职要求
（必备条件）
1.      学历专业：本科及以上学历，统计学、数学、经济学、计算机、信息管理、大数据等相关专业优先；
2.      SQL能力：SQL功底扎实，可独立编写复杂多表关联、窗口函数、CTE语法，具备SQL语句性能优化能力；拥有Hive/Spark SQL、BigQuery、Redshift任意一类大数据查询实操经验；
3.      数理能力：数理统计基础扎实，熟练掌握假设检验、回归分析、置信区间、显著性检验、基础因果推断知识，可独立研判统计结果，规避样本偏差、归因错误等分析常见误区；
4.      建模工具：熟练使用Python数据分析生态工具，精通Pandas、NumPy数据处理，掌握Scikit-learn工具库，可独立完成分类、聚类、业务预测类基础建模工作；
5.      AI能力：具备AI数据分析提效落地经验，可使用AI辅助代码开发、数据复盘、业务报告产出，面试可清晰说明使用场景、落地效果；
6.      业务认知：熟悉互联网主流广告平台、联盟投放底层逻辑，精通CPC/CPA/ROAS、多渠道归因等广告投放核心概念，具备投放效果复盘、渠道优化实操经验；
7.      从业经验：3年及以上互联网数据分析全职经验，拥有OTA在线旅游、电商、SEM渠道专项分析经验者优先；
8.      语言能力：英语读写能力良好，无障碍阅读英文平台文档、技术文档，可对接跨境海外业务对接工作。
 
加分项
1.      具备深度SEM渠道商务合作、渠道比价、渠道增量分析专项经验；
2.      精通A/B Test全流程实验设计，掌握DID、PSM进阶因果推断方法，了解营销Mix
Modeling营销测算模型；
3.      具备数据仓库建模、ETL开发、Airflow调度等数据工程相关基础能力；
4.      有海外头部OTA平台、跨境旅游行业全职数据分析从业经验

Job Description
1.      Responsible for full-funnel data analysis across overseas OTA platforms and cross-border SEM advertising channels, deconstructing core metrics including CPC/CPA/ROAS, conversion attribution, and channel costs; produce daily/weekly/monthly performance analysis reports to identify ad spend inefficiencies and traffic anomalies;
2.      Leverage SQL/Hive/Spark SQL for business data extraction, multi-table join data cleansing, and complex data modeling; optimize query performance to improve big data retrieval efficiency; align business metrics with data warehouse teams;
3.      Apply mathematical statistics and machine learning tools to execute user segmentation, traffic clustering, conversion prediction, and channel value modeling; validate advertising strategy effectiveness through hypothesis testing, significance analysis, and causal inference to prevent analytical bias;
4.      Collaborate with performance marketing teams to optimize SEM bidding strategies, channel mix, and audience targeting based on data insights; implement channel optimization and budget reallocation plans to improve ROAS;
5.      Interface with overseas business teams to align on international advertising policies and platform data definitions; build channel analytics dashboards and document performance analysis methodologies;
6.      Participate in A/B experiment design and post-hoc analysis; support marketing model estimation and channel incremental value assessment to build industry-specific channel analytics data assets.

Requirements(Mandatory)
1.      Education: Bachelor's degree or above; preferred majors in Statistics, Mathematics, Economics, Computer Science, Information
Management, or Big Data;
2.      SQL Proficiency: Solid SQL foundation with ability to independently write complex multi-table joins, window functions, and CTE syntax; experience in SQL query performance optimization; hands-on experience with at least one big data query engine: Hive/Spark SQL, BigQuery, or Redshift;
3.      Statistical Foundation: Strong grounding in mathematical statistics; proficient in hypothesis testing, regression analysis, confidence intervals, significance testing, and basic causal inference; capable of independently evaluating statistical results and avoiding common pitfalls including s…