> Markdown version of [/jobs/ext/1343481-senior-data-modeler](https://www.wearedevelopers.com/jobs/ext/1343481-senior-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). --- # Senior Data Modeler - **Company:** Kanan Solutions LLC - **Location:** McLean, VA, United States - **Experience:** Expert - **Salary:** $135,200.0 - $156,000.0 - **Contract:** Temporary to permanent - **Skills:** Third Normal Form, Amazon Web Services, Cloud Engineering, Information Systems, Databases, Data Architecture, Data Governance, Data Structures, Data Vault Modeling, Data Warehousing, Metadata, Cloud Services, Standard Sql, Snowflake, Data Lakes, Information Technology, Data Lineage, Collibra, Operational Systems, Physical Data Models, Amazon Redshift, Databricks - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=eb05be0a5b63f9dd ## About the Role * 8+ years in data modeling, data architecture, or a closely related role * Deep expertise in conceptual/logical/physical modeling and normalization * Hands-on with a modeling tool (erwin, ER/Studio, SqlDBM, or similar) * Strong SQL; comfortable profiling data to validate assumptions * Experience with cloud data platforms (Snowflake, Redshift, Databricks, or equivalent) * Exceptional written and verbal communication - you can run a workshop with non-technical stakeholders, defend a design decision in an architecture review, and write documentation people actually read * Bachelor's degree in Computer Science, Information Systems, or equivalent experience, * Financial services experience, especially mortgage, capital markets, or credit risk * Familiarity with MISMO standards, loan-level data, or securitization data structures * Data Vault 2.0 certification * Experience with dbt, Collibra, Alation, or similar governance/transformation tooling * Exposure to regulatory reporting (CECL, CCAR) data requirements Work Authorization * Must be authorized to work in the U.S. for any employer without current or future visa sponsorship ## Description We're looking for a Senior Data Modeler to design and steward the data structures behind our mortgage, securitization, and risk platforms. You'll partner with data architects, engineers, business analysts, and risk/finance stakeholders to translate complex business concepts into durable, well-governed data models - and you'll be the person who can explain those models clearly to both a database engineer and a VP who doesn't want to see an ERD. What you'll do * Design conceptual, logical, and physical data models for enterprise data warehouse, data lake, and operational systems * Lead requirements sessions with business and technical stakeholders; turn ambiguous asks into documented, agreed-upon models * Apply dimensional (Kimball), 3NF, and Data Vault 2.0 techniques as appropriate to the use case * Define and enforce naming standards, metadata, data lineage, and modeling governance * Partner with data governance on data quality rules, business glossary, and critical data element definitions * Review models produced by other team members and mentor junior modelers * Support migration of legacy models to modern cloud platforms (AWS, Snowflake) * Document models and decisions so they remain usable after you've moved on to the next project ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [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)