The Data Engineer will design and develop analytics dashboards, optimize ETL pipelines using Amazon Redshift and Apache Airflow, implement data transformation pipelines with Kafka and ClickHouse, support machine learning initiatives, and maintain services in AWS and Kubernetes.