Data Modeler
Charlotte,NC
Full time
Requirements:
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
Teradata
Hive
Google Cloud Platform Ecosystem