Uber_欧洲-Ams HR+LM电面+AnalyticsTest3.1+TakeHome

我这个case的和DA DS PA不太一样，没那么tech，分享点跨区域/function的必考必会吧

Background:
2010-17在欧洲BA History + MS Econ + 2 yrs marketing analyst，2017-19做过BA -> DA
网上投的Marketing analyst (Centrla operation team)，有referral但是没用（和hiring manager聊的时候提了一下）流程：网投(week 0) -> HR screen (week 1) -> 2hours Excel Analytics Test 3.1 (week 1) -> Hiring Manager电面 Zoom (week 3) -> Take Home Exercise (week 4) -> 在等安排下面的panel interview（internal stakeholder, team mate, N+2 manager)
Skill set: SQL Excel肯定是要的，Python / R会一种吧（我只会SPSS），BI软件至少要一种比较6 (Qlik, Tableau, PowerBI, Sporfire）

-baidu 1point3acres
JD拷贝如下：
What You'll Do
Analytics: get pumped up by deciphering huge data sets and cutting through irrelevant distractions to the heart of core data questions
Leverage machine learning models to address key growth challenges such as lifecycle marketing, predictive LTV, cross-channel spend allocation, response modelling, campaign/channel performance measurement methodologies, Program effectiveness and media attribution
Conduct in-depth analysis on CRM channel mix, be it acquisition or engagement channels, and drive intelligent budget allocation to maximize growth
.--Build robust attribution models that effectively measure performance of each digital (email/mobile) and offline channel
Play a role in shaping the EATS CRM Marketing strategy, and help define the marketing vision for the EMEA region
Build, document and scale world-class decision-making tools and reports that will help optimize our marketing investments
Coordinate with other members of the Uber Team to design marketing experiments and measure their impact

What You'll Need
2 Minimum Years of Experience with Customer Segmentation, Experimentation Analysis, Attribution Modeling
BA/BS/Masters in Economics, Business, Engineering, or other quantitative focus
You have stellar SQL & Excel capabilities and experience with R/Python
You have strong communication and organisation skills Strong understanding of attribution modelling, ideally in app & web businesses


Breakdown:
1. HR screen phone interview
这个没什么好说的，都是套路
聊完就让做步骤2的在线测试 + immigrants form

2. Excel (Uber analytics test 3.1), 2H
这个资料也很多了，都是MCQ加一些简答题
提前了解一下uber的一些术语，2H很紧凑，把Excel pivot整理得清楚一点
花个10刀完整的Q&A还蛮多的，我没买，虚的话可以买
可以用BI软件帮助你做题，不一定在Excel里做

3. Hiring Manager Phone on Zoom
继续尬聊，基本轻松，大部分看思路和逻辑性，结果并不重要，要能BS with facts

4. Take Home Challenge

您好！
本帖隐藏的内容需要积分高于 150 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 150 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

5. 过了4正在等安排下面还有3H的电面
理论上这步就是on-site了，present步骤4做得东西并QA

正在看地里on-site的面经，但exact mkt analyst的还是少。有相关经验/资料推荐的请推荐。
Fingers crossed.

楼主 权限不到 无法下载 方便用其他方式分享下吗

"这个资料也很多了，都是MCQ加一些简答题
提前了解一下uber的一些术语，2H很紧凑，把Excel pivot整理得清楚一点
花个10刀完整的Q&A还蛮多的，我没买，虚的话可以买"

小白求问一下MCQ的意思是？还有楼主能分享一下偏analytics的excel复习资料是指？
感谢！

楼主后来怎么样了呀。。。onsite有做presentation吗 有的话可以将下吗