Data Architect – Mortgage & Capital Market

Key Responsibilities

• Own the end-to-end architecture of the Snowflake data warehouse, including account and database design, layered data modeling (raw, curated, consumption), security, and cost governance.
• Design data models for mortgage and capital markets domains, including loan-level servicing tapes, MSR portfolios, base and excess servicing, advances, remittances, prepayments and delinquencies, and trade and settlement data.
• Build ingestion pipelines from subservicers, trustees, custodians, valuation vendors and internal systems, handling daily, monthly and ad hoc file feeds (flat files, SFTP, APIs, Excel).
• Lead the transformation layer in dbt, covering model design, layered project structure (staging, intermediate, marts), testing, documentation, CI/CD and environment promotion.
• Implement data quality, reconciliation and change-control frameworks, such as tape-to-tape comparisons, servicer-to-investor reconciliations and month-end MSR workflow controls.
• Orchestrate pipelines using Snowpark, Streams/Tasks, Airflow or Azure Data Factory alongside dbt.
• Design semantic and consumption-layer models in Snowflake that power Sigma workbooks for capital markets, portfolio analytics, finance and operations users.
• Partner with business teams to build and govern Sigma dashboards and self-service analytics for MSR performance, servicing metrics, reconciliations and investor reporting.
• Set up Sigma security aligned with Snowflake RBAC, including row-level security, user attributes, workspace governance and the choice between OAuth and service-account connections.
• Enable Sigma input tables and write-back workflows where operations teams need to annotate, approve or adjust data, such as reconciliation break resolution or month-end sign-offs.
• Design role-based access, masking policies for PII/NPI, row-level security and audit logging to meet regulatory and investor requirements.
• Enable downstream consumption for Sigma, valuation and risk models, and AI/LLM agents.
• Optimize warehouse sizing, clustering, query performance and credit usage.
• Work directly with the client's capital markets, portfolio analytics, finance and operations teams to translate business workflows into data architecture.
• Mentor data engineers and set coding, modeling and documentation standards.

Required Qualifications

• 10+ years in data engineering or architecture, with 4+ years designing production Snowflake platforms.
• 3+ years of hands-on dbt experience (Core or Cloud) in production. This includes macros, incremental models, snapshots for SCD and history tracking, tests, exposures and packages.
• Hands-on experience with Sigma Computing on Snowflake, including workbook design, data modeling, performance tuning and governance.
• Deep knowledge of the mortgage domain: loan lifecycle, servicing, MSRs (base/excess strips), whole loans, non-agency/non-QM, RTL/fix-and-flip, securitization and investor reporting.
• Working understanding of capital markets concepts such as pool and deal structures, cash flows, prepayment and default metrics (CPR, CDR, severity), and valuation inputs.
• Strong SQL and data modeling skills (dimensional, Data Vault, or hybrid), plus Python.
• Experience with a cloud platform (Azure preferred; AWS acceptable), including storage integration, networking and identity.
• Track record of building reconciliation and data quality controls in a financial services setting.
• Excellent communication skills and comfort working directly with senior business stakeholders.

Preferred Qualifications

• Experience with data from subservicers such as Newrez/Shellpoint, Mr. Cooper or PHH, and with trustee and vendor data (Intex, CoreLogic, Black Knight/ICE, eMBS).
• Familiarity with MSR valuation workflows and vendors (e.g., RiskSpan, MIAC).
• Snowflake SnowPro Advanced: Architect certification.
• dbt Analytics Engineering certification.
• Experience migrating reporting from Excel, Tableau or Power BI to Sigma.
• Experience with dbt Semantic Layer/MetricFlow or other shared metric definitions consumed by Sigma.
• Exposure to Snowflake Cortex, Snowpark ML, or feeding data to LLM/agent-based applications.
• Background at a mortgage REIT, servicer, investment bank or mortgage fintech.