> Markdown version of [/jobs/ext/2078920-data-modeler-fr-y-14-fry-14-charlotte-nc-hybrid-3-days-in-a-week-contract](https://www.wearedevelopers.com/jobs/ext/2078920-data-modeler-fr-y-14-fry-14-charlotte-nc-hybrid-3-days-in-a-week-contract). 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(FR Y-14/ FRY-14) - Charlotte NC (hybrid 3 days in a week) - Contract - **Company:** Zodiac Solutions - **Location:** Charlotte, NC, United States - **Contract:** Permanent contract - **Skills:** Agile Methodology, Data Analysis, Information Systems, Data Dictionary, Information Engineering, Extract Transform Load (ETL), Data Mapping, Data Profiling, Data Warehousing, Relational Databases, Database Queries, Document-Oriented Databases, Systems Analysis, Meta-Data Management, Raw Data, Information Technology, Data Lineage, Physical Data Models - **Published:** August 16, 2026 - **Apply:** https://www.careerjet.com/jobad/us4155bb5af1ebb9a9fad910fb13330d70 ## About the Role * Strong experience as a Data Modeler in the banking, financial services, or mortgage industry. * Hands-on experience with FR Y-14 / FRY-14 regulatory reporting. * Strong mortgage domain knowledge, including mortgage loans, servicing, origination, collateral, payments, delinquency, and related financial data. * Experience creating conceptual, logical, and physical data models. * Strong SQL skills with experience in data analysis and validation. * Experience with data mapping, data lineage, data dictionaries, and metadata management. * Understanding of relational databases and enterprise data warehouse concepts. * Experience working with large and complex financial datasets. * Strong understanding of data quality, reconciliation, and regulatory reporting processes. * Excellent analytical, problem-solving, documentation, and communication skills. Preferred Qualifications * Experience with banking regulatory reporting, risk data, or capital reporting. * Knowledge of other Federal Reserve regulatory reporting requirements. * Experience with mortgage risk, credit risk, or financial risk data. * Familiarity with data modeling tools such as Erwin, ER/Studio, or similar tools. * Experience working in Agile/Scrum environments. * Bachelor's degree in Computer Science, Information Systems, Finance, or a related field is preferred. ## Description * Design, develop, and maintain conceptual, logical, and physical data models supporting mortgage and banking applications. * Work closely with business stakeholders, data analysts, developers, and regulatory reporting teams to understand data requirements and translate them into effective data models. * Analyze mortgage and loan data, including origination, servicing, balances, payments, delinquency, collateral, and borrower-related information. * Support FR Y-14 / FRY-14 regulatory reporting requirements, ensuring accurate data mapping, transformation, and lineage. * Develop and maintain data dictionaries, business glossaries, data definitions, and source-to-target mappings. * Identify relationships, dependencies, and data gaps across multiple source systems and downstream reporting platforms. * Collaborate with data engineering teams to ensure data models are aligned with ETL/ELT processes and enterprise data architecture. * Perform data analysis and validation to identify data quality issues, inconsistencies, and reporting discrepancies. * Support reconciliation and validation of mortgage data used for regulatory reporting and risk management. * Participate in requirements gathering, data profiling, source-system analysis, and impact assessments. * Ensure data models follow enterprise standards, governance policies, and regulatory requirements. * Document data lineage and transformation rules for critical FR Y-14 reporting data elements. * Work with cross-functional teams in an Agile environment and effectively communicate technical concepts to business stakeholders. ## Related Videos - [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/videos/2055-why-your-ai-agent-keeps-hallucinating-your-data-building-deterministic-context-layers) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [DataForce Studio](https://www.wearedevelopers.com/videos/1657-dataforce-studio) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)