Description

Key Responsibilities

Design, develop, and oversee enterprise-scale Snowflake data warehouse architecture, including data modeling, security, governance, and performance optimization.

Build and maintain scalable data models supporting mortgage servicing, capital markets, portfolio analytics, and investor reporting.

Design and implement data ingestion and transformation pipelines using Snowflake, dbt, and cloud-based data integration tools.

Establish best practices for data architecture, data quality, testing, documentation, and deployment processes.

Develop semantic and analytics-ready data models to support self-service reporting and business intelligence initiatives.

Partner with business stakeholders to translate complex operational and financial requirements into scalable data solutions.

Implement data governance, reconciliation, audit, and compliance controls to ensure data accuracy and integrity.

Optimize platform performance, data processing efficiency, and overall platform scalability.

Support downstream consumption by analytics, reporting, machine learning, and AI-driven applications.

Mentor engineering teams and promote architecture, coding, and documentation standards across the organization.

Required Qualifications

10+ years of experience in Data Engineering, Data Architecture, or related disciplines.

4+ years of hands-on experience designing and supporting enterprise Snowflake environments.

3+ years of production experience with dbt (Core and/or Cloud).

Strong experience with Sigma Computing for analytics and reporting solutions.

Advanced SQL and data modeling expertise with experience designing scalable data warehouse solutions.

Proficiency in Python and modern data engineering practices.

Experience working with cloud platforms, preferably Azure or AWS.

Deep understanding of mortgage servicing operations and Mortgage Servicing Rights (MSR) processes.

Strong knowledge of capital markets concepts, including securitization, cash flows, prepayment analysis, and investor reporting.

Experience implementing data quality, reconciliation, governance, and security frameworks within regulated environments.

Excellent communication and stakeholder management skills.

Preferred Qualifications

Experience working with mortgage servicing, trustee, valuation, or investor-reporting data sources.

Familiarity with MSR valuation processes and mortgage performance analytics.

Knowledge of advanced data modeling methodologies such as Dimensional Modeling, Data Vault, or hybrid approaches.

Snowflake and/or dbt certifications.

Experience migrating reporting solutions from legacy BI platforms to modern cloud-based analytics tools.

Exposure to machine learning, AI, or large language model (LLM) data platforms.

Background in mortgage lending, servicing, financial services, fintech, or capital markets organizations

Key Skills

Education

Any Gradute