About the Opportunity
Kilroy Realty Corporation is seeking a highly analytical and detail-oriented Senior Financial Systems & Data Analyst to serve as the bridge between Finance, Accounting, and Information Technology. This role will own the integrity of critical financial and operational data across Yardi and Argus, while helping advance Kilroy's long-term data strategy.
The ideal candidate combines strong financial acumen with advanced technical skills, exercises sound judgment, and enjoys solving complex data problems. This role will lead efforts to improve forecasting accuracy, enhance reporting capabilities, support system implementations, and establish finance as a trusted source of data across the organization. This position will report to the Vice President, FP&A.
Key Responsibilities
Financial Systems & Data Governance
- Own and administer key financial planning and operational data within Yardi and Argus.
- Lead recurring reconciliations between Yardi, Argus, and FP&A reporting models.
- Investigate root causes of data discrepancies, coordinate resolution, and establish controls to improve data integrity.
Accounting & CAM Reconciliations
- Partner with Accounting to lead the monthly reconciliation of Common Area Maintenance (CAM) setups and recoveries in Argus.
- Review tenant charge structures and lease data to ensure consistency between lease documents and system records, and resolve identified exceptions.
- Lead process improvement initiatives that reduce manual reconciliation effort and strengthen data controls.
Business Intelligence & Data Modeling
- Partner with IT and business stakeholders to lead the development of data warehouses, reporting solutions, and analytical tools.
- Define finance data requirements, business rules, validation criteria, and reporting standards.
- Develop advanced SQL queries and perform data validation to support reporting and analytics initiatives.
- Develop and maintain reusable SQL queries for ad hoc and recurring information requests.
- Create and enhance dashboards and recurring reports to support forecasting and performance management.
System Enhancements & Testing
- Act as finance lead for User Acceptance Testing (UAT) on data models, system changes, integrations, and upgrades.
- Develop testing plans, document requirements and expected results, execute test scripts, manage identified issues, and coordinate business validation.
- Lead ongoing process automation and workflow