Job Description

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)

Position Overview 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.

Key Responsibilities 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.

Required Skills & Qualifications

• 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.
• Preferred / Nice-to-Have: 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

H1b, Remote work

Similar Jobs