Analyst II - Finance

Company BackgroundAbout Real Capital SolutionsReal Capital Solutions is a highly entrepreneurial real estate investment company pairing active capital with an emphasis on street level solutions. As an active investment management company, RCS sources investment deals in value-add, opportunistic and high barrier to entry markets. RCS is solutions oriented real estate company that focuses on acquisitions and management of complex and structured real estate opportunities. The company has over 40 years of operational and real estate expertise and a portfolio that currently encompasses more than 85 real estate projects comprising 20 million square feet and comprising approximately $2.8 billion in value.SummaryThe Financial Analyst II will take an active role in managing a portfolio of projects across various asset types and strategies. The role involves developing detailed knowledge of assets and providing ongoing financial analysis and operational support, with a strong emphasis on leveraging technology to drive data-driven decisions and improve portfolio operations. This role will also support the Finance Manager in capital management and analysis.This position requires a strong foundation in real estate finance, with opportunities to learn, grow, and contribute to the portfolio’s strategic objectives. The ideal candidate is detail-oriented, highly analytical, and self-motivated, with strong financial modeling, communication, and writing skills. The role offers exposure to multiple facets of real estate finance and the chance to make meaningful contributions to the team’s strategic and operational initiatives.ResponsibilitiesFinancial Projections & ReportingComplete semi-annual forecast updates on deals, including operating, debt and equity cash flows.Provide projections and analysis related to new leasing & financingAnalyze Argus models for various asset typesSupport the reporting of actual and pro-forma performance of each dealResearch and resolve issues related to financial performanceAssist with preparing various internal and external reportsSupport semi-annual portfolio valuationEquity Management Review and analyze each deal-level projected cash flow, using financial models and reporting Recommend contributions and/or distributions to investors Understand and ensure adherence to fee structure on each deal Update and maintain accurate waterfall models for various equity structures Provide investor administration support, including the delivery of capital calls, distribution notices, and investor reportingDebt ManagementOversee timely and efficient construction loan draws to maximize proceedsEnsure full compliance with all loan agreements and analyze proforma covenant complianceQualificationsUndergraduate bachelor’s degree in real estate, Finance, Accounting, or related discipline or an equivalent combination of education and experienceInterest and/or experience in private equityMinimum 2-4 years of experience in financial analysis environment; mortgage orCommercial Real Estate industry is preferred.Skilled At Financial Modeling In MS ExcelFirm understanding of Time-Value-Money fundamentalsAble to work with existing models and build custom analysesBuild meaningful and actionable graphic summariesExperience with loan and partnership agreementsAbility to prepare concise and informative written presentations in MS Word, MS Power PointWorking knowledge of Argus (RCS will enroll new analysts for certification course if needed)Detail orientedStrong organizational and communication skillsAbility to simultaneously manage multiple projects/deadlinesSelf‐motivatedAbility to work flexible hours/overtimeCreative and analytic problem solversEssential FunctionsAbility to comply with company rules and regulations.Ability to sit and stand for extended periodsAbility to communicate effectively and courteously with internal and external customers through two-way verbal and written communication (speech, hearing, and writing).Ability to operate various office equipment efficiently (computer, phone, copier, etc.)PHYSICAL DEMANDSThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.The Pay Range For This Role Is90,000 - 110,000 USD per year (Louisville)