Snowflake Data Engineer / Senior Snowflake Data Engineer

The candidate will design, develop, and optimize Snowflake data pipelines and reporting models using complex mortgage Loan Origination (LOS) and Loan Servicing data. Work with mortgage LOS and Loan Servicing datasets, including payments, escrow, amortization, and underwriting data.

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.
• SQL performance tuning, complex joins, window functions.

Preferred

• Mortgage payments, escrow, collections, underwriting
• AWS / Azure / GCP
• Airflow / dbt / AWS Step Functions