Senior Property Revenue Analyst

JLL empowers you to shape a brighter way . Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward. Senior Property Revenue Analyst Location: Must be able to go into Chicago office 2x a month minimum As a Senior Property Revenue Analyst reporting to the FP&A Lead, you will be the primary owner of all revenue streams and billing processes across a retail property portfolio. You will ensure accurate and timely revenue recognition, billing, and reporting while providing critical analytical support to drive revenue optimization and financial performance. Responsible for managing complex recovery calculations, percentage rent billing, and revenue forecasting, you will deliver actionable insights that support strategic decision-making and maximize asset value. Your expertise in lease analysis, revenue modeling, and variance reporting will be essential to maintaining financial accuracy and identifying opportunities for revenue enhancement in the dynamic retail real estate environment. What You Will Deliver Revenue Billing & Management: • Manage all aspects of revenue billing for retail properties including operating cost recoveries (CAM, tax, insurance), percentage rent calculations, and manual billing processes • Ensure accurate and timely monthly billing cycles for all tenants across a retail portfolio • Analyze retail lease agreements to extract critical financial terms, billing requirements, and revenue recognition parameters • Review lease abstract database ensuring accuracy of key dates, rent steps, recovery provisions, percentage rent thresholds, and co-tenancy clauses • Support lease compliance and audit processes • Coordinate with property management and lease profile administration team to resolve billing discrepancies and tenant inquiries • Monitor and analyze percentage rent performance, sales thresholds, and tenant sales reporting • Support Property teams, FP&A team and Client with revenue related inquiries Revenue Recognition & Accruals: • Prepare monthly and quarterly revenue accruals in accordance with accounting standards and lease agreements • Ensure proper revenue recognition, timing and compliance • Support month-end and quarter-end close processes with accurate revenue reporting • Review the revenue components of the income statement, ensuring accuracy of the monthly financial statements Analysis & Reporting: • Conduct detailed variance analysis of revenue components (base rent, recoveries, percentage rent, parking, other income) comparing actual results to budget, forecast, and prior periods; providing business insights aligning with Operational KPIs • Analyze lease terms and conditions to identify revenue opportunities, billing requirements, and potential risks specific to retail tenancies • Prepare comprehensive revenue reports and dashboards for the FP&A Lead, senior management, asset managers, and clients • Analyze tenant sales performance and its impact on percentage rent revenue Forecasting & Budgeting: • Participate in revenue forecasting processes including quarterly reforecasts and annual budget preparation for retail properties • Build sophisticated revenue models incorporating lease schedules, occupancy assumptions, recovery projections, percentage rent scenarios, and market conditions • Develop scenario and sensitivity analysis to evaluate the financial impact of leasing activity, rent escalations, vacancy assumptions, tenant mix changes, and market dynamics • Collaborate with leasing, property management, and asset management teams to ensure forecast assumptions reflect current business plans and retail market trends Process Improvement & Innovation: • Identify and implement opportunities to streamline revenue processes, enhance controls, and improve reporting accuracy through automation and AI-enabled tools • Leverage AI tools to support data analysis, forecasting, workflow automation, and business communication • Contribute to system implementations and upgrades related to revenue management • Develop and maintain standard operating procedures and documentation for revenue processes • Support ad hoc analysis, special initiatives & projects as needed and directed by leadership. What You Need to Succeed Required Qualifications: • University degree in Business, Finance, Accounting, or related field • Minimum 3-5 years of experience in revenue accounting, property accounting, or financial analysis within retail real estate • Strong understanding of retail lease structures including CAM language, percentage rent, co-tenancy provisions, and tenant sales reporting requirements Technical & Analytical Expertise: • Expert-level financial modeling skills and advanced Microsoft Excel proficiency (complex formulas, pivot tables, macros, scenario modeling, data analysis) • Functional knowledge of AI tools to support financial analysis, data summarization, workflow automation, and business communication • Proficiency with Microsoft Office Suite (PowerPoint, Word, SharePoint) • Knowledge of Yardi Voyager and Forecast Manager (asset) • Experience with Power BI, Power Query, or similar data visualization tools (preferred) • Strong ability to build revenue forecast models with scenario and sensitivity analysis capabilities • Ability to work with large datasets, reconcile complex information, and ensure data accuracy Core Competencies: • Exceptional attention to detail with proven ability to manage multiple deadlines and maintain accuracy in a high-volume dynamic environment • Strong analytical and pr