Northern Trust
Join to apply for the
ETL Developer (contract)
role at
Northern Trust Overview
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. Responsibilities
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 DevOps, 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. Qualifications (must haves)
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). Nice to have
Experience with ETL tools such as DataStage. Experience with Control-M. Pay
Pay Rate Range: 67 - 74 USD hourly Benefits Information
Optional benefits offering includes medical, dental, vision and retirement benefits via Hiregenics.
#J-18808-Ljbffr
ETL Developer (contract)
role at
Northern Trust Overview
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. Responsibilities
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 DevOps, 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. Qualifications (must haves)
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). Nice to have
Experience with ETL tools such as DataStage. Experience with Control-M. Pay
Pay Rate Range: 67 - 74 USD hourly Benefits Information
Optional benefits offering includes medical, dental, vision and retirement benefits via Hiregenics.
#J-18808-Ljbffr