Senior Mortgage Data Analyst - Data Transformation
Listed on 2026-07-20
-
IT/Tech
Data Engineering, Data Analyst, Business Systems & Technology Analysis, Data Warehousing
Senior Mortgage Data Analyst – Data Transformation
PLEASE NOTE:
IT IS 100% on site position in McLean, VA. KEY
REQUIRED SKILLS:
Data lineage, data mapping, business process analysis, Cloud Data Platform
DESCRIPTION:
We are seeking an experienced Senior Mortgage Data Analyst – Data Transformation to support a large-scale enterprise data transformation initiative for a leading financial services organization. In this role, you will serve as the bridge between business stakeholders and technical teams, ensuring business requirements are accurately translated into scalable, cloud-based data solutions. A key role in data analysis, business process optimization, requirements definition, stakeholder collaboration, and ensuring high-quality delivery throughout the project lifecycle.
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 target-state cloud-based data architectures. Gather, analyze, and document business and functional requirements for enterprise data transformation initiatives. Create user stories, business process flows, functional specifications, and acceptance criteria for development teams. Partner with business stakeholders, architects, data engineers, and product owners to define business-aligned 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 deliverables meet business objectives, quality standards, and project timelines. Facilitate stakeholder meetings, manage expectations, and communicate project progress effectively. Utilize AI-powered productivity tools such as Microsoft Copilot, ChatGPT, Claude, or other approved LLMs to improve documentation, analysis, and delivery efficiency.
Support enterprise data governance initiatives and ensure adherence to organizational data standards.
REQUIRED
QUALIFICATION:
Bachelor's degree in Computer Science, Information Systems, Business, Data Analytics, Finance, or a related discipline. 7+ years of Business Analysis experience supporting enterprise data, analytics, or technology transformation programs. Proven experience in data lineage, data profiling, data mapping, and business process analysis. Strong experience gathering and documenting business, functional, and 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 verbal and written communication skills. Experience working in Agile environments.
PREFERRED
QUALIFICATION:
Experience with in the secondary mortgage industry. Hands-on experience with cloud data platforms such as Snowflake, Databricks, Azure, AWS, or Google Cloud Platform. Experience with enterprise data modernization and legacy system transformation projects. Experience using Azure Dev Ops, Jira, or similar Agile project management tools. Familiarity with AI-assisted business analysis tools including Microsoft Copilot, ChatGPT, and Claude. Professional certifications such as CBAP, PMI-PBA, Scrum, or Agile certifications are a plus.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).