Business Analyst – Fund Reporting Migration

Location: Dallas, TX | Hybrid – 4 days onsite / 1 day remote
Positions: 2

Job Overview

We are seeking two experienced Business Analysts to support a major fund reporting migration for a global institutional asset management organization.

The project involves migrating real estate fund reporting from a legacy Yardi-based platform to a Snowflake data environment. The Business Analysts will work closely with business, finance, and technology teams to validate financial data, reconcile source and target systems, test reporting functionality, and support business sign-off ahead of go-live.

This is a hands-on Business Analyst role requiring strong SQL, Python, financial data analysis, UAT, and reconciliation experience.

Key Responsibilities

Business Testing & UAT

• Develop detailed test cases, scenarios, and test plans.
• Support and lead UAT execution across legacy and target platforms.
• Validate entity structures, hierarchies, investor and capital balances, treasury, and fund lifecycle scenarios.
• Track defects through resolution and coordinate retesting.
• Prepare test evidence and support formal business sign-off.

Data Validation & Reconciliation

• Perform detailed reconciliation across Yardi, Investran, and Snowflake.
• Validate general ledger, trial balances, capital balances, investor balances, and other financial data.
• Perform row-count, aggregate, control-total, and period-over-period validation.
• Investigate discrepancies, identify root causes, and drive variances to resolution or documented explanations.
• Develop SQL queries to independently interrogate source and target datasets.
• Use Python/Pandas to automate repeatable data validation and reconciliation processes.

Reporting Migration

• Reverse-engineer existing financial and fund reports to understand underlying business logic.
• Document existing report requirements, calculations, KPIs, and data dependencies.
• Define requirements for future-state reporting in Snowflake.
• Validate rebuilt reports against legacy outputs and expected business results.
• Validate downstream financial, performance, and benchmark reporting.

Defect & Test Cycle Management

• Own test planning, defect tracking, prioritization, and retesting.
• Maintain test evidence, reconciliation packs, and daily status reporting.
• Coordinate with SMEs, business users, developers, and technology teams to resolve issues.
• Proactively manage testing activities and ensure execution stays on schedule.

Stakeholder Management

• Participate in business and technical workshops.
• Act as a bridge between business/finance stakeholders and technology teams.
• Clearly communicate testing results, data discrepancies, defects, and reporting readiness.
• Support business owners through final validation and sign-off.

Required Qualifications

• Strong Business Analysis experience within financial services, asset management, investment management, or related environments.
• Advanced SQL skills – mandatory. Ability to independently write queries against large financial datasets.
• Python/Pandas experience – mandatory, particularly for data validation, reconciliation, and automation.
• Strong experience with UAT, test planning, test case development, execution, and defect management.
• Strong understanding of fund accounting, including:
  • General Ledger (GL)
  • Trial Balance
  • Chart of Accounts
  • Capital Accounts
  • Investor Balances
  • Financial Reporting
• Experience analyzing and validating financial reports and KPIs.
• Advanced Excel skills.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and actively manage testing cycles and stakeholder discussions.

Preferred Qualifications

• Experience with Snowflake or another cloud data warehouse in a migration or data-validation environment.
• Experience with Yardi and/or Investran.
• Experience in real estate or real-assets fund accounting.
• Experience with source-to-target data migration or platform conversion projects.
• Experience with Power BI, Tableau, or Streamlit.
• Experience validating downstream financial, performance, or benchmark reporting.

Ideal Candidate

The ideal candidate is a hands-on Business Analyst who combines financial/fund accounting knowledge with strong technical data skills.

You should be comfortable writing SQL, working with Python/Pandas, investigating financial data discrepancies, understanding complex reporting logic, managing UAT, and communicating issues directly with business stakeholders and technology teams.