Functional / Financial Analyst — Investor Reporting Automation

We are seeking a Functional / Financial Analyst to support quarterly investor and consultant reporting while helping transition a manual, Excel-heavy process into a scalable automated operating model.

Key responsibilities

Investor reporting and analysis

- Prepare, maintain, and review investor and consultant questionnaires, supporting working files, and recurring quarterly reporting deliverables.
- Analyze and reconcile financial, fund, portfolio, investor, and performance data across multiple source files and systems.
- Validate data and calculations related to balance sheets, capital roll-forwards, NOI, cap rates, debt maturities, WALT/WALv, dividend yield, fund-status reporting, investor activity, and property-level metrics.
- Create and enhance financial reports, management reporting, portfolio-performance analyses, and dashboard-ready datasets for Finance, Fund Operations, Portfolio Management, and investor-reporting stakeholders.
- Perform actual-versus-budget, actual-versus-prior-period, forecast, and variance analysis; investigate material movements, data anomalies, and missing or inconsistent information.
- Trace reported values from final questionnaires and reports through working files to the underlying source data, ensuring outputs are accurate, transparent, and auditable.
- Review Excel formulas, lookups, roll-ups, and aggregations to identify broken links, incorrect calculations, zero-value errors, outdated templates, or inconsistent prior-quarter carry-forward treatment.
- Support the appropriate treatment of reporting exceptions, including restricted disclosures, pref-equity positions, consultant-specific requirements, and property-level data limitations.

Automation and functional support

- Document and rationalize existing SOPs, questionnaire templates, source files, business rules, exceptions, approvals, and submission requirements.
- Convert manual reporting processes into functional specifications, including field-level source mappings, calculation logic, transformation rules, disclosure requirements, acceptance criteria, and test scenarios.




- Partner with business stakeholders to resolve ambiguous requirements and inconsistencies across SOPs, prior submissions, working files, and source systems.
- Support the conversion of reporting processes into automated workflows, including Excel-based automation, AI-enabled reporting tools, and QA controls.
- Independently test and validate automated questionnaires and working files, confirming accuracy of figures, formulas, source linkages, formatting, disclosures, and template versions before business review.
- Help establish QA controls to identify missing values, broken source links, formula errors, incorrect roll-ups, unexpected variances, invalid templates, and submission-blocking macro issues.
- Coordinate source-data collection and validation from Yardi, Fund Status Reports, investor logs, master files, performance reporting, Portfolio Management inputs, SharePoint, and prior-quarter submissions.
- Maintain documentation for SOPs, field mappings, business rules, test results, known issues, approvals, and change history.
- Act as a functional liaison between reporting stakeholders, data owners, and automation delivery teams, tracking dependencies, risks, defects, and reporting-cycle deliverables.

Required qualifications

- Bachelor’s degree in Finance, Accounting, Business, Economics, Information Systems, or a related field.
- 7+ years of experience in financial analysis, investor reporting, fund operations, fund accounting, investment operations, real estate finance, or financial-systems business analysis.
- Advanced Excel skills, including XLOOKUP, SUMIF/SUMIFS, INDEX/MATCH, PivotTables, formula auditing, data validation, error checking, reconciliation, and complex workbook review.
- Experience creating, analyzing, and explaining financial reports,



recurring management reporting, performance analyses, and dashboard-ready datasets.
- Robust understanding of financial statements, reconciliations, financial-reporting concepts, variance analysis, period-over-period analysis, and reporting controls.
- Ability to interpret real estate financial and operating metrics, including revenue, expenses, NOI, cash flow, debt, cap rates, valuation inputs, fund-level performance, capital activity, and investor reporting.
- Demonstrated ability to trace financial outputs to their underlying source data and explain calculation, aggregation, and reporting logic.
- Experience documenting business processes and converting requirements into functional specifications, field mappings, workflow diagrams, user stories, test cases, or acceptance criteria.
- Strong attention to detail, organization, and ability to manage multiple time-sensitive deliverables during quarterly reporting cycles.
- Clear communication skills and the ability to work with both business stakeholders and technical delivery teams.
- Ability to handle confidential investor, fund, portfolio, and financial information with discretion.

Preferred qualifications

- Experience in private real estate, private equity real estate, private credit, real assets, alternative investments, fund administration, or institutional investor reporting.
- Familiarity with investor and consultant questionnaires, due-diligence reporting, fund-performance reporting, capital-account activity, NAV-related reporting, and capital roll-forwards.
- Experience with Yardi, eFront, Argus, MRI, or comparable real estate accounting, investment-management, or performance-reporting systems.
- Familiarity with property budgets, forecasts, operating statements, debt schedules, valuation reports, asset-management reporting, and real estate investment-performance metrics such as IRR, MOIC/equity multiple, cash-on-cash return, and yield.
- Experience working with SharePoint, Asana, Jira, Smartsheet, enterprise data warehouses, reporting data marts, or governed data sources.

📌 Functional / Financial Analyst (Canada)
🏢 Accion Labs
📍 Canada