Any thoughts on what to expect for a “technical” interview with a boutique consulting firm focusing on data warehousing and BI? The interview is only 45 min and the company works with all platforms.

like
Posting as :
works at
You are currently posting as works at

SQL sql sql

Star schema key concepts (recommend star schema by Chris Adamson)

More sql

like

I had one and I had to white board a schema for the data.

like

I’d also guess sql. Performance optimization maybe.

like

You'll likely need to whiteboard a query of some kind

like

Related Posts

Is it possible to ask for too high of a salary during an interview?

I had an interview end early because they couldn't match my salary ask despite me being a "perfect candidate" (their words). The range was the same/lower than what I currently make, and their role was for a more senior position. I gave a highball range but I figured there would be some negotiating. Maybe that company just isn't the right fit for me, but I'm just thrown off by how quickly the call ended after that.

like

How did you break into the UX/UI field as a junior? I’m trying to get my first UX job but the most common response to my inquiries and interviews is, “we’re looking for someone more senior."

like

Hello all! My fiancé has been job hunting for the past year for a remote marketing (Specialist/manager/Agent..etc) and with hard luck she could not even land an interview! Any tips, recommendations, or referrals anyone could give us?! She has the experience but not sure why the job market has been so brutal !

like

Having an Interview this week, and don't know how high I should set my salary expectations. I currently earn 24k/annum base + comission. Would it be unreasonable to say that I have 30k + comission atm? I think it also hardly depends on the location, I am currently working from Poand but would be working for a swiss company.
Currently have about 7months exp. and thoughts on this?
Appreciate the input

like

Hi Folks, how many interview rounds will be there for Senior Test Engineer?

like

I’m interviewing for a position that’s a 6-MONTH HOURLY CONTRACTED copywriter position (5 years experience).

Any advice on negotiating salary on that..? I have no reference point on how much that would break down hourly for 6 months.

What’s a good range to negotiate for?

like

Anyone recently join Guidehouse as an experienced hire Manager? I have an interview coming up and am curious what kind of salary/benefits package i should expect. TIA!

To anyone who got hired as a creative team (CW+AD), what questions did the CD ask you and your partner during a job interview?

like

I have got a Cyber-Security Consultant Interview this week, any advice to crack the case interview ?

like

Hi fisher,
I need help for SQL quiz and case study round for consultant selection process in tiger analytics.

like

I haven’t gotten a second interview, so this might be a bit forward but I wanted to know what’s the ideal start date. I am willing to start as soon as possible, but I’ve seen on other boards people talk about starting a week or two after their official end date.

like

I have applied to over 600 Companies, attended 15 Interviews, and got 0 Offers. I'm in a mental state of despair because of my situation.

I have been working in a startup for the last 1 year as a Full-Stack Core PHP Developer while I was in my final year of engineering, and I'm losing my job soon because of their -ve growth. I graduated last month with good skills in Web development, Digital/Social Media Marketing. I'm the only provider in household.

Any kind help/reference is appreciated!

like
like

Can’t seem to get many interviews- anyone have suggestions for a resume writer? Or any tips on how to stand out on paper?

like

AlixPartners What’s the score you need in the cognitive assessment tests?and does anybody have any experience with Excel case study interview?

like

I have 3 yoe. Is applying for a role for 4-6 yoe worth my time / will I even be considered? Technically could be competing with people double my experience

like

Hi! I’m interested in pivoting into a L&D role. I’m curious as to what kind of interview questions I can expect and how I can best prepare. Any advice is greatly appreciated! Thanks!

like

Tips on handling a panel interview? 3-4 people. Small agency. I imagine it’s a 1 round process.

like

Really struggled with condensing all my interview details over a week into a simple slide deck today. I had only focused on the facts and barely mentioned the so what unless asked. New to consulting and need to improve on written communication. How did y’all improve? Read any books, courses?

like

More Posts

Which company is good for mobile developers?
1.TCS
2.cognizant
3.Capgemini
4.infosys
5.accenture
6.HCL
7.WIPRO

