Data Solutions Architect (GCP) – Home Lending Data Modernization & FR Y-14M

Posted 20 August 2026
Salary $70/hr
LocationCharlotte
Job type Contract
Discipline Technology , Commodities and Financial Services

Job description

​Job Title: Data Solutions Architect (GCP) – Home Lending Data Modernization & FR Y-14M

Location: Charlotte, USA (3Days/Week Onsite)

Duration: 6Months+

Rate: $70/Hr C2C

USC & GC Candidates Only

(2 stage Virtual interviews)

Reports To-Program Director / Enterprise Data Architecture Lead

Position Summary

The Solution Architect will lead the architecture, design, and implementation of a strategic Home Lending Data Modernization Program focused on establishing a scalable cloud-based data ecosystem supporting FR Y-14M regulatory reporting, enterprise analytics, and self-service data consumption.

This role is responsible for defining the target-state architecture, foundational Home Lending data model, cloud migration strategy, integration architecture, and governance framework while ensuring successful migration from legacy and non-strategic platforms.

The Solution Architect will partner closely with Business, Regulatory Reporting, Data Engineering, Data Governance, Controls, Testing, and Product teams to deliver a modern Google Cloud Platform (GCP) and BigQuery-based ecosystem that improves data quality, reduces operational complexity, automates controls, and enhances regulatory data traceability.

Key Responsibilities

Architecture Strategy & Solution Design

  • Define and own end-to-end solution architecture for the Home Lending data ecosystem.

  • Establish target-state cloud architecture supporting FR Y-14M reporting requirements.

  • Design scalable and resilient GCP-based data platforms supporting regulatory, operational, and analytical workloads.

  • Develop architectural roadmaps supporting modernization and legacy retirement initiatives.

  • Define enterprise architecture standards, patterns, and guidelines.

  • Lead architecture governance reviews and design approvals.

Home Lending Data Architecture

  • Define foundational Home Lending enterprise data models.

  • Establish canonical data structures supporting mortgage origination, servicing, loan performance, customer, collateral, property, and delinquency domains.

  • Ensure standardized data definitions, business rules, and data lineage across the ecosystem.

  • Align data architecture with business and regulatory reporting requirements.

  • Establish reusable data domains and common data services.

Cloud Modernization & Migration

  • Lead modernization of legacy platforms and data processing frameworks.

  • Define migration approach for legacy technologies including:

  • Ab Initio

  • SAS

  • Teradata

  • Legacy ETL applications

  • Design migration patterns for cloud-native implementation.

  • Define data onboarding standards and implementation methodologies.

  • Support application rationalization and technology simplification initiatives.

Data Integration & Engineering Architecture

  • Define ingestion, transformation, and consumption architecture.

  • Design batch, CDC, and streaming architectures.

  • Establish scalable integration patterns utilizing:

  • Dataflow

  • Pub/Sub

  • Dataproc

  • BigQuery

  • Review engineering designs and implementation approaches.

  • Ensure optimal scalability, performance, and reliability.

Metadata, Lineage & Governance

  • Establish enterprise metadata and lineage framework.

  • Define end-to-end data traceability standards supporting FR Y-14M reporting.

  • Ensure source-to-target lineage documentation.

  • Support Data Governance and Data Quality initiatives.

  • Enable audit-ready documentation and reporting capabilities.

Controls & Automation

  • Define framework for automated data quality controls.

  • Establish reconciliation architecture and validation processes.

  • Support implementation of automated monitoring and exception management capabilities.

  • Ensure control coverage throughout ingestion, transformation, and reporting layers.

Stakeholder Management

  • Collaborate with:

  • Regulatory Reporting Teams

  • Home Lending Business Teams

  • Product Owners

  • Data Governance

  • Technology Leadership

  • Risk and Audit Partners

  • Present architecture recommendations and technical roadmaps.

  • Provide architectural leadership across multiple delivery teams.

Required Skills & Experience

Experience

  • 12+ years of Data, Integration, or Solution Architecture experience.

  • 7+ years architecting large-scale enterprise data platforms.

  • Experience leading cloud modernization programs.

  • Experience within large Banking or Financial Services organizations.

  • Experience supporting FR Y-14M reporting environments.

  • Strong Home Lending and Mortgage domain experience.

Technical Skills

Cloud Platforms

  • Google Cloud Platform (GCP)

  • BigQuery

  • Cloud Storage

  • Pub/Sub

  • Dataflow

  • Dataproc

  • Cloud Composer

Data Engineering

  • Python

  • PySpark

  • SQL

  • Spark

  • Data Warehousing

  • Data Lake Architecture

  • ETL/ELT Modernization

Integration Technologies

  • Batch Processing

  • CDC (Change Data Capture)

  • Event-Driven Architecture

  • Streaming Data Pipelines

  • REST APIs

Legacy Technologies

  • Ab Initio

  • SAS

  • Teradata

  • Legacy Data Warehouse Platforms

Governance & Data Management

  • Metadata Management

  • Data Lineage

  • Data Catalog

  • Data Quality Frameworks

  • Source-to-Target Mapping

  • Data Governance

Domain Knowledge

Home Lending

Strong understanding of:

  • Mortgage Origination

  • Mortgage Servicing

  • Loan Performance

  • Customer Data

  • Account Data

  • Property Data

  • Collateral Data

  • Delinquency Management

  • Default and Collections Processes

Regulatory Knowledge

Strong understanding of:

  • FR Y-14M Reporting

  • Regulatory Data Traceability

  • Regulatory Data Controls

  • Data Quality Standards

  • Reconciliation Frameworks

  • Audit Readiness Requirements

Preferred Qualifications

  • TOGAF Certification

  • Google Cloud Professional Architect Certification

  • Experience implementing enterprise data mesh or lakehouse architectures

  • Experience supporting large-scale Home Lending transformation initiatives

  • Experience implementing metadata and lineage solutions

  • Experience designing self-service analytics platforms

Key Deliverables

  • Target-State Architecture

  • Home Lending Enterprise Data Model

  • Migration Strategy and Roadmap

  • BigQuery Data Architecture

  • Integration Architecture Designs

  • Legacy Rationalization Framework

  • Data Lineage Framework

  • Metadata Management Framework

  • Data Control Architecture

  • Technical Design Documents

  • Architecture Standards and Governance Materials

  • Knowledge Transfer Artifacts

Success Measures

  • Successful implementation of Home Lending cloud data platform

  • Completion of migration from legacy/non-strategic platforms

  • Adoption of foundational Home Lending data model

  • Improved FR Y-14M data quality and traceability

  • Reduction in manual reconciliation and control activities

  • Successful implementation of metadata and lineage framework

  • Improved scalability, performance, and operational efficiency

  • Delivery of audit-ready and regulatory-compliant solutions

  • Successful knowledge transfer to operational teams

Solution Architect

Owns target-state architecture, data model strategy, cloud modernization architecture, governance standards, and technical direction.