Senior Data Engineer – Mortgage Servicing
Senior Data Engineer – Mortgage Servicing (Snowflake & SQL)
About the Role:
We are seeking a highly skilled Senior Data Engineer with strong Mortgage Servicing domain expertise, advanced SQL capabilities, and hands-on experience working with Snowflake or equivalent enterprise data platforms. The ideal candidate will combine deep mortgage business knowledge with technical execution, working directly with business stakeholders to build data pipelines, investigate data issues, develop reporting solutions, and deliver actionable business insights. This is a hands-on individual contributor role, not a purely managerial, coordination, or business analyst position.
Key Responsibilities
Data Engineering & Analytics:
Design, develop, and optimize complex SQL queries, data transformations, and ETL/ELT pipelines.
Work extensively with Snowflake or other enterprise data platforms for data extraction, transformation, validation, and analysis.
Develop scalable data models, reporting datasets, and analytical solutions.
Perform data profiling, reconciliation, validation, troubleshooting, and root-cause analysis.
Trace loan-level data across source systems, transformation layers, and downstream reporting platforms.
Identify data inconsistencies and implement sustainable solutions to improve data quality.
Support integration requirements, data mappings, APIs, and reporting interfaces.
Mortgage Domain Expertise:
Work closely with mortgage servicing teams to understand business processes, reporting requirements, and operational challenges.
Analyze mortgage servicing data involving payments, escrow, delinquency, loss mitigation, advances, investor reporting, and servicing transfers.
Support servicing data migration, loan boarding, reporting, and reconciliation activities.
Apply working knowledge of mortgage originations, including loan processing, underwriting, closing, and funding.
Translate mortgage business rules into SQL logic, data transformations, and analytical reporting solutions.
Business & Technical Collaboration:
Work directly with mortgage business stakeholders to gather and clarify requirements.
Translate business requirements into technical specifications, source-to-target mappings, and data models.
Collaborate with engineering teams, analysts, architects, and business users.
Develop and validate KPIs, dashboards, and operational reporting solutions.
Independently investigate complex production data issues and drive resolution through testing and deployment.
Required Qualifications:
7+ years of relevant experience in Data Engineering, SQL development, or data analytics.
Strong hands-on experience working with Mortgage Servicing data and business processes.
Advanced SQL skills, including complex joins, CTEs, window functions, aggregations, and query optimization.
Experience with Snowflake or comparable cloud data warehouse platforms.
Experience developing ETL/ELT pipelines, data transformations, and data models.
Strong understanding of mortgage servicing operations, including payment processing, escrow, delinquency, investor reporting, and servicing transfers.
Experience in data validation, reconciliation, data quality, and root-cause analysis.
Familiarity with APIs, system integrations, and business intelligence/reporting tools.
Ability to translate complex mortgage business requirements into technical solutions.
Excellent communication, analytical thinking, and stakeholder management skills.
Preferred Qualifications:
3+ years of direct mortgage servicing domain experience.
Practical knowledge of mortgage loan originations and servicing boarding.
Experience with Power BI, Tableau, or similar reporting platforms.
Exposure to cloud-based data engineering environments and orchestration tools.
Experience supporting mortgage reporting, servicing data migrations, or regulatory/investor reporting.
Ideal Candidate:
We are looking for a hands-on Data Engineer who understands mortgage servicing end to end, can independently write complex SQL, analyze loan-level data, troubleshoot production issues, and communicate directly with mortgage business stakeholders. Candidates with only general data engineering experience and no meaningful mortgage servicing exposure may not be a strong fit. Core Skills: Mortgage Servicing | SQL | Snowflake | Data Engineering | ETL/ELT | Data Modeling | Data Reconciliation | Mortgage Originations | Reporting & Analytics