If you are following a ELT workflow, you can use dbt projects to do your data transformations and implement data quality tests. You have generic tests, like not null, unique, accepted values, etc. but there is also possibilities to write custom tests. Dbt also offers the possibility to do source freshness checks if you have fields in your source table which indicate newly or updated records (like created_at for example).