Anyone use snowflake (or other cloud based databases…)? I am curious about typical annual usage cost per analyst. I work for a publicly traded tech company and DB management teams have recently throttled our warehouse sizes. I am concerned that the cost savings comes at the expense of productivity (due to long run times) but being on the analytics side, I don’t have visibility to typical usage cost or savings.

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

To add… I know that it is typical for analytics teams to be bad at query optimization. This is somewhere that I’m sure my team could improve but I have people with query runtimes of 10+ hours on decently written queries but the source tables are so large (50B+ rows) that processing spills to remote disks no matter what given our limited warehouse sizing.

If you are moving to the cloud to save costs, do not move to the cloud. The goal should be to break even and maintain. The cloud requires a lot of work in the standardization of reporting data and pipelining appropriately for cost savings. Governance has to extend out of the IT level and become a partnership with the business. Otherwise, there are 60 slight variations on a single calculation that result in 60 different Snowflake charges. Repeat that over so so so many dashboards and it becomes a comedy of self-inflicted wounds.

Precalculate, provide a dictionary, review and standardize definitions, and allow smaller space and throttled access for true sandbox testing and definition challenging.

Uptime, reliability, increase of complexity of calculations, the ability to share and acquire 3rd party data, and scalability should be more of the reasoning for going to the cloud.

likehelpful

Related Posts

AMC to the moon baby

like

Currently in consulting and I’m interested in landing a product manager role in tech industry. 5+ yoe fintech

Anyone know how hard it will be to switch from technical project manager role (execution/process focused) at a tech company to product manager role (strategic)?

like

Recruiters: ahhh another week! Another chance to ghost candidates 🤡🤡🤡🤡

funnylike

How safe it is to join Amazon (non-AWS) non-tech role right now leaving current relatively stable job?

Amazon Amazon Web Services TD

like

For experienced Deloitte professionals considering a transition to industry, a fast-growing biotech company near San Francisco is hiring for a SOX Compliance Manager and Senior Accountant/Manager roles.

Generous benefits, strong, fun company culture, and stock options are VERY favorable. Message me if interested, and I will try to screen you for an interview!

Anyone from Capgemini Engineering Hamburg??

like

What’s the difference between a 750, 760 and 770. I just took for first time and got 750. I’m confident I can bump it up. Is it worth retaking or is there no measurable advantages of 10 extra pts

like

Need 11 likes to start DM

like

EYP and Strategy& fishes, what sort of work do you do in the Life Sciences space (specifically Big Pharma)? And what sort of exits into industry have you seen your former colleagues make?

like
like

How many pages is your resume/CV?

like

$BABA got murdered today. Buy, hold, or sell?

like

Gut check. On HCP projects, do you find the client or CW suggests what part of ISI per page?

like

Any CDD / M&A Strategy fish willing to chat?

like

Advice for trying to go in house or client side? Recruiters don’t have many of these positions...

like

Should I leave my company? Been here 1.5 years and was told I was getting a management promotion 5-6 months ago.Still no solid traction and they are opening up a req for it 😑no one on the current sales team has ever been promoted (2 years)except our boss who has been promoted 3 times. We hit quote every month/q/year by a lot. I have several offers at double my OTE. Already asked what the timeline is for a new manager and I was told soon and I'm "up for consideration." What would you do here?

like

Has anyone ever left Chubb to go to Liberty or Travelers for commercial or middle market underwriting or even a sales rep role? If so, how do you like it? Came from The Hartford and love Chubb so far, but curious to see what else is out there.

like

Any mass hiring happening for freshers??????

like

Hey fishes,

I recently moved from a big4 to another and I'm still on my probation period. I'm looking to move out to industry and need your help with the following:

1. What should I tell to the interviewer, if he asks why am I looking to move out of a firm within a month?
2. What should I tell to my existing firm? If they ask me a reason for moving out?

likefunny

Occupational therapists/physical therapists/SLP, what is a good pay per billable hour/pay per unit? Transitioning from a mental health salary of 70k and looking to at least match that, preferably go higher but not sure how to calculate that.

like

Additional Posts in Data & Analytics Consultants

Quick survey: Do you guys think having a template package to envelope an ML model as an application would be helpful. The package could contain boiler plate template for unit test, docker image, CI/CD, database connectors etc and act as a starting point for doing that. Tech firms usually have that internally but limited options in open source.

like

Partner: Let’s take the data in the spreadsheet and put it in PowerBI so we can cut it up.

Me: What? It’s already cut up in the spreadsheet. I don’t get it.

Also me: Yeah! Analytics!

likefunny

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

What is a data lake in basic terms?

like

Has anyone interviewed for a Data Scientist position at Facebook and have any advice on the coding and product sense interview?

like

Could anyone recommend a set of indices that are publicly available and is a good predictor for consumer spend in home renovations ?

like

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

KPMG folks, thoughts about Lighthouse relative to other big 4s? About to start the interview process. Coming from EY FSO DDnA

like

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

Folks applying for Data and Analytics roles in the industry at M, SM, D Levels, what technical/functional topics do you prepare for on the Analytics side?

like

What’s the best/simplest way to understand Sets vs Groups in tableau?

like

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

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

What are some of the best online resources to learn Power BI?

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

Scan your QR code to download
Fishbowl app on your mobile

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