疫情中纽约市数据分析顾问公司实习

疫情中纽约市数据分析顾问公司实习

2019第四个学期毕业前（11月）在几关面试后，拿到了在纽约曼哈顿麦迪逊大道上的顾问公司数据实习生offer.
虽然我一心一意想拿某些职位跟公司但是经过诸多事情还是决定对自己好一点 先找个地方实习再继续投履历找正职
因為疫情中最后这个实习虽然从 onsite 变成远程 但整体是非常愉快的实习经验
.
员工成员
老板之前在NYU 当快十年的教授, 教策略分析.
同事很多都是商业背景或设计背景 而并非都是资工背景

面试主管叫尼古拉斯的俄罗斯人 很酷爱滑雪在NYU 念MBA，
一起吃饭的时候跟他聊我怎么学滑雪的还有那个雪场好
印度裔的 Parson 设计系女孩 在做视觉设计

典型纽约办公室会做节庆办活动、公司放Background music. 厨房放很多点心.
每天早上大家会开群总会议 其他在不同地区的Consultants 也会一起视讯讨论

整个实习花很多时间都在处理json file 复杂的结构资料因为在学校处理好的资料都是结构完整的
但是从mavenlink ( CRM系统) 选出来的资料结构却很多层
我把资料分成多段 放到mongodb 资料库 然后用mongodb 的自带的数据视觉化工具跑出企业内资源使用率

. 1point3acres工作内容
Data Optimization Project Project Overview
As we continue to grow as a company, Yurgosky is trying to scale our various databases
(Mavenlink & Salesforce) so we can have real time visibility with our reporting. This is
imperative if we are going to grow and make sound decisions as an organization:
1. We need to be able to wrangle data from Mavenlink and Salesforce
a. All active and archived projects and change requests
b. All tasks (active / archived tasks)
c. Timesheets (all time)
2. Auditing Data Issues
a. We would need to be able to find any missing or incorrect touch points in the data
b. Administrative mistakes / missed information from the project leads and
managers (unassigned tasks, tasks that don’t have end dates, etc.) that need
to be filled out so that we can capture data / have accurate reporting

3. Reporting on data in the system
a. All current director, project lead, and manager reports
b. Make it real time
c. Have good security settings for the reports
d. Forecasting that takes into account various possibilities (opportunities and
risks)

Project Goals & Objectives
Goals for this project include:
1. Wrangle realtime, accurate data into a database that is secure
2. Use this data to create reports where we can see missing touchpoints in our
databases (Mavenlink, Salesforce)
3. Use the data to create reports that drive business decisions and provide insight for
the organization
Technical Parameters
Mavenlink operates in a JSON or Rails environment Mavenlink API Documentation and we
have our pipeline data in Salesforce
Wrangle Data Objectives - 1 st Month

Trying to wrangle all the databases (In MavenLink: Tasks, Projects, and Timesheet Data - In
Salesforce: Our Sales Pipeline). We are still looking at different data storage options
(MongoDB, Firebase, AWS Cloud, and Heroku) and Business Intelligence tools (PowerBI,
Google Charts, Tableau, Looker, Qlik) based on security, pricing, and utilization. We are open
to suggestions / alternativative research.

For the wrangling, we need to do the following:
1. Make sure we are capturing all potential data
a. Active
b. Archived
2. Make sure we have a streaming connection to our dashboards and database
a. This needs to be updated frequently (once an hour would be ideal)
3. Have a way to manipulate data in realtime
a. There might not be data in the system, so we need to add additional fields
i. The week the data falls on
ii. Breaking apart data (tasks that have multiple people assigned)
iii. Differentiating Client versus the SOW related to the corresponding
project
iv. Existing vs new clients
v. Change Requests and how they change a project

4. Have a way to capture data in different ways
a. Same data, but captured in various formats
5. Be able to customize certain fields that can’t be changed in Mavenlink or Salesforce
a. Skew Forecasting in Mavenlink
b. Time Stamps for submitted timesheets

Auditing Reports - 2

