Real Estate Financial Analyst

Software Guidance & Assistance, Inc., (SGA), is searching for a Real Estate Financial Analyst for a contract assignment with one of our premier Management Consulting clients in New York, NY. This role will primarily be remote, however it is an enormous positive if the candidate is able to come in to the downtown NYC office occasionally.Responsibilities :Lead analytics and insights for the global real estate team, including ownership of data management processes, creation and maintenance of dashboards Building and maintaining financial models to support real estate transactions, including lease scenarios and cost-benefit analyses. Tracking and updating real estate portfolio data, including lease expirations, occupancy levels, and operating expenses providing regular reports to leadership on transaction pipeline and actuals to budget reporting Conducting market research on real estate trends, rental rates, and competitive benchmarks. Serve as expert on relevant systems and tools; develop and lead training, as appropriate. Establish foundations for data infrastructure and practices to serve individual teams' needs with applicable insights and varied analytics approaches. Ensure teams' strategic decisions and roadmaps are informed by data. Develop data products that cover relevant data from multiple teams and are widely accessible and reusable within the group. Enable reporting that aligns with department goals and strategies. Frames key discussions on ongoing efforts to drive and accelerate knowledge development, innovation, continuous improvement and solution creation. Ensure deep understanding of the needs and aspirations of stakeholders and users to build requirements and objectives Provide thought partnership and analytical support to relevant Firm leaders, scoping and independently driving complex analyses Responsible for delivery of ESG and risk strategies Identify trends and gaps, share expertise with cells to ensure full understanding of market and options for robust solution creation Core responsibilities Owns the analytics for the corporate real estate team including data management, dashboard creation and maintenance, and financial analysis and modeling to evaluate transactions and portfolio strategies. Responsible for researching market trends and occupancy data to identify opportunities and risks, managing lease data and space utilization to optimize costs, developing reports and dashboards to communicate key real estate metrics, and collaborating cross-functionally with finance, legal, and operations teams to align real estate strategies with broader business objectives. Collaborates with Real Estate Director and other real estate colleagues to drive the analytical agenda across the team globally. Required Skills:5+ years of relevant experience, with at least 2-3 years in analytics or professional services in real estate Real Estate & Market KnowledgeStrong grasp of commercial real estate principles (leasing, acquisitions, dispositions) Familiarity with Life cycle of a real estate asset (from development to disposition) Understanding of market trends, occupancy rates, and competitive benchmarking Real estate market indicators (vacancy, absorption, rental rates, etc.) Financial & Analytical SkillsSkilled in financial modeling and lease analysis (e.g., NPV, scenario analysis) Ability to assess NPV, cap rates, IRR, and DCF Experience with budgeting, forecasting, and tracking real estate expenses Lease financial structures (e.g., gross, net, triple-net leases) Executive-level data storytelling: Expert in distilling complex datasets and KPIs into clear, high-impact visuals using Excel and PowerPoint to drive decision-making and influence senior stakeholders. Data Management & TechnologyAdvanced Excel skills (including pivot tables, modeling) Proficiency in reporting tools (Power BI, Tableau); SQL knowledge is a plus Legal & Compliance UnderstandingBasic understanding of lease agreements and key clauses (e.g., CAM, TI, rent escalations) Communication & CollaborationStrong communication and presentation skills Proven ability to partner effectively with finance, legal, and operations teams Detail-oriented, analytical, and proactive in addressing real estate challenges SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy