Job Title: Senior ETL Developer (Snowflake Specialist)
Location: Wabash/Chicago, IL 
Duration: 6 Months

Project Overview

• Support new initiatives in Risk, including:
  • Migration of legacy data workloads to Snowflake.
  • Development to support source system replacements.
  • Murex Risk docket.

Role Summary

Seeking an experienced Senior Snowflake Developer to enhance and support data ingestion/egress integrations with Risk & Compliance Applications. The role involves building and supporting Snowflake data workloads and collaborating with the application development team to drive business value, improve customer experience, and ensure compliance with NT standards.

Key Responsibilities

• Migrate staging and output layers from legacy platforms (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 (Airflow, Azure DevOps, Control-M) for deployments and scheduling.
• Ingest data from various sources (flat files: CSV, TXT, XML, JSON; relational databases: Oracle, SQL Server).
• Transform raw data into structured formats per business requirements, ensuring consistency and accuracy.
• Clean and restructure unformatted/semi-structured files for Snowflake ingestion pipelines.
• Implement error detection/handling logic, including error tables for rejected records (duplicates, schema mismatches).
• Monitor pipeline health and proactively troubleshoot data quality issues.
• Improve operational stability via automation and propose design changes to Data Analysts, SMEs, or Architects.
• Work off-hours as required for releases, testing, and critical bug resolutions.

Required Skills & Qualifications

• 10+ years of experience in data engineering or ETL development.
• Expertise in Snowflake design and development.
• Strong Python programming skills.
• Advanced SQL and PL/SQL proficiency.
• Experience with Airflow for workflow orchestration.
• Proficient in UNIX shell scripting.
• Strong data analysis/analytics skills.
• Experience with XML transformation and message queue consumption (a plus).
• Demonstrated ability to automate operational processes and improve system stability.

Nice to Have

• Experience with ETL tools such as DataStage.
• Experience with Control-M.

Spectraforce is an equal opportunity employer and welcomes applicants from all backgrounds.

Is there anything you’d like to add or change in this draft? Would you like to specify more about the work environment, team structure, or project details? If everything looks good, would you like to proceed with sourcing candidates or do you want to edit the job description further?

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 65.00/hr.