Data Modeler / Architect

Signature IT World Inc; Charlotte (NC); On-site; USD 110,000 - 150,000; Part time

Job summary

Signature IT World Inc. is seeking a data engineer to support Home Lending data modernization in Charlotte, NC, focusing on FR Y-14M reporting and cloud migration on GCP/BigQuery. The role is 3 days onsite per week under a W2 contract.

You will build foundational data models, automate ingestion and validation, and deliver lineage documentation while ensuring regulatory traceability and data quality across platforms.

Qualifications

• Experience with Home Lending data domain and FR Y-14M.
• Ability to design and build a foundational data model.
• Knowledge of data lineage, metadata, and regulatory traceability.
• Experience automating data ingestion, validation and controls.

Responsibilities

• Build foundational Home Lending data model.
• Support GCP/BigQuery platform.
• Automate ingestion, validation, reconciliation and controls.
• Deliver documentation, lineage and knowledge transfer.

Skills

Data modeling

Data integration

Regulatory data traceability

Data quality

Tools

GCP BigQuery

Python

PySpark

Airflow

Cloud Composer

AutoSys

Batch processing

CDC

Streaming processing

Ab Initio

SAS

Teradata

Job description

Location: Charlotte, NC (3 days onsite per week)

W2 Contract

Supports Home Lending data modernization on GCP/BigQuery with focus on FR Y-14M reporting, cloud migration, lineage, controls and automation.

Key Responsibilities

• Build foundational Home Lending data model
• Support GCP/BigQuery platform
• Automate ingestion, validation, reconciliation and controls
• Deliver documentation, lineage and knowledge transfer

Tools & Technologies

• GCP BigQuery
• Python, PySpark, GCP Services
• Apache Airflow / Cloud Composer / AutoSys
• Batch, CDC and Streaming Processing
• Ab Initio, SAS, Teradata analysis and modernization

Domain Requirements

Home Lending, Mortgage Data, FR Y-14M, Data Quality, Lineage, Metadata and Regulatory Traceability.