> Markdown version of [/jobs/ext/1311778-mortgage-data-architect](https://www.wearedevelopers.com/jobs/ext/1311778-mortgage-data-architect). 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). --- # Mortgage Data Architect - **Company:** Consolidated, Inc. - **Location:** Oklahoma City, OK, United States (Remote available) - **Salary:** $93,600.0 - $156,000.0 - **Contract:** Temporary contract - **Skills:** Batch Processing, Software as a Service, Data Architecture, Data Transformation, Data Retrieval, Data Warehousing, SQL Stored Procedures, SQL Databases, Backend, Data Analytics, Data Pipelines - **Published:** July 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=49f02af4e701f9b7 ## About the Role * Experience with testing, validation, and quality assurance * Experience with LoanServ (highly preferred but not required) * Background in financial services, lending, or mortgage servicing * Experience supporting large-scale system migrations or SaaS transformations * Familiarity with batch processing, automation, and reporting systems * Strong analytical and problem-solving skills * Ability to bridge technical and business teams * Project coordination and stakeholder communication * Attention to detail with a focus on data accuracy and integrity * This is not a purely technical SQL role-candidates must understand business operations and processes * The role supports a multi-year enterprise transformation initiative (EPIC) * Work may span multiple domains, including data, reporting, automation, and operational redesign ## Description To receive either payout, you must be in active status in good standing with the company. * Design SQL specifications for new data warehouse tables, including: * Defining table structures * Writing and optimizing queries * Supporting development and post-build testing * Collaborate with Corporate Technology teams to ensure accurate implementation of data models and warehouse solutions * Provide business analysis and project support across EPIC workstreams, including: * Requirements gathering and documentation * Solution design and validation * Testing oversight and coordination * Support migration and modernization efforts, including: * Redesign of scripts and batch processes * Data transformation and reporting solutions * Warehouse table and reporting enhancements * Ensure solutions align with: * Business operations and workflows * Risk management and compliance requirements * Flexibility for case-by-case operational scenarios * Assist in the replacement or redesign of: * Process batches and automation workflows * Reporting and data pipelines * Operational and data-driven processes * Strong SQL expertise, including data modeling and query design * Experience designing and supporting data warehouse solutions * Have recent, hands-on experience designing and owning stored procedures and data warehouse tables, not just consuming or extracting data. * Are comfortable operating independently at the data-layer level with minimal handoff. * Can proactively escalate unresolved dependencies or barriers and drive issues to resolution. * Spend the majority of their time on data architecture, development, and backend design, rather than report development or BI consumption. * Ability to translate business requirements into technical specifications * Understanding of business processes and operational workflows ## Related Videos - [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) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Building a Friendly Kotlin SDK to Connect to JetBrains Space](https://www.wearedevelopers.com/videos/128-building-a-friendly-kotlin-sdk-to-connect-to-jetbrains-space) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [MLops – Deploying, Maintaining And Evolving Machine Learning Models in Production](https://www.wearedevelopers.com/magazine/115-mlops-deploying-maintaining-and-evolving-machine-learning-models-in-production) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it)