> Markdown version of [/jobs/ext/2661650-data-modeler](https://www.wearedevelopers.com/jobs/ext/2661650-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Modeler - **Company:** Purple Drive Technologies LLC - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Salary:** $105,000.0 - $115,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Airflow, Data Analysis, Business Logic, Big Data, BigQuery, Cloud Computing, Cloud Storage, Information Systems, Databases, Data Architecture, Data Control, Data Discovery, Data Governance, Data Transformation, Data Structures, Data Vault Modeling, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, Data Flow Control, Apache Hive, Meta-Data Management, Metadata Standards, PowerDesigner, Reference Data, Cloud Services, Cloudera, SAP (Applications), SQL Databases, Teradata SQL, Google Cloud, Information Technology, Data Lineage, Star Schema, Google Bigquery, Data Management, Physical Data Models, Cloud Migration - **Published:** August 31, 2026 - **Apply:** https://www.dice.com/job-detail/c5adf622-252e-4a15-9c02-96fbffe10b17 ## About the Role We are seeking a highly experienced Data Modeler to support a strategic Home Lending Data Modernization and Regulatory Reporting Transformation initiative. This program aims to modernize and simplify the Home Lending data ecosystem by migrating legacy reporting platforms and data warehouses to a scalable cloud-native architecture on Google Cloud Platform (Google Cloud Platform) leveraging BigQuery. The ideal candidate will possess deep expertise in Data Modeling, Home Lending, Mortgage Origination, Mortgage Servicing, FR Y-14M Regulatory Reporting, Banking Data Architecture, Data Governance, and Cloud Data Platforms. This role will be instrumental in designing enterprise-scale data models supporting regulatory reporting, risk management, analytics, data governance, and self-service reporting capabilities., 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. Preferred, but not required: Experience working with large U.S. banking institutions. Knowledge of risk management and finance data domains. Experience supporting regulatory reporting modernization initiatives. Familiarity with AI-assisted data discovery and metadata management tools. Experience with Mortgage Origination Systems (LOS) and Mortgage Servicing Platforms. Exposure to enterprise data reconciliation and data control frameworks. Professional certifications in Data Management, Cloud Technologies, or Data Architecture. Tools & Technologies: ERwin Data Modeler ER/Studio SAP PowerDesigner SQL Developer Data Modeler Google BigQuery Dataflow Dataproc Cloud Composer Cloud Storage Oracle SQL Server ## Description The base salary for this position will vary based on geography and other factors. In accordance with applicable laws, the expected base salary range for this role if filled within Charlotte, NC is $105K - $115K/year & benefits (see below). The Role Responsibilities: Design and maintain conceptual, logical, and physical data models for Home Lending and Regulatory Reporting domains. Develop scalable and optimized enterprise data models for Google BigQuery environments. Design data structures supporting: Mortgage Origination Mortgage Servicing Customer Information Collateral Data Loan Performance Delinquency Management Loss Mitigation Regulatory Reporting Define business rules, data relationships, cardinality, and metadata standards across enterprise datasets. Develop canonical and harmonized data models integrating multiple source systems. Analyze, model, and document data requirements for FR Y-14M Regulatory Reporting, including: First Lien Mortgage Home Equity Loan-Level Performance Borrower Information Property Information Servicing Data Delinquency & Default Data Translate complex regulatory requirements into scalable reporting structures and data attributes. Ensure compliance with Federal Reserve reporting standards and enterprise governance policies. Support data lineage documentation, regulatory audits, examinations, and compliance reviews. Partner with business and technical teams to modernize legacy warehouse and reporting environments. Design and optimize data models across: Raw Layer Curated Layer Business Layer Reporting Layer Define reusable data assets, enterprise data standards, and reporting datasets. Establish enterprise naming conventions, metadata standards, and modeling best practices. Collaborate with governance teams on: Data Quality Rules Data Lineage Data Controls Reference Data Management Data Cataloging Conduct data discovery workshops and data model review sessions with business stakeholders. Present data architecture and modeling solutions to both technical and non-technical audiences. Partner with Data Engineers, Data Architects, Product Owners, Risk Teams, and Regulatory Reporting teams to deliver scalable cloud-based solutions. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)