Senior ETL Developer

Senior Snowflake Developer – Contract (Hybrid, Chicago, IL) Location: Chicago, IL (Hybrid – 3 days onsite per week) We’re seeking a Senior Snowflake Developer to support new initiatives at a leading financial institution. This role focuses on the migration of legacy data workloads to Snowflake, as well as building and supporting modern data integrations for key Risk applications — including the Murex Risk docket and other strategic modernization efforts. Required Skills & Experience: • 10+ years of experience in data development and engineering roles. • Strong Snowflake design and development expertise. • Advanced SQL, Python, and PL/SQL skills. • Experience with Airflow for orchestration and scheduling. • Solid understanding of UNIX shell scripting. • Strong data analysis and analytics background. • Exposure to XML transformation and message queue consumption (plus). Nice to Have: • Experience with ETL tools such as DataStage. • Familiarity with Control-M and Azure DevOps. Key Responsibilities • Migrate existing data workloads from legacy databases (Oracle, SQL Server) to Snowflake. • Design and implement scalable Snowflake data models that align with business and reporting needs. • Build and maintain Airflow DAGs to automate data movement between Snowflake schemas. • Develop and optimize SQL, PL/SQL, and Python scripts for data transformation and analytics. • Integrate diverse data sources (flat files, JSON, XML, relational databases) into Snowflake pipelines. • Monitor and enhance pipeline performance, error handling, and data quality. • Support automation initiatives to improve operational stability (auto-healing, process optimization). • Collaborate with cross-functional teams to ensure solutions meet governance and compliance standards. • Participate in releases, testing, and critical support activities as needed. This is a high-impact, long-term contract role where you’ll contribute to critical risk modernization efforts within a global financial institution. You’ll work in a collaborative, hybrid environment using modern data technologies to build resilient, automated, and scalable Snowflake solutions. Apply now or reach out directly to learn more about this opportunity!