Location-Onsite @Mc Lean, VA-Need Locals
Duration –Contract
Skills Needed: Data Analysis, Python, SQL, Securitization, Mortgage Experience, Agile + Jira, etc
Position Overview
We are seeking an experienced Data Analyst with strong analytical, technical, and domain expertise in Securitization and the Mortgage industry. The ideal candidate will be proficient in Python, SQL, and data analysis techniques, with hands-on experience working in Agile environments and using tools like Jira. This role involves supporting securitization processes, performing data validation, developing analytical models, and ensuring the accuracy and integrity of mortgage-related datasets.
Key Responsibilities
- Analyze large and complex datasets related to mortgage portfolios, loan performance, and securitization activities.
- Develop and maintain Python scripts and SQL queries for data extraction, transformation, analysis, and reporting.
- Support securitization workflows, including data prep, validation, audit checks, waterfall models, and investor reporting.
- Work closely with business stakeholders, risk, compliance, and finance teams to interpret data and produce actionable insights.
- Collaborate with cross-functional teams in an Agile environment; manage tasks and stories through Jira.
- Build dashboards, reports, and automated analytics using Python, SQL, and visualization tools (Power BI/Tableau is a plus).
- Perform data quality checks, reconcile loan-level data, and help enhance data processes to improve accuracy and efficiency.
- Document data flows, business rules, and analytical models to ensure transparency and reproducibility.
- Translate business requirements into analytical solutions and ensure deliverables meet regulatory and investor guidelines.
Required Skills & Qualifications
- 9+ years of experience as a Data Analyst or similar analytical role.
- Strong proficiency in Python (Pandas, NumPy, data processing & automation).
- Advanced SQL skills (complex joins, window functions, performance tuning).
- Solid understanding of Mortgage industry concepts—loan origination, servicing, credit risk, delinquency metrics, prepayment, securitization pools, etc.
- Hands-on experience with Securitization processes (pooling, loan data tapes, waterfall structures, reporting).
- Experience working in Agile/Scrum methodologies with tools like Jira.
- Strong analytical and problem-solving skills with the ability to work with large structured/unstructured datasets.
- Excellent communication skills, able to explain technical concepts to non-technical stakeholders.
Preferred Qualifications
- Experience with mortgage-backed securities (MBS), ABS reporting, or GSE-related datasets (Fannie Mae, Freddie Mac, Ginnie Mae).
- Familiarity with data visualization tools such as Power BI, Tableau, or Looker.
- Understanding of cloud platforms (AWS/GCP/Azure) for data processing is a plus.
- Knowledge of statistical modeling or machine learning techniques.
—
