I understand that you are looking for someone who is familiar with both Spark and Airflow. As a Full Stack Developer with 15 years of experience in building full stack applications, I am confident that I am the best fit for this project.
I have extensive knowledge in Python which can help us to implement Spark in Airflow for improved scheduling and automation. My experience includes working with Airflow dags, setting up a data structure to retain all data from ETFs and stocks in the following columns (Symbol, Security Name, Date, Open, High, Low, Close), converting the resulting dataset into a structured format (Parquet), calculating the moving average of the trading volume (Volume) of 30 days per each stock and ETF and retaining it in a newly added column vol_moving_avg), as well as calculating the rolling median and retaining it in a newly added column adj_close_rolling_med).
Additionally, I have written unit testing for our project which will ensure quality control during development.