GCP BigQuery Data Modeler for Mortgage & Regulatory Reporting

Triveni IT

Charlotte (NC)

On-site

USD 130,000 - 170,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Triveni IT in Charlotte, NC is seeking an experienced Data Modeler to join a high-impact Home Lending Data Modernization & Regulatory Reporting Transformation initiative. This role focuses on migrating legacy systems to a scalable GCP (BigQuery) environment and supporting FR Y-14 Mortgage Regulatory Reporting.

You'll design data models for Home Lending and regulatory reporting, translate regulatory requirements into data structures, and collaborate with data, risk, governance and engineering

Qualifications

12+ years of data modeling experience.
Strong background in banking/financial services.
Hands-on mortgage origination and servicing data.
Experience with FR Y-14 regulatory reporting.
GCP BigQuery and modern data warehousing expertise.
Data modeling methods: dimensional, data vault, star/snowflake.
Data governance, MDM, metadata and lineage knowledge.

Responsibilities

Design conceptual, logical & physical data models for Home Lending & regulatory reporting.
Build scalable data models optimized for GCP BigQuery.
Translate regulatory requirements into data structures.
Collaborate with stakeholders across data, risk, governance & engineering.
Ensure data quality, governance, lineage, and compliance.

Skills

Data Modeling

GCP BigQuery

Mortgage data (Origination & Servicing

FR Y-14 / Regulatory Reporting

Data Governance

MDM / Metadata / Lineage

Data Vault

Dimensional Modeling

Star/Snowflake Schemas

Stakeholder Collaboration

Job description

You'll design data models for Home Lending and regulatory reporting, translate regulatory requirements into data structures, and collaborate with data, risk, governance and engineering

Get your free, confidential resume review.

or drag and drop your file here.