Business Analyst Standard II

Conduct business walkthroughs of the end-to-end quarterly DSC process, including input collection, present value (PV) calculations, consolidation of Total Resources Available (TRA) and Total Resources Required (TRR), conservation buffer, DSC, and DSC ratio reporting. Develop functional, data, integration, and user acceptance test plans and cases covering source inputs, transformations, PV calculations, approved model output ingestion, TRA/TRR consolidation, conservation buffer, DSC, and DSC ratio.

Position Summary:
Title: Business Analyst Standard II
Duration: 6 Months Possible Extension
Location: Washington, DC 20433

Hybrid Onsite: 4 days per week from Day 1, with a full transition to 100% onsite anticipated soon

SCOPE OF WORK
The Business Analyst will lead the functional/business and data analysis for IDA DSC automation and will be based onsite. Working as part of the ITS Risk and Analytics (ITSRA) team, the analyst will review the current quarterly DSC process, source inputs, calculation workbooks, and model interfaces with business stakeholders and technical teams. The scope includes documenting business requirements, data mappings, calculation rules, assumptions, controls, functional specifications, and reporting requirements to support a consistent, repeatable, and auditable automated process. The analyst will coordinate across business, support functions, and onsite/offshore vendor teams, identify opportunities to reduce manual effort, and support implementation and validation of enhancements to the existing country sovereign risk data repository and reporting platform.

Responsibilities

• Analysis and Documentation:

• Conduct business walkthroughs of the end-to-end quarterly DSC process, including input collection, present value (PV) calculations, consolidation of Total Resources Available (TRA) and Total Resources Required (TRR), conservation buffer, DSC, and DSC ratio reporting. Document current manual steps, dependencies, control points, and automation requirements.
• Review existing calculation workbooks and supporting model documentation with business owners. Document formulas, calculation sequences, assumptions, loan inclusion/exclusion rules, market-rate and stress-rate scenarios, aggregation logic, and the treatment of disbursed and undisbursed exposures. Translate agreed requirements into functional and technical specifications.
• Inventory and analyze DSC inputs from LIS and accounting sources, including loan portfolio balances, exposures, repayment schedules, interest rates, discount rates, equity, pension, cash, grants, and valuation adjustments. Document source-to-target mappings, field definitions, reporting dates, granularity, transformations, joins, and data lineage; define completeness, accuracy, and reconciliation checks.
• Validate input definitions, calculation rules, assumptions, and expected outputs with business and model owners. Distinguish source values passed through unchanged from derived values, resolve data and requirements gaps, and maintain traceability from approved requirements to specifications and test cases.

• Design and Development:

• Document the functional design for automated input ingestion, PV calculations at loan and portfolio levels, TRA/TRR consolidation, and DSC reporting. Specify dashboard/report layouts, underlying data, formulas, exception handling, and audit evidence requirements.
• Review the existing standalone capital adequacy model interface and document requirements to consume its approved MPL output for TRR calculation, rather than duplicate its validated model logic. Work with business/model owners and IT teams to confirm input/output definitions, reporting-period alignment, model version and assumption references, integration controls, and implementation requirements; refer methodology changes to the responsible model owners.

• Testing and Validation:

• Develop functional, data, integration, and user acceptance test plans and cases covering source inputs, transformations, PV calculations, approved model output ingestion, TRA/TRR consolidation, conservation buffer, DSC, and DSC ratio. Agree expected results and reconciliation tolerances with business and model owners before testing.
• Reconcile ingested inputs to approved source reports and compare automated calculations with business-approved workbook or model outputs for representative reporting periods and market/stress scenarios. Validate loan-level results, portfolio aggregations, reporting-period consistency, and end-to-end traceability from inputs to reported DSC results.
• Investigate missing inputs, data-quality exceptions, mapping errors, and calculation discrepancies with business, model, and IT teams. Record defects and decisions, verify corrections through retesting, and compile reconciliation evidence and outstanding exceptions for business review and acceptance.

• Stakeholder Engagement:

• Engage with key stakeholders, including finance, risk management, and IT teams.
• Provide regular updates and reports on project progress.
• Facilitate workshops and meetings to ensure alignment and understanding.
• Primary interface for offshore and onsite project teams

• Training and Support:

• Develop training materials and conduct training sessions for end-users.
• Provide ongoing support and troubleshooting for data reporting solutions.

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)
Business Domain: Prior experience and knowledge of Capital markets, Credit Risk Management, Financial risk management and/ or finance / Accounting
Years of relevant experience: 6 to 7+ years


EEO:

Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.