Snowflake Data Engineer / Senior Snowflake Data Engineer
Remote
Contracted
Mid Level
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
Apply for this position
Required*