Senior Financial Systems & Data Analyst

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

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 improvements, including assessment of downstream reporting and control impacts.

Qualifications

Required

• Bachelor's degree in Finance, Accounting, Information Systems, Data Analytics, or related field.
• 3-5 years of progressive experience in finance, accounting, financial systems, business intelligence, or data analytics.
• Advanced SQL skills, including the ability to develop and troubleshoot queries used for analysis and recurring reporting.
• Experience with Yardi or similar ERP systems.
• Advanced Excel and data analysis capabilities, including experience reconciling large or complex datasets.
• Excellent problem-solving, project coordination, and cross-functional communication skills, with the ability to work independently and communicate recommendations clearly.

Preferred

• Experience with Argus Enterprise.
• Commercial real estate, publicly traded REIT, or property management experience.
• Understanding of lease administration, CAM recoveries, real estate accounting, and financial reporting controls.

What we offer

At Kilroy, base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within the role. The base pay range for this role is between $100,000 and $130,000 and your base pay will depend on your skills, experience and training, knowledge, licensure and certifications, and other business and organizational needs. It is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. This role