The Role
Lead enterprise mortgage data transformation by performing data lineage, profiling, and mapping; translate business needs into cloud-based data solutions; define requirements, user stories, and acceptance criteria; coordinate UAT/QA; support cloud ingestion, governance, and stakeholder collaboration throughout delivery.
Summary Generated by Built In
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.
Requirements
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 within 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 DevOps, 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.
Skills Required
- Data lineage
- Data mapping
- Business process analysis
- Cloud Data Platform experience
- Bachelor's degree in Computer Science, Information Systems, Business, Data Analytics, Finance, or related discipline
- 7+ years business analysis supporting enterprise data, analytics, or technology transformation
- Data profiling experience
- Gathering and documenting business, functional, and technical requirements
- Experience 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
- Experience within the secondary mortgage industry
- Hands-on experience with Snowflake, Databricks, Azure, AWS, or Google Cloud Platform
- Experience with enterprise data modernization and legacy system transformation projects
- Experience using Azure DevOps, 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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Omm IT Solutions is a leading provider of IT consulting, analysis, and advisory services, specializing in delivering technical solutions for federal and state government agencies. Their offerings include application development, cybersecurity services, cloud advisory, network modernization, and data analytics.
