Data Architect – Mortgage & Capital Markets

We are seeking an experienced Data Architect Mortgage & Capital Markets with strong expertise in Snowflake, dbt, and Sigma Computing to design and lead enterprise data architecture for mortgage servicing, MSR analytics, and capital markets operations.

Key Responsibilities:

• Own end-to-end Snowflake data warehouse architecture, including data modeling, security, governance, and cost optimization.

• Design data models for mortgage servicing, MSR portfolios, loan-level tapes, advances, remittances, prepayments, delinquencies, and trade/settlement data.

• Build and manage data ingestion pipelines from subservicers, trustees, custodians, valuation vendors, and internal systems using flat files, SFTP, APIs, and Excel.

• Lead dbt transformation development, including staging, intermediate and mart layers, incremental models, snapshots, macros, testing, documentation, and CI/CD.

• Implement data quality, reconciliation, audit, and month-end control frameworks for financial data.

• Orchestrate pipelines using Snowflake Streams/Tasks, Snowpark, Airflow, or Azure Data Factory.

• Develop Sigma Computing workbooks, semantic models, dashboards, and self-service analytics on Snowflake.

• Configure Sigma governance, role-based access, row-level security, and write-back workflows.

• Implement data security controls, including masking policies for sensitive financial and personal information.

• Optimize Snowflake warehouse performance, query execution, clustering, and credit consumption.

• Collaborate with capital markets, portfolio analytics, finance, and operations teams to translate business requirements into scalable data solutions.

• Mentor data engineers and establish architecture, coding, modeling, and documentation standards.

Required Qualifications:

• 10+ years of experience in data engineering or data architecture.

• 4+ years of production Snowflake platform architecture experience.

• 3+ years of hands-on production dbt experience, including macros, incremental models, snapshots, tests, packages, and CI/CD.

• Hands-on Sigma Computing experience with Snowflake, including workbook development, data modeling, performance tuning, and governance.

• Strong mortgage-domain knowledge covering servicing, MSRs, base/excess servicing, whole loans, non-agency/non-QM, securitization, and investor reporting.

• Understanding of capital markets concepts, including pool/deal structures, cash flows, CPR, CDR, default severity, and valuation inputs.

• Strong SQL, data modeling, and Python skills.

• Experience with Azure preferred; AWS experience is also acceptable.

• Demonstrated experience with financial data reconciliation and data quality controls.

• Excellent communication skills and experience working with senior business stakeholders.

Preferred Qualifications:

• Experience with mortgage servicers, trustees, custodians, and valuation vendors.

• Familiarity with MSR valuation workflows and tools such as RiskSpan or MIAC.

• Snowflake SnowPro Advanced: Architect or dbt Analytics Engineering certification.

• Experience migrating reporting from Excel, Tableau, or Power BI to Sigma.

• Familiarity with dbt Semantic Layer/MetricFlow, Snowflake Cortex, Snowpark ML, or LLM-based applications.

• Background in a mortgage REIT, mortgage servicer, investment bank, or mortgage fintech.

Interested candidates: Please share your updated resume along with your current location, work authorization, total experience, relevant Snowflake/dbt/Sigma experience, and availability.

#DataArchitect #Snowflake #dbt #SigmaComputing #Mortgage #CapitalMarkets #MSR #DataEngineering #SQL #Azure