Data Modeler

Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance, or a related discipline.

12+ years of hands-on Data Modeling experience in enterprise environments.

5+ years of experience within Banking, Financial Services, Risk, or Regulatory Reporting domains.

Extensive experience supporting large-scale Data Warehouse Modernization or Cloud Transformation initiatives.

Strong experience in Home Lending, Mortgage Origination, and Mortgage Servicing data domains.

Proven experience supporting FR Y-14M reporting or similar regulatory reporting programs.

Expertise in:

Conceptual Data Modeling

Logical Data Modeling

Physical Data Modeling

Dimensional Modeling

Data Vault Modeling

Star Schema Design

Snowflake Schema Design

Normalization & Denormalization Techniques

Hands-on experience with Google Cloud Platform (Google Cloud Platform), including:

BigQuery

Cloud Storage

Dataflow

Dataproc

Pub/Sub

Cloud Composer

Strong experience with enterprise databases and warehouse platforms including:

Oracle

SQL Server

Teradata

Hive

BigQuery

Expertise in:

Metadata Management

Data Governance

Data Quality Frameworks

Data Lineage

Master Data Management (MDM)

Data Cataloging

Strong understanding of enterprise regulatory reporting, risk reporting, and financial data governance frameworks.

Excellent stakeholder management, communication, and problem-solving skills.

Experience working in Agile delivery environments.

Tools & Technologies:

ERwin Data Modeler

ER/Studio

SAP PowerDesigner

SQL Developer Data Modeler

Google BigQuery

Dataflow

Dataproc

Cloud Composer

Cloud Storage

Oracle

SQL Server