Job Description

Snowflake Data Engineer (Mid-Level & Senior) 2 Roles: 1. Snowflake Data Engineer 2. Senior Snowflake Data Engineer Domain: Mortgage / Lending & Loan Servicing Location: 100% Remote Work Authorization: GC-EAD, -EAD, L2-EAD (Strictly No CPT, OPT, or H1B)

We are looking for hands-on Snowflake Data Engineers (Mid and Senior levels) with recent, direct experience in the US Mortgage domain . In this role, you will design, develop, and optimize robust data pipelines and reporting models within Snowflake, transforming complex loan origination and loan servicing datasets into actionable analytics.

• Design, build, and maintain automated ETL/ELT data pipelines integrating data from core mortgage systems into Snowflake .
• Write and optimize complex SQL queries , stored procedures, and transformations for high-volume financial data.
• Build custom data extraction, ingestion, and validation scripts using Python .
• Work directly with Loan Origination (LOS) and Loan Servicing data structures, including payments, escrow accounts, amortizations, and underwriting criteria.
• Ensure data consistency, pipeline reliability, and regulatory compliance across data warehouse layers.
• Collaborate with business analysts, reporting teams, and architects to build curated data models for executive reporting and analytics.

• Experience: Mid-Level: 5 7 years of data engineering experience. Senior Level: 12+ years of overall IT/data experience with extensive data warehousing depth.
• Mortgage Domain Expertise (Mandatory): Recent, hands-on experience handling Loan Origination Systems (LOS) or Loan Servicing data models (e.g., Encompass, MSP, Black Knight).
• Core Technical Stack: Advanced Snowflake (clustering, Snowpipe, virtual warehouses, data sharing).
• Expert-level SQL (performance tuning, complex joins, window functions).
• Solid Python scripting for data engineering and API integrations.
• Strong hands-on ETL/ELT architecture and pipeline development.

• Direct experience with mortgage payments, escrow tracking, collections, or underwriting pipelines.
• Cloud platform exposure (AWS, Azure, or Google Cloud Platform).
• Experience with orchestration tools (Airflow, dbt, or AWS Step Functions).

For applications and inquiries, contact:hirings@openkyber.com

Job Tags

Similar Jobs