Data Modeler

Triveni IT; Charlotte (NC); On-site; USD 130,000 - 170,000; Full time

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

Charlotte, NC (3 Days Onsite – Local Candidates Only)

We are looking for 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-14M Mortgage Regulatory Reporting.

• 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 teams
• Ensure data quality, governance, lineage, and compliance
• 12+ years of Data Modeling experience
• Strong background in Banking / Financial Services
• Hands-on experience with Mortgage (Origination & Servicing) data
• Experience with FR Y-14 / Regulatory Reporting
• Expertise in GCP (BigQuery) and modern data warehousing
• Data Modeling: Dimensional, Data Vault, Star/Snowflake schemas
• Strong knowledge of Data Governance, MDM, Metadata & Lineage