Description

Responsibilities:

• Data Modeling & Architecture
• Design and maintain conceptual, logical, and physical data models for Home Lending and Regulatory Reporting domains.
• Develop scalable data models optimized for Google BigQuery.
• Create enterprise data structures supporting below or similar:
  • Mortgage Origination
  • Mortgage Servicing
  • Customer Information
  • Collateral Data
  • Loan Performance
  • Delinquency Management
  • Loss Mitigation
  • Regulatory Reporting
• Define data relationships, cardinality, business rules, and metadata standards.
• Design canonical and harmonized data models across multiple source systems.

Requirements:

• Bachelor's Degree in Computer Science, Information Systems, Engineering, Finance, or related discipline.
• 12+ years of Data Modeling experience.
• 5+ years within Banking, Financial Services, or Regulatory Reporting.
• Experience supporting large-scale Data Warehouse or Cloud Modernization initiatives.
• experience in Home Lending and Mortgage data domains.
• supporting FR Y-14 regulatory reporting initiatives or similar regulatory exposure
• Experience working with Large U.S. Banks.
• Familiarity with risk and finance data domains.
• Experience working in Agile delivery environments.
• Knowledge of AI-assisted data discovery and metadata management tools.

Tools & Technologies

Data Modeling Tools

• ERwin Data Modeler
• ER/Studio
• SAP PowerDesigner
• SQL Developer Data Modeler

Cloud & Engineering

• GCP BigQuery
• Dataflow
• Dataproc
• Cloud Composer
• Cloud Storage

Key Skills

Education

Bachelor's degree