Haystack
← Back to Jobs
Remote
Technology
AI

Snowflake Data Engineer (Mid-Level & Senior)

Asterism IT SolutionsUnited States🇺🇸United StatesPosted Sep 23, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
Yesterday
SQLAWSETLSnowflakeAirflowAzureGoogle CloudPythondbt

Job Description

Job Description: Snowflake Data Engineer (Mid-Level & Senior)
2 Roles: 1. Snowflake Data Engineer  2. Senior Snowflake Data Engineer
Domain: Mortgage / Lending & Loan Servicing
Location: 100% Remote
Work Authorization: GC-EAD, -EAD, L2-EAD (Strictly No CPT, OPT, or H1B)
Position Overview
We are looking for hands-on Snowflake Data Engineers (Mid and Senior levels) with recent, direct experience in the US Mortgage domain. In this role, you will design, develop, and optimize robust data pipelines and reporting models within Snowflake, transforming complex loan origination and loan servicing datasets into actionable analytics.
Key Responsibilities
  • Design, build, and maintain automated ETL/ELT data pipelines integrating data from core mortgage systems into Snowflake.
  • Write and optimize complex SQL queries, stored procedures, and transformations for high-volume financial data.
  • Build custom data extraction, ingestion, and validation scripts using Python.
  • Work directly with Loan Origination (LOS) and Loan Servicing data structures, including payments, escrow accounts, amortizations, and underwriting criteria.
  • Ensure data consistency, pipeline reliability, and regulatory compliance across data warehouse layers.
  • Collaborate with business analysts, reporting teams, and architects to build curated data models for executive reporting and analytics.
Required Skills & Qualifications
  • Experience:
    • Mid-Level: 5–7 years of data engineering experience.
    • Senior Level: 12+ years of overall IT/data experience with extensive data warehousing depth.
  • Mortgage Domain Expertise (Mandatory): Recent, hands-on experience handling Loan Origination Systems (LOS) or Loan Servicing data models (e.g., Encompass, MSP, Black Knight).
  • Core Technical Stack:
    • Advanced Snowflake (clustering, Snowpipe, virtual warehouses, data sharing).
    • Expert-level SQL (performance tuning, complex joins, window functions).
    • Solid Python scripting for data engineering and API integrations.
    • Strong hands-on ETL/ELT architecture and pipeline development.
  • Preferred / Nice-to-Have:
    • Direct experience with mortgage payments, escrow tracking, collections, or underwriting pipelines.
    • Cloud platform exposure (AWS, Azure, or Google Cloud Platform).
    • Experience with orchestration tools (Airflow, dbt, or AWS Step Functions).

Similar jobs

Browse related jobs

Apply now