Real Estate Analyst

U.S. Cellular; Chicago (IL); On-site; USD 50,000 - 100,000; Full time

Job summary

An established industry player is seeking a Real Estate Analyst to manage lease administration and financial relationships with landlords. This role involves analyzing large financial data sets, ensuring compliance with lease obligations, and identifying process improvements. You will be responsible for maintaining a vast real estate system, processing significant annual rent payments, and providing support to business partners. If you are detail-oriented and possess strong analytical skills, this opportunity offers a chance to make a meaningful impact in a dynamic environment.

Qualifications

• 0-3 years of experience in real estate or finance.
• Minimum one year analyzing large financial data sets.

Responsibilities

• Interpret real estate leases and lead rent payments.
• Maintain financial relationships with landlords and compute rental allowances.
• Analyze lease-related operating expenses and drive process improvements.

Skills

Advanced Excel

Interpersonal Skills

Written Communication

Oral Communication

Financial Analysis

Education

Bachelor's Degree in Business Administration

Bachelor's Degree in Finance

Tools

SAP

Tririga

Job description

Responsible for interpreting real estate leases, as well as leading rent and real estate related payments. The REA will update the real estate system with lease administration information, ensuring data integrity, and finding opportunities for improvement and increased efficiency. The REA is responsible for maintaining the financial relationship with the landlords and for determining how to compute rental, common area maintenance (CAM) property tax, and tenant improvement allowances. The REA will be responsible for owning the FARES facility budget, COI requests, option payments, and team metrics and reporting.

• Run assigned budget for the approximately $50M FARES facilities.


• Build models and collaborate with business partners to develop assumptions, and seeking to targets.


• Resolve financial lease issues between internal or external parties.


• Analyze and reconcile lease-related Operating Expense, identifying exceptions to lease provisions.


• Analyze and assess business results and identify, recommend, and drive process improvements.


• Ensure compliance of lease insurance obligations, process certificates of insurance, and coordinate various lease changes.Interpret language on leases and legal documents.


• Maintain Real Estate system for over 10K leases in accordance with SOX and accounting controls.


• Reconcile tenant improvement allowances and property tax reimbursements to ensure accurate billing by USCC's landlords.


• Provide direction, support, and training to key business partners.


• Build ad hoc real estate reports when requested from the field and other internal and external clients.


• Identify industry trends that impact our ability to provide needed financial expertise to our business partners.


• Ensure rent payments of about $150M annually are processed.


• Perform special projects as assigned.

REQUIRED QUALIFICATIONS

• 4 year degree in a related field such as Business Administration or Finance.


• 0-3 years of experience in a real estate or finance related field.


• Minimum one year analyzing and aggregating large financial data sets.


• Advanced Excel including using and creating formulas.


• Demonstrated strong interpersonal skills, coupled with strong written and oral communication skills.

PREFERRED QUALIFICATIONS

• Experience with SAP and Tririga.