REAL ESTATE ANALYST

Company: U.S. Cellular
Location: Chicago
Posted on: November 1, 2024

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.

Keywords: U.S. Cellular, Mishawaka , REAL ESTATE ANALYST, Accounting, Auditing , Chicago, Indiana