FP&A Analyst at The Scion Group in Chicago, IL

Summary: The Scion Group LLC is seeking a talented Financial Planning & Analysis Analyst to join their team. This role focuses on delivering accurate budgeting, forecasting, and financial reporting while driving continuous process improvement. The Analyst will collaborate with various departments to assess performance, develop financial models, and support the budgeting process. Responsibilities: - Help to maintain the overall reporting process through use of automation, databasing, and business intelligence tools - Assess monthly performance and determine key trends across individual properties and portfolios - Develop presentations and detailed financial analysis results in a well-defined format - Develop monthly cash balance projections to forecast distributions and create meaningful analysis of future cashflows - Create and maintain various financial models and asset management tracking tools dedicated to providing a clear understanding of investment performance - Support the property-level annual budgeting and periodic reforecast process, owning and/or assisting various revenue and expense workstreams and working closely with asset management, property operations, revenue management, capital, and other departments to ensure the highest quality budgets - Review proposed budgets through detailed trend analysis of historical performance, portfolio and external benchmarks, contracts, and new strategic initiatives to identify outliers and improvement opportunities - Be an expert in the budgeting and forecasting system and process - Perform special research, analysis, and ad hoc projects for a multitude of stakeholders on a frequent basis collaborating closely with all departments across the organization - Leverage executive communication skills to clearly explain analysis results to internal peers, senior management, external investors Required Qualifications: - Bachelor's Degree in Engineering, Finance, Economics, Accounting, Mathematics, or other STEM program is preferred; 1-3 years of professional experience - Advanced financial modeling skills with Excel (VBA is a plus) - Excellent written and verbal communication skills with PowerPoint experience - Strong collaboration across all departments and with external partners Preferred Qualifications: - Experience with data visualization and business intelligence tools is preferred (Looker is a plus) - Experience with Vena and Entrata is preferred Required Skills: Financial modeling, Excel, VBA, Data visualization, Business intelligence tools, Looker, PowerPoint, Vena, Entrata, Budgeting, Forecasting, Variance analysis, Capital expenditure analysis, Market research, Financial reporting Benefits: Discretionary annual bonus, Paid Time Off + Floating Holidays, Health Insurance, Dental Insurance, Vision Insurance, 401k Matching, Paid Maternal Leave, Parental Leave, Learning reimbursement opportunities