nd Month (shared with #6 on the list)
We need to be able to see if there are any gaps in all of our data sets and make sure that
contract information matches the data in Mavenlink: and Salesforce
1. Make sure that all tasks have important information
a. Start & End dates
b. Scheduled Time
c. Making sure everything is assigned
2. Projects have appropriate tags / rates
3. Security settings to make sure no can see data that they shouldn’t
4. Resources are assigned the right roles / departments
5. Dashboards
6. Salesforce pipeline data needs to have all the various touch points in place
a. Making sure no start date is past due
b. All relevant fields that need to have data (i.e. every project has hours for every
role)

Forecasting & Health Reporting - 2

nd Month (shared with #5 on this list)
We need to be able to recreate current reporting and enhance reporting from both
Mavenlink and Salesforce
1. Try to replicate our dashboards and reporting from Mavenlink and Salesforce
2. Provide enhanced filtering so people can easily change what they are looking for
3. Security field settings
.
a. Directors
b. By department / roles
4. Try to implement reporting that showcases potential outcomes (if certain pipeline
projects are complete)
5. Create new reporting that captures timestamps
a. Timesheet submissions
b. Project statuses and schedules

冒昧地问下，心得在第几段？

yangtian98 发表于 2020-7-5 13:02
还有想问问楼主怎么找这些顾问咨询公司的职位放出的哇 就在glassdoor这样的找工网站上吗～

嗨你好这个管理顾问公司是我在学校的求职软体handshake 上找到的
我投的是正职的职缺
对方在跟我第一次通话后跟我说他们想要更资深背景的人
我回信问他们有没有实习的计画   他们就说我符合实习的條件要我来面试

我之前有做非营利组资的政府相关实习
刚好跟他们目前在做的几个专题类似 所以on-site 面试后就收到offerletter了

yangtian98 发表于 2020-7-7 16:10
谢谢你的分享！往客户端走是什么方向呢 有哪些工作内容？我对consulting了解不是很多 如果有空的话麻烦你 ...

可以跟客戶有條理地去分析，你的 solution space （解答的範圍）是什麼，有哪些大綱？當你在 project setup 時 ，完整得去想有可能發展的方向，確認這些發展的方向是互相不重疊，但是包含所有 potentioal solutions space 把這些方向分供給 team 上所有的人

阿笨猪 发表于 2020-7-5 12:38
冒昧地问下，心得在第几段？

谢谢提醒 我再写得详细一点

dd 谢谢分享！对这个公司很感兴趣 可以求个楼主拿到实习offer的经验贴吗 多谢🙏

还有想问问楼主怎么找这些顾问咨询公司的职位放出的哇 就在glassdoor这样的找工网站上吗～

请问楼主 公司还缺人么？fulltime /intern都可

lian600058 发表于 2020-7-6 03:19
嗨你好这个管理顾问公司是我在学校的求职软体handshake 上找到的
我投的是正职的职缺
对方在跟我第一次 ...

了解 多谢你的回答啦 看了工作内容感觉和我的理想的工作很接近 但我没有相关的工作经验 想找个unpaid的实习都很难😭

yangtian98 发表于 2020-7-6 16:10
了解 多谢你的回答啦 看了工作内容感觉和我的理想的工作很接近 但我没有相关的工作经验 想找个unpaid的实 ...

今年蠻難的，我主管三個實習生選一個Return offer, 我DS Master 跟 NYU Stern 俄羅斯美籍男生 , Parson Design印度女孩, 主管選了nyu stern 大哥 他從mba 開始就在這家公司實習快兩年了。顧問業要儘量往客戶端走比較好！

lian600058 发表于 2020-7-8 01:56
今年蠻難的，我主管三個實習生選一個Return offer, 我DS Master 跟 NYU Stern 俄羅斯美籍男生 , Parson D ...

谢谢你的分享！往客户端走是什么方向呢 有哪些工作内容？我对consulting了解不是很多 如果有空的话麻烦你多讲讲啦哈哈哈