Data First Jobs

iPivot

Lead Data Modeler / Senior Data Modeler || W2 only

Contract · In Office · Charlotte, North Carolina (USA)

Posted Aug 11, 2026

Work Options
Seniority Level
Cloud Stack
Skills
Job Type
Position Group
  • Lead Data Modeler / Senior Data Modeler
  • Charlotte, NC (Need Onsite day 1,hybrid 3 days from office)
  • Contract – W2

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.

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

Mention you found this on Data First Jobs — it helps us bring you more roles like this.

Lead Data Modeler / Senior Data Modeler || W2 only

iPivot

Like this role? Get carefully selected jobs like it, twice a week, straight to your inbox.

Free, no spam. Unsubscribe anytime.