ETL Developer

Join to apply for the ETL Developer (contract) role at Northern Trust

This is to support the new work forthcoming in Risk:
Migration of legacy data workloads to Snowflake. Development to support source system replacements. Murex Risk docket. Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest/egress integrations with Risk & Compliance Applications.

• Build and support the Snowflake data workloads and work with the current application development team to drive business value, enhance customer experience, and ensure compliance with NT standards.
• Migrate staging and output layers from legacy platforms (e.g., Oracle, SQL Server) to Snowflake-based schemas.
• Design and implement scalable data models in Snowflake aligned with business logic and reporting needs.
• Build and maintain Airflow DAGs to automate data movement between Snowflake schemas.
• Use orchestration tools such as Airflow, Azure Dev Ops, and Control-M to manage deployments and scheduling.
• Ingest data from sources such as flat files (CSV, TXT, XML, JSON) and relational databases (Oracle, SQL Server).
• Transform raw data into structured formats based on business requirements, ensuring consistency and accuracy across layers.
• Clean and restructure unformatted or semi-structured files for Snowflake ingestion pipelines.
• Implement error detection and handling logic, including creation of error tables to capture rejected records (e.g., duplicates, schema mismatches).
• Monitor pipeline health and troubleshoot data quality issues proactively.

• Expertise in design/development in Snowflake and Python.
• Expertise in data analysis/analytics and SQL.
• Experience with Airflow.
• Strong in PL/SQL and UNIX shell scripting.
• Experience with XML transformation and consumption of messages from queues is a plus.
• Hands-on approach to improving operational stability via automation, auto-healing where possible, and raising design changes to Data Analysts, SMEs and/or architects, as well as opportunities to application/service managers.
• Willingness to work off-hours as demanded by projects, operations, and stakeholders (release, testing, and/or critical bug resolutions).

• Experience with ETL tools such as Data Stage.
• Experience with Control-M.

Pay Rate Range: 67 - 74 USD hourly

Optional benefits offering includes medical, dental, vision and retirement benefits via Hiregenics.