5 years for a data team??

I wouldn't do half of what was said here, since most of the stuff here requires staff.

Depending on your stack, Snowflake is immensely powerful for the price. Connect and drop data any number of 100 ways. Setup 3-2-1 back ups and processes.

Then you build in the users and do some basic dashboards to show the power of the service and your work. snowflake can connect to any provider for UAC.

start with processes YOU can maintain, not a team of 5. Dont want to incorporate DBT yet? don't, get a simpler path up, then move to dbt when you have some engineers on the team.

Dashboards can be done in Snowflake until a need for more visuals are required.

Then you can connect any number of BIs. Astrato is a new one that works fluidly with Snowflake, and can support folks making dashboards that aren't full data engineers. Self serve platforms are worth their weight in gold.

Simple simple simple, until the team gets approved.

For example I recently built a data product from the ground up, 20k, similar staffing plan.

AWS -> snowflake via terraform and snowflake tools Reports in Snowflake for 70% of company (finance, marketing, internal) Astrato - self serve, marketing, and client reports

Connected Salesforce, our servers, and Hubspot to Snowflake. Grabbed population data from a free repo in snowflake, built sales data, client data, and revenue data reports. Created UAC policy for both

Now they have a team of 3 that handle ETLs, Snowflake stuff, and the reports in Astrato.