The Senior Domain Consultant will work in a mortgage technology and data transformation environment where the practical objective is to build a centralized Application Data Store / Authorized Data Store for the bank’s Home Lending division. Mortgage and home lending data is often distributed across multiple servicing, origination, fulfillment, reporting, and operational systems, each with its own data definitions, business rules, field usage, and reporting dependencies. The candidate’s role is to help transform this fragmented data landscape into a clear, governed, business-aligned, consolidated data foundation that can support reporting, analytics, operations, servicing, finance, risk, compliance, and technology teams.
The role requires a candidate who can operate effectively between business and technology, with primary strength in mortgage domain consulting and practical hands-on ability in data analysis and SQL. The strongest requirement is the ability to understand mortgage and home lending data, ask the right business questions, identify overlaps and inconsistencies across applications, and define how that data should be consolidated into a target ADS. The candidate will work with mortgage business stakeholders, product owners, application SMEs, enterprise data teams, architects, engineers, QA teams, and governance stakeholders to support data discovery, source analysis, mapping, consolidation, validation, and implementation readiness.
This is not purely a technical data modeler role. It is a domain consulting role requiring strong knowledge of mortgage servicing, loan origination, borrower, property, loan status, escrow, payment, delinquency, default, collateral, and reporting data, combined with the ability to work hands-on with data, SQL, profiling, and mapping artifacts needed to build a centralized Home Lending data store.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance, Business, Data Management, or a related discipline preferred, unless otherwise specified by the client or hiring organization.
- Senior-level experience in Mortgage / Home Lending domain consulting, business analysis, data analysis, data mapping, or data transformation roles within banking and financial services.
- Strong understanding of mortgage and home lending business processes, including loan origination, underwriting, processing, closing, boarding, servicing, escrow, payments, delinquency, default, payoff, and investor/reporting data.
- Strong experience working with mortgage data across multiple applications and helping business and technology teams understand how data is defined, used, transformed, and consumed across systems.
- Hands-on experience with data analysis and SQL for data discovery, profiling, reconciliation, source analysis, issue investigation, and mapping validation.
- Experience supporting the creation of Application Data Stores, Authorized Data Stores, data consolidation layers, enterprise data stores, curated layers, or trusted reporting data assets.
- Experience documenting business-aligned data definitions, source-to-target mappings, business rules, transformation logic, and data dictionaries for enterprise programs.
- Ability to identify duplicate, conflicting, redundant, and inconsistent mortgage data elements across applications and help define target-state data representations for consolidation.
- Experience working with legacy mortgage platforms, operational applications, extracts, reports, interfaces, and downstream data consumers.
- Ability to work closely with data architects and engineering teams while keeping the primary focus on business meaning, mortgage context, and target data usability.
- Familiarity with enterprise data platforms, cloud data environments, and large-scale data transformation programs.
- Strong written and verbal communication skills, with the ability to clearly articulate business meaning, data issues, assumptions, dependencies, mapping decisions, and implementation considerations to both business and technology stakeholders.
Preferred Experience
- Experience in Mortgage IT, Home Lending, Mortgage Servicing, Loan Origination, Fulfillment, Secondary Mortgage, or Mortgage Reporting transformation programs.
- Experience supporting the consolidation of data from multiple mortgage applications into a unified Application Data Store / Authorized Data Store / enterprise data platform.
- Experience working with mortgage business users and application SMEs to confirm the meaning of loan, borrower, property, escrow, payment, status, delinquency, collateral, and servicing-related fields.
- Experience analyzing legacy applications, database schemas, source tables, interfaces, extracts, and reports to understand current-state business and data behavior.
- Strong hands-on experience using SQL for source-system analysis, relationship discovery, data profiling, reconciliation, and validation support.
- Experience preparing clear and detailed source-to-target mappings covering source fields, target fields, transformations, derivations, business rules, data dependencies, and validation logic.
- Experience in rationalizing data across applications by identifying overlaps, duplicate fields, conflicting definitions, code variations, and unnecessary source-specific representations.
- Experience defining or supporting logical data models, canonical data views, subject-area models, or implementation-ready target structures for banking and mortgage data domains.
- Experience working with data governance, metadata, lineage, certification, data quality, and controlled data consumption processes.
- Experience collaborating with business stakeholders, product owners, architects, data engineers, QA teams, and program delivery leads in structured transformation programs.
- Experience supporting data validation, reconciliation, defect triage, and production-readiness during migration or data store implementation phases.
- Experience producing structured delivery artifacts such as mapping specifications, business rule inventories, data dictionaries, issue logs, assumption trackers, and review notes.
- Experience working in Agile, waterfall, or hybrid delivery environments in banking and enterprise data programs.
Job Responsibilities
- Work closely with mortgage business stakeholders, Home Lending SMEs, product teams, and application owners to understand the business meaning, usage, and dependencies of data across multiple Home Lending applications.
- Analyze existing mortgage and home lending systems to identify how data is captured, stored, transformed, reported, and consumed across servicing, origination, fulfillment, and downstream environments.
- Help define the target-state business-aligned data structures required to build a centralized Application Data Store / Authorized Data Store for the Home Lending division.
- Support consolidation of data from multiple Home Lending applications into a single trusted data store by identifying common entities, business definitions, overlaps, duplications, and standard target representations.
- Perform hands-on data analysis using SQL to profile data, validate source behavior, investigate anomalies, reconcile records, and support mapping and consolidation decisions.
- Prepare and maintain source-to-target mapping documents covering source elements, target elements, transformation logic, business rules, code conversions, dependencies, and validation considerations.
- Work with mortgage business teams to clarify the meaning of key data elements related to loan accounts, borrowers, co-borrowers, properties, collateral, escrow, payments, statuses, delinquency, default, and servicing transactions.
- Review legacy schemas, source tables, interfaces, reports, and data extracts to understand current-state data behavior and ensure business context is not lost during consolidation.
- Identify duplicate, redundant, conflicting, or inconsistent data definitions across mortgage applications and recommend clean, standardized target representations for the ADS.
- Support the definition of logical and implementation-aligned data models for the Home Lending data store in collaboration with enterprise data architects and engineering teams.
- Provide domain consulting inputs to ensure the consolidated data store reflects real business usage, reporting requirements, operational needs, and downstream consumption expectations.
- Collaborate with data architects and engineers to ensure that target structures, mappings, and business rules are implementable within the bank’s target data platform.
- Support data quality and governance efforts by documenting data definitions, lineage inputs, transformation assumptions, reference values, and certification requirements.
- Participate in workshops, walkthroughs, design sessions, and review meetings with business, architecture, engineering, QA, and governance stakeholders.
- Support data migration, data conversion, and ADS implementation activities by providing domain clarifications, mapping support, SQL-based validation, reconciliation inputs, and issue resolution guidance.
- Assist QA and validation teams by explaining expected business behavior, source-to-target logic, field-level meaning, and mortgage-specific dependency considerations.
- Maintain traceability between business requirements, source systems, mapping rules, target ADS structures, and governance expectations.
- Support production readiness and handoff activities by ensuring mappings, definitions, assumptions, issue logs, and validation artifacts are complete and aligned.
- Provide knowledge transfer to business teams, support teams, engineering teams, and downstream consumers on approved data definitions, consolidated target structures, and mortgage data dependencies.
Required Competencies
- Strong Mortgage / Home Lending domain expertise with the ability to interpret data in a business context.
- Strong understanding of mortgage business processes and data relationships across origination, servicing, and reporting environments.
- Hands-on capability in data analysis and SQL for source analysis, profiling, reconciliation, and validation support.
- Ability to bridge business and technology by translating mortgage domain understanding into clear data requirements, mappings, and target structures.
- Strong analytical and problem-solving capability in complex legacy application and multi-source data environments.
- Ability to convert fragmented or unclear source information into clear documentation, standard definitions, and decision-ready artifacts.
- Strong documentation discipline, including the ability to create artifacts usable by both business stakeholders and technical delivery teams.
- Effective stakeholder management across business teams, SMEs, architects, engineering teams, QA, governance, and delivery leadership.
- Ability to support data store consolidation and ADS readiness while adhering to enterprise standards and practical delivery needs.
- Clear written and verbal communication, including the ability to explain business rules, data dependencies, mapping decisions, risks, and open points without unnecessary technical complexity.
- Ability to manage multiple analysis, mapping, validation, and stakeholder workstreams in a structured delivery environment.
- Collaborative consulting style with strong ownership and client-facing professionalism.
Never miss an opportunity! Create an alert based on the job you applied for.