BI/DWH dev - should I tak a position without cloud?

413x · 11 Mar 2021 at 15:09

My background is BI dev in MS stack.

My experience is
Power bi
Ssas (tabular)
Ssis, a few pipelines, but not heavy use
I have touched on data factory. Very lightly.

But no DWH dev skills.

I have a job offer which I would be doing DWH dev, sass MDX cube build and powebi reports... But it's all on prem.

Would it be silly to accept an opportunity with no cloud offering with the way the world is going now? Or is it not too big a deal.

I'm wary of taking what might be a stagnant job

tom_e · 11 Mar 2021 at 15:31

I wouldn't be too bothered, plenty of places will still run in house for the foreseeable future and the skills are still going to be transferable.

413x · 11 Mar 2021 at 15:39

tom_e said:
I wouldn't be too bothered, plenty of places will still run in house for the foreseeable future and the skills are still going to be transferable.

This is what the recruiter said. Obviously I he's biased. But he made some good points.

He also said that DWH dev underpins most cloud based jobs in this space. In effect, its better to have DWH dev skills first.

Valid?
Does make sense

HangTime · 11 Mar 2021 at 16:37

SSAS MDX cube is arguably a bit legacy but I wouldn't let that put you off. It sounds like you may already have cloud experience (ADF) that you could lean on for future opportunities plus of course get certs to stay relevant.

I've hired quite a few DW Devs and I'd be more interested in their understanding of DW concepts, problem solving etc than exposure to a particular stack, although it might depend on the level of seniority in the role (ready made experience vs potential to learn). Learning Azure (or AWS / GCP / ********* / whatever) can all be done by someone with right foundational knowledge and aptitude. Certainly someone with a decent exposure to MS stack like you wouldn't concern me if you'd been away from cloud for a while.

Edit: for some reason OCUK has starred out the star shaped things that fall out of the sky when it gets cold, the ****ing **********.

413x · 12 Mar 2021 at 15:57

HangTime said:
SSAS MDX cube is arguably a bit legacy but I wouldn't let that put you off. It sounds like you may already have cloud experience (ADF) that you could lean on for future opportunities plus of course get certs to stay relevant.

I've hired quite a few DW Devs and I'd be more interested in their understanding of DW concepts, problem solving etc than exposure to a particular stack, although it might depend on the level of seniority in the role (ready made experience vs potential to learn). Learning Azure (or AWS / GCP / ********* / whatever) can all be done by someone with right foundational knowledge and aptitude. Certainly someone with a decent exposure to MS stack like you wouldn't concern me if you'd been away from cloud for a while.

Edit: for some reason OCUK has starred out the star shaped things that fall out of the sky when it gets cold, the ****ing **********.

What has the world come to when it stars out *********!?

Thanks for this. The c company have just come back and made an offer. So going to have a look and see if it's right for me.

It would definitely fill the DWH knowledge gap. And cloud may be looked at in a year's time anyway.

Yes. Mdx cubes, not seen anywhere that uses them to date I have to say

FerretBoy · 9 May 2021 at 21:31

It depends where you are in life, assuming this isn't a role before retirement then I would skip it. Unless you don't have a job.

I don't see what is in it for you, development wise.

HangTime · 10 May 2021 at 22:07

The offer was two months ago so I assume he's either taken the job or not... any update @413x ?

413x · 10 May 2021 at 23:13

HangTime said:
The offer was two months ago so I assume he's either taken the job or not... any update @413x ?

I start on Monday!

Not sure if it's a good move.
In hindsight I now know the company I work for has backtracked on changes etc and no one in my team is going.

Main concern is actually friendships rather than job itself. I like my current team. And new team is super small.

I've seen what my gf has been through with a bad boss

But I don't regret the decision. The info they (current job) gave, mixed messages and never giving me any reassurance my job was safe made me jump.
I even said 'I don't want to go, but what you've told me, is too much uncertainty. I don't want extra money I just want clarity' but they couldn't give me that
Hope it's the right call!