you can gain knowledge on recent technologies, as you are going to involve in ETL or ELT, Front end, backend, Python API, Databricks, Snowfalke. Based on the requirements or scope you might be working on recent technologies.
Cons
Challenges as similar to start up company.. Budget challenges, Doing Agile, rather being Agile. It all depends on two or three people who governs you.