[Hiring] Snowflake Data Engineer / Senior Snowflake Data Engineer @Asterism IT Solutions

Role 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.

• 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.

Qualifications

• 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.

Requirements

• Mid-Level Data Engineer (5–7 years)
• Senior Data Engineer (12+ years)
• Work Authorization: USC, GC, GC-EAD, H4-EAD, L2-EAD

Preferred

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