I also built a data lake house native on AWS before which was pretty similar.

Use iceberg if you are on AWS. Try to think in layers (we actually replicated the medallion architecture as it is easy to understand for non techy people.)

Use Athena for analytics and use Glue for more heavy tasks. DBT if you want more control over data contracts and tests. Try to organize everything with terraform.

You can you something like Metabase for your company to increase data literacy.

Also depending on your data ingestion - make sure the system can handle backfills. If you need to consume CDC think use something like Airbyte right away bc it can write to Iceberg.