Mortgage Data Analyst/SQL Data Warehouse Developer

Number of openings: 3 Duration: Contract work Location: Remote Description: This role supports the EPIC program, a large-scale initiative to transition from a highly customized version of LoanServ to the industry-standard SaaS platform. The position blends data warehouse development with business analysis and project support, requiring a strong understanding of both data systems and operational processes. This is a remote position, but travel to Oklahoma City will be required throughout the project. You will receive a sign-on bonus of $500.00. This bonus will be paid out on the paycheck following the pay period in which you complete 90-days of employment. You will also receive a $500.00 bonus upon completion of the project, including any extensions offered by the client. There is a 6-month project minimum to receive the bonus, and you must remain employed through project completion. This bonus will be paid out in your final paycheck with the company. 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: o Defining table structures o Writing and optimizing queries o 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: o Requirements gathering and documentation o Solution design and validation o Testing oversight and coordination · Support migration and modernization efforts, including: o Redesign of scripts and batch processes o Data transformation and reporting solutions o Warehouse table and reporting enhancements · Ensure solutions align with: o Business operations and workflows o Risk management and compliance requirements o Flexibility for case-by-case operational scenarios · Assist in the replacement or redesign of: o Process batches and automation workflows o Reporting and data pipelines o 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 · 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 Benefits: · Medical Insurance · Dental Insurance · Vision Insurance · Life & Disability Insurances Pay: $50.00 - $75.00 per hour Experience: • Mortgage servicing: 3 years (Required) • LoanServ: 3 years (Required) Work Location: Remote