like

Can anyone tell me about the company "Prism HR"??
I got an offer with 2 years service bond.
Pls guide!

like

Couldnt HODL anymore 😩

likehelpful
likesmart

I got an interview call for VP position in Citi under CTI for their London office. My yoe is 15. Can someone suggest me salary I should ask for this position in London . Citi

like

Are deal sizes a proxy of your candidacy by any means? Looking to recruit Buyside but only have deal experience sub 200 million (carve out of assets)

like

Can someone explain the career progression levels at Fleishman Hilliard? What is the order of your job title levels?

likehelpful

Who do you answer the “what’s your salary requirement?” Question when recruiters ask you?

like

Any thoughts on BlueStar Bioadvisers? Anyone know why Paul Zhang left Clearview HCP after a 1-year tenure for Bluestar?

like

Say you are interviewing for a role and you know you HAVE experience but you also know there are gaps in your knowledge that may be an issue upon starting the new role. How do you explain this in an interview without over or underselling yourself?

like

Looks like a promotion could be coming. Wondering what I might expect UX Design Director / in-house finance /Boston / 35

Has anyone accepted an offer then gone back/reneged on the offer for legitimate reasons (eg unexpected pregnancy)? How’d it work out?

like

Sounds about right

Post Photo
likefunny

Is anyone else having PTSD from the winter when the grids went down? Do you think we'll see it again this upcoming winter?

like

Anyone in the Westminster (Adams county) area? Just moved to a house here. Looking to make new friends in the area.

like
like

Thoughts on OHG agencies for creative? Specifically Harrison & Star and Biolumina. Curious if they've been generally healthy places to work through the pandemic.

like

Hey How is EY GDS work culture in terms of WLB, Senior management, growth… ? I see lots of negative reviews in quora and glassdoor … anyone from GDS pls suggest

like

Can anyone recommend a good family / divorce lawyer in NYC?

Will take your name down, too.

Thanks in advance.

like

Fellow Robotic Automators, I am leaving the small consulting firm I have been with for the last year and hoping to return to a larger firm, was previously with Deloitte for ~3 years.

like

Additional Posts in Data & Analytics Consultants

Anybody looking for data strategy or technical PM for analytics projects?

likehelpful

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

DM for referral at a boutique consulting firm:

- fully remote
- good WLB
- hiring all levels with above average pay
- 3+ YOE with experience in analytics/BI in financial services background preferred

likehelpful

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

I am a beginner DA user and trying to gain experience. I am trying to do a project on ESG for fun, and having some difficulty coming up with a hypothesis. Want to pick your brains and see if I can get started. I have data about CO2 emisiones, electricity usage, air quality, and that’s pretty much it. Using alteryx and powerbi (to visualize results) as I don’t have any other programs. Thanks so much!

like

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Looking to switch into Big4 and consulting industry, anyone willing to refer? Big thanks.

Anyone else has the feeling data science consulting is over glorified? Projects are so small they have little bottom line impact.

like

What’s the salary range for DS position at Walmart? At the end of interviews but would like to know what I’m expecting. Walmart

like

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

Back end or front end?

Post Photo
funnylike

Can someone explain what’s the difference between EDM technology/tool and DWH?

like

Anyone else start exploring running their spark workloads on kubernetes?

like

I have 2YOE and a liberal arts undergrad. Does an MSBA open more doors into analytics? I don’t really see myself getting an MBA at this stage of my life, but I’m not entirely closed off to the idea yet.

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Does anyone know anything about BDO’s Analytics & Automation practice? Have an interview coming up and want to know more about type of work they do/clients they serve

Can someone tell me how log loss values can be used to compare two classification models? I understand the concept of log loss value but I don't quite get how two models can be compared using this metric. Is it as easy as saying, all things equal, one that has a lower log loss value is a better model?

like

What are some technical skills that I should develop to land a Business Intelligence role in the tech industry? SQL and a data vis tool are a must I’m assuming. What else?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal