Data Analyst will build Startup's Data System. Is this the Correct Approach?
So, I'm a fresh data analyst and I've been assigned in a startup as the only person to build the data system (for now at least). So, I've been thinking about how I'll approach this and there's no better to ask than the engineers.
It's a mobile app startup, the app itself has a pretty big database. And in the future more apps, and more internal systems will be in operation bringing data.
I thought about doing ELT by connecting DBT to a db clone in databricks for example, and staging and building marts in DBT, each mart focusing on a particular domain in some way, then do ad-hoc analysis, connect to dashboards, etc.
Is this the right way to go? Do I take it domain by domain in sort of an agile process? Is it applicable to learn business metrics of each domain/system/department in order to define them logically? Is it achievable solely? Any advice?