I'm a Data Analyst in a pretty big company and I'm having a really bad time with the data I'm being given. I spend about 70% of my time thinking about where to find the data and how to pull it instead of analyzing it. I have to pull from tables that are sometimes 800 columns wide (600 with a ton of N/As) and which have no or almost no documentation. This is my first job so I don't know what's the standard of how Data engineers should design their databases and tables but as someone who uses data made available by a Data Engineering team, what would you expect from it?
I hate that so to facilitate my life I clean them and create queries that output clean (or almost) clean tables that I can directly then use to query clean data.
What are the good practices in general? what do you expect from a good Data Engineering team as someone who depends on it? What can I do to improve the data quality overall?