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

Royal Caribbean Cruises, Inc.

Traveling Carpenter Job at Royal Caribbean Cruises, Inc.

Traveling CarpenterWorking closely with the Carpenter Supervisor, you will build, repair, and maintain woodwork, doors, locks, wallpapering, wall paneling, carpeting, and other related elements. You will also be responsible for sealing off critical working areas from...

Openkyber

Snowflake Engineer Job at Openkyber

...Hiring: Data Engineer Snowflake Location: Remote USA Duration: Long Term We are looking for an experienced Data Engineer with strong hands-on expertise in Snowflake, Advanced SQL, Data Warehousing, ETL/ELT, and dbt . Required Skills: Strong experience...

Vylor

Electrician Job at Vylor

...Internal Employees) Vylor has an exciting opportunity for an Electrician to join our team at our Constantine, Michigan location... ...What Makes You Stand Out: Master Licensed Electrician Experience with a work order and part inventory system Knowledge and/...

Viejas

Wildland Firefighter Job at Viejas

...assisting with fire hazard assessment, tours or demonstrations.- Provides specialized services as experienced chainsaw operators and fallers for pest management work (i.e. trap tree falling, thinning, spacing, brushing, danger tree removal, helispot/helipad construction)....

Owensboro Health

Electrician Job at Owensboro Health

...Electrician Completes electrical maintenance functions throughout the hospital and Facilities' supported areas. Job Responsibilities... ...take appropriate action. Position Requirements: Work Experience ~ No experience required Education ~ High...

Snowflake Engineer Job at Openkyber, Atlanta, GA