Senior Mortgage Data Analyst – Data Transformation

Job Title: Senior Mortgage Data Analyst – Data Transformation
Location: McLean, VA
Work Mode: In Office
Experience Required: 10+ Years
Employment Type: Contract

Role Overview

We are seeking an experienced Senior Mortgage Data Analyst – Data Transformation to support a large-scale enterprise data transformation initiative within the financial services industry. This role serves as the bridge between business stakeholders and technical teams, ensuring business requirements are translated into scalable, cloud-based data solutions.

The ideal candidate will have strong expertise in business analysis, data lineage, data mapping, cloud data platforms, and enterprise data transformation, along with excellent stakeholder management and communication skills.

Key Responsibilities

• Perform data lineage analysis, data profiling, and data mapping across enterprise applications and data platforms.
• Analyze legacy data assets and map them to modern cloud-based target architectures.
• Gather, analyze, and document business, functional, and technical requirements for enterprise data transformation initiatives.
• Create user stories, business process flows, functional specifications, and acceptance criteria for development teams.
• Collaborate with business stakeholders, architects, data engineers, and product owners to define scalable data solutions.
• Evaluate event-driven and entity-based data models while identifying transformation opportunities and data gaps.
• Support cloud-based data ingestion and integration initiatives.
• Coordinate User Acceptance Testing (UAT), Quality Assurance (QA), and validation activities.
• Ensure project deliverables meet business objectives, quality standards, and delivery timelines.
• Facilitate stakeholder meetings, manage expectations, and communicate project progress effectively.
• Utilize AI-powered productivity tools such as Microsoft Copilot, ChatGPT, and Claude to improve documentation, analysis, and delivery efficiency.
• Support enterprise data governance initiatives and ensure adherence to organizational data standards.

Required Qualifications

• Bachelor''s degree in Computer Science, Information Systems, Business, Data Analytics, Finance, or a related field.
• 7+ years of experience in Business Analysis supporting enterprise data, analytics, or technology transformation initiatives.
• Proven expertise in:
  • Data Lineage
  • Data Profiling
  • Data Mapping
  • Business Process Analysis
• Strong experience gathering and documenting:
  • Business Requirements
  • Functional Requirements
  • Technical Requirements
• Experience working with cloud-based data platforms and modern data ingestion architectures.
• Knowledge of enterprise data architecture, data governance, and data integration concepts.
• Strong analytical, problem-solving, and stakeholder management skills.
• Excellent written and verbal communication skills.
• Experience working in Agile environments.

Preferred Qualifications

• Experience within the secondary mortgage or financial services industry.
• Hands-on experience with cloud data platforms such as:
  • Snowflake
  • Databricks
  • AWS
  • Azure
  • Google Cloud Platform (Google Cloud Platform)
• Experience supporting enterprise data modernization and legacy system transformation projects.
• Experience with Agile tools such as Azure DevOps and Jira.
• Familiarity with AI-assisted productivity tools including Microsoft Copilot, ChatGPT, and Claude.
• Professional certifications such as:
  • CBAP
  • PMI-PBA
  • Scrum Master
  • Agile Certifications