Snowflake Data Engineer / Senior Snowflake Data Engineer

Job Title: Snowflake Data Engineer / Senior Snowflake Data Engineer
Location: 100% Remote
Job Type: Contract – W2
Client: Leading Mortgage & Financial Services Enterprise
Openings: Mid-Level & Senior

• Data Engineer (5–7 years)
• Senior Data Engineer (12+ years)

Work Authorization: USC, GC, GC-EAD, H4-EAD, L2-EAD

Job Description

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