Job Summary The Data Modeler will be responsible for developing conceptual, logical, and physical data models for Home Lending and FR Y-14M reporting domains. The role will collaborate with business stakeholders, regulatory reporting teams, data architects, data engineers, business analysts, governance teams, and cloud engineering teams to establish standardized and scalable data structures within the GCP ecosystem. The position requires a strong understanding of mortgage data, loan lifecycle processes, regulatory reporting requirements, and cloud-native data architecture patterns. Key Responsibilities • 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 Mortgage Origination, Mortgage Servicing, Customer Information, Collateral Data, Loan Performance, Delinquency Management, Loss Mitigation, and Regulatory Reporting. • Define data relationships, cardinality, business rules, and metadata standards. • Design canonical and harmonized data models across multiple source systems. • Collaborate with business stakeholders, regulatory reporting teams, data architects, data engineers, business analysts, governance teams, and cloud engineering teams. • Support data model development for large-scale data warehouse and cloud modernization initiatives. • Enable migration from legacy platforms to GCP BigQuery through scalable and reusable data structures. • Support data consistency, quality, regulatory compliance, and data traceability initiatives. • Develop standardized datasets to support regulatory reporting and self-service analytics. Required Qualifications • Bachelor's degree in Computer Science, Information Systems, Engineering, Finance, or a related discipline. • 12+ years of experience in Data Modeling. • 5+ years of experience within Banking, Financial Services, or Regulatory Reporting. • Experience supporting large-scale Data Warehouse or Cloud Modernization initiatives. • Experience with Home Lending and Mortgage data domains. • Experience supporting FR Y-14 regulatory reporting initiatives or similar regulatory reporting programs. • Experience working with large U.S. banking organizations. • Familiarity with risk and finance data domains. • Experience working in Agile delivery environments. • Strong understanding of conceptual, logical, and physical data modeling principles. • Knowledge of AI-assisted data discovery and metadata management tools. Preferred Qualifications • Experience with ERwin Data Modeler, ER/Studio, SAP PowerDesigner, or SQL Developer Data Modeler. • Experience with GCP BigQuery, Dataflow, Dataproc, Cloud Composer, and Cloud Storage. • Experience designing cloud-native data architectures and regulatory reporting datasets. • Experience with data governance, metadata management, data quality, and data lineage. Primary Skills • Data Modeling • Home Lending and Mortgage Data • FR Y-14M Regulatory Reporting • GCP BigQuery • ERwin Data Modeler • Data Warehouse Architecture • Cloud Data Modernization • Banking and Financial Services