The Snowflake Data Engineer position is located in Chicago, IL and is a contract role. This role is hybrid, requiring in-person attendance at the downtown Chicago client location three days per week. The primary responsibilities include designing, building, and managing data pipelines for the ETL process using Airflow for orchestration and Python for scripting. The engineer will also implement and maintain data synchronization between on-premises Oracle databases and Snowflake using CDC tools, assist in developing and optimizing data models for real-time decision-making, and work closely with cross-functional teams to ensure seamless integration and operation of data systems.