Finance Data Architect: Forecasting & Systems

Kilroy Realty Corporation; Los Angeles (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

Kilroy Realty Corporation is seeking a Senior Financial Systems & Data Analyst to bridge Finance, Accounting, and IT. You will own financial data across Yardi and Argus, improve forecasting accuracy, and advance Kilroy's data strategy.

The role reports to the VP FP&A and offers a path to influence reporting standards and data controls. The ideal candidate has strong financial acumen, advanced SQL, Excel, and experience with ERP data integration and dashboards.

Qualifications

• Bachelor's degree in Finance, Accounting, IS, Data Analytics, or related field.
• 3–5 years of progressive experience in finance, accounting, financial systems, BI, or data analytics.
• Advanced SQL skills to develop and troubleshoot queries for analysis and recurring reporting.
• Experience with Yardi or similar ERP systems.
• Advanced Excel and data analysis capabilities for large datasets.
• Excellent problem-solving, project coordination, and cross-functional communication skills.

Responsibilities

• Own and administer key financial planning and operational data within Yardi and Argus.
• Lead reconciliations between Yardi, Argus, and FP&A reporting models.
• Investigate data discrepancies, coordinate resolution, and strengthen data controls.
• Partner with IT and business stakeholders to develop data warehouses, reporting solutions, and analytics tools.
• Define finance data requirements, rules, validation, and reporting standards.
• Develop and maintain reusable SQL queries for ad hoc and recurring requests.
• Create and enhance dashboards and recurring reports to support forecasting and performance management.
• Lead UAT for data models, system changes, integrations, and upgrades.
• Develop testing plans, document requirements, execute scripts, and coordinate validation.
• Lead process automation and workflow improvements affecting downstream reporting.

Skills

SQL

Excel

Cross-functional communication

Finance systems experience

Education

Bachelor's degree

Tools

Yardi

Argus Enterprise

Job description

Kilroy Realty Corporation is seeking a Senior Financial Systems & Data Analyst to bridge Finance, Accounting, and IT. You will own financial data across Yardi and Argus, improve forecasting accuracy, and advance Kilroy's data strategy.

The role reports to the VP FP&A and offers a path to influence reporting standards and data controls. The ideal candidate has strong financial acumen, advanced SQL, Excel, and experience with ERP data integration and dashboards.