>Apply for data analysis job
>No idea what I am doing
Could somebody please explain to me what data modelling is?
analyst is a vague and broad term that has no real meaning other than being a general title for white collar work at a low level, much like "worker" or "laborer"
you could be doing just about anything from data entry to advanced mathematical modeling depending on the company and division
Yeah maybe if you're a """""""""""data analyst""""""""""""
Otherwise be prepared to know SQL, be an Excel expert, maybe R, a basic understanding of Java and C#. If the place is shit you may also need experience with Access and whatever host of shitty programs and windows packages they're using.
to assist business analysts, programmers, testers, manual writers, IT package selectors, engineers, managers, related organizations and clients to understand and use an agreed semi-formal model the concepts of the organization and how they relate to one another
to manage data as a resource
for the integration of information systems
for designing databases/data warehouses (aka data repositories)
So you are probably going to be taking concepts and buisness ideas and translate them into models the business can use. (logic/advertising/marketing/ittech departments)
a lower end version of the job is maintaining data, inputting it or exporting it for daily use, and some backup stuff.
to add, an interview isn't only for them to ask you questions, it is also for you to ask them yours. Most companies that use vague descriptions will be happy to explain all the aspects of your job in detail. They may even be looking for that in the interview, as a reason to hire someone, who asks a lot of questions and seems to know his stuff.
you don't have to analyse code - it can help if you are able to code as you're a bit more self reliant when looking to spec a fix or enhancement - but the actual code specific changes are for the developers... you're more concerned with the functionality/business logic itself than how it is implemented at a lower level
it varies - in some places a data analyst might be doing what a data scientist does elsewhere... other data analysts could be excel monkeys etc..
a data scientist generally isn't going to be an excel monkey and generally will have a good grad level stats knowledge along with programming skills
>apply to position
>get phone interview
>interviewer talks on and on
>occasionally acknowledge i'm still there
>rambles on and on
>only asks one-two questions about my resume
>pass them with flying colors
>immediately starts talking about flying me out
>needs a face to face immediately, considered top 5 candidate now
That happens more than you'd think. That's about how my last interview went. The CEO spent 10 minutes going on and on about how much work it is and the long hours and how much there is to learn. I kept my mouth shut and went along with it... at the end he asked what I thought and I said "Nothing you've said has sent me running for the door. I can commit to this job."
Hired one week later.