Snowflake / DBT (Data Build Tool) / ADF (Azure Data Factory)

You will be a team of one so great communication is key

Build data warehouse and lead company data in right direction

Take historical data and look at it with AI/ML in future

Someone who can talk to business and run projects

Solid data warehousing and ETL background