We are seeking hands-on Snowflake Data Engineers with recent, direct US Mortgage / Lending / Loan Servicing experience.
The candidate will design, develop, and optimize Snowflake data pipelines and reporting models using complex mortgage Loan Origination (LOS) and Loan Servicing data.
Primary Responsibilities
Design and maintain automated ETL/ELT pipelines into Snowflake.
Develop complex SQL queries, transformations, stored procedures, and performance-tuned data processes.
Build Python-based extraction, ingestion, validation, and API integration scripts.
Work with mortgage LOS and Loan Servicing datasets, including payments, escrow, amortization, and underwriting data.
Develop and maintain reliable, compliant data warehouse layers.
Build curated data models for reporting and analytics.
Collaborate with business analysts, reporting teams, and architects.
Required Skills
Snowflake
Advanced SQL
Python
ETL/ELT
Data Warehousing
Mortgage / Lending / Loan Servicing
LOS data
Experience with Encompass, MSP, Black Knight, or similar mortgage platforms.
Snowflake clustering, Snowpipe, virtual warehouses, data sharing.