USA LaoTu 高薪转行做数据第一平台

名校名师出高徒,师资强,同学多,热气高,点子好,经验多,出实招,透实底,多干货,求职快! => 文科转行美国找工作高薪数据分析师 Database Analyst => Topic started by: 婕喜 on July 16, 2016, 04:48:38 PM

Title: finally got the job offer
Post by: 婕喜 on July 16, 2016, 04:48:38 PM
Dear Laoshi and Lucky,

I finally got the job offer from another hospital in downtown area yesterday. The pay is higher and the job title is also senior level. It took me nearly  three months and I went through 7 on site interviews. I'd like to share some experience with students who are in Canada.

Compare to two years ago I think there are more BI related job opportunities on job market however also more competition.  That's just my experience could be wrong. you also need to spend lots of time to modify your resume make it very close to job requirements.

Regarding the on site interviews, I got two sql tests. One was a position in government. Very easy, even didn't have to do table joins only select statement. i didn't get the position though as one reason I think I'm over qualified. this position uses excel a lot to do reporting. Another sql test was with a financial company. The test was not too easy also not too hard either. Used 3 tables to get information and also used group functions. I did test better than two years ago but didn't get the position. The salary company only can afford to pay was much lower than my expectation. Anyway except these two sql tests are technical things, all my interview questions were behavior questions and all of them can be found on these forum:

what kind of manager you like to work with? have you ever had any bad managers? describe what's the good manager or bad manager?

how do you handle conflict with your coworkers or manager or end users?

if end user asked you to create a report using lots of parameters, how do you handle it?

what's your biggest challenge you have ever met at work? how did you act and what's the outcome?

how do you prioritize multi tasks?

if dead line is approaching you think you can not deliver the reports to the end user, what would you do?

why did you apply this position?

what do you know about our organization?

how would your manager and coworkers describe you?

what's your salary expectation?

describe a situation you made a recommendation to improve the system performance.

describe a situation you did trouble shooting fixed the application error.

do you have experience to communicate with cross function departments and senior management?

how do you handle mistakes? what did you learn?

describe how do you gather the requirement from the end users?


I think that's all about my on site interviews. For me, I prepared lots of stories.

Another thing I want to say is Laotu laoshi not only lead me to this data base field but also opened another door for me. Now I can apply jobs not only related to back end but also related to application front end:)

Thanks Laoshi and Lucky and other students.

Jessie
 
Title: Re: finally got the job offer
Post by: mtdbe2 on July 16, 2016, 05:00:56 PM
祝贺祝贺,功夫不负有心人呐。
 :) :)
Title: Re: finally got the job offer
Post by: USA LaoTu Support Team on July 16, 2016, 09:30:09 PM
祝贺咱国文科生 婕喜同学 跳到BI高级职位BI!

(http://images.usalaotu.com/rose.png)
Title: Re: finally got the job offer
Post by: Martin2014 on July 16, 2016, 10:49:53 PM
恭喜你Jessie!你的故事非常鼓励我,感谢你的分享!
Title: Re: finally got the job offer
Post by: 婕喜 on July 17, 2016, 12:37:49 PM
Thanks :)

Jessie
Title: Re: finally got the job offer
Post by: lkh99 on July 17, 2016, 08:20:34 PM
Congratulations!
Title: Re: finally got the job offer
Post by: jchiefland on July 18, 2016, 05:31:46 AM
Congratulations!
Are you coming back Wednesday night?
Title: Re: finally got the job offer
Post by: 如月 on July 18, 2016, 07:04:53 AM
Congratulations!  Thanks a lot for your sharing !
Title: Re: finally got the job offer
Post by: 婕喜 on July 18, 2016, 09:14:29 AM
Thanks:)

Jessie
Title: Re: finally got the job offer
Post by: Melanie.Lee on July 06, 2019, 12:54:31 PM
Jealous you for your joining this training program so early!!!!