Business Analyst - W2 Only

Location: Washington D.C 20433 (Onsite)

Duration: Long-term Contract

W2 only

SKILLS / EXPERIENCE REQUIRED

Must have skill set: Very good experience in business analysis, data analysis, requirements and data mapping documentation, experience documenting reporting specifications. Excellent communication skills. Knowledge of Dremio and power BI is a plus.

Technologies: SQL, Oracle, Azure Data Lake, Python (preferable)

• Analyze existing DSC processes, calculation workbooks, data sources, dependencies, controls, and automation requirements.
• Document business requirements, functional/technical specifications, calculation formulas, assumptions, loan inclusion/exclusion rules, and market/stress scenarios.
• Create source-to-target data mappings, transformations, joins, data lineage, reconciliation rules, and data-quality checks for LIS and accounting inputs.
• Define automated data ingestion, present value (PV) calculations, loan/portfolio aggregation, TRA/TRR consolidation, conservation buffer, DSC ratios, dashboards, and audit controls.
• Document integration of approved MPL model outputs for TRR without duplicating validated model logic.
• Develop and execute functional, data, integration, and UAT test cases; validate calculations, reporting periods, and market/stress scenarios against approved source reports and models.
• Investigate data discrepancies, mapping issues, calculation defects, and exceptions; coordinate fixes, retesting, and business sign-off.
• Collaborate with finance, risk, IT, business/model owners, and onsite/offshore teams; conduct workshops and provide project updates.
• Prepare user documentation, deliver training, and support reporting solutions.