Lead Data Modeler

Kaizen Technologies; Charlotte (NC); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Kaizen Technologies, in Charlotte, NC, seeks a senior Data Modeler to design and optimize data models for Home Lending and FR Y-14M reporting within a GCP BigQuery environment. You will collaborate with stakeholders across regulatory, data architecture, and cloud engineering teams to standardize scalable data structures.

The role requires deep mortgage data expertise, 12+ years in data modeling, and hands-on experience with BigQuery and cloud data modernization.

Qualifications

• 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 with Home Lending and Mortgage data domains and FR Y-14 regulatory reporting.

Responsibilities

• Data Modeling & Architecture for Home Lending and regulatory domains.
• Design and maintain conceptual, logical, and physical data models.
• Develop scalable data models optimized for Google BigQuery.
• Create enterprise data structures supporting Mortgage Origination, Customer Information, Loan Performance, Delinquency Management, Regulatory Reporting.
• Define data relationships, cardinality, metadata standards.

Skills

Data Modeling

Data Architecture

Regulatory reporting

Agile

Education

Bachelor's Degree in Computer Science or related

Tools

ERwin Data Modeler

ER/Studio

SAP PowerDesigner

SQL Developer Data Modeler

GCP BigQuery

Dataflow

Job description

Charlotte, NC (Need Onsite day 1,hybrid 3 days from office)

Job Description:

The Data Modeler will be responsible for developing conceptual, logical, and physical data models for Home Lending and FR Y-14M reporting domains. The individual will collaborate closely 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. This role requires a deep understanding of mortgage data, loan lifecycle processes, regulatory reporting data requirements, and cloud-native data architecture patterns.

The Role

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
• Customer Information
• Loan Performance
• Delinquency Management
• 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
• GCP BigQuery
• Dataflow

Success Criteria

The successful candidate will:

• Deliver enterprise-grade data models supporting Home Lending and FR Y-14M reporting.
• Enable migration from legacy platforms to GCP BigQuery.
• Improve data consistency, quality, and regulatory compliance.
• Establish scalable and reusable regulatory reporting datasets.
• Support reduction of reporting complexity and improved data traceability.
• Enable self-service analytics and future-state regulatory reporting capabilities.