Financial Analyst-Real Estate

Pyramid Consulting, Inc; New York (NY); Hybrid; USD 52,000 - 66,000; Full time

Benefits offered by this job

Health insurance (medical, dental, and

401(k) plan

Paid sick leave

Job summary

Pyramid Consulting, Inc. seeks a Financial Analyst-Real Estate for a 12-month contract in New York, NY (Hybrid). The role focuses on analyzing financials for a large store portfolio, including lease costs, occupancy, CAM, and construction expenses.

You will build dashboards using Power BI, Excel, and SQL, and support annual budgeting and forecasting. The ideal candidate will partner with real estate, construction, facilities, and procurement teams to drive cost efficiency and accurate reporting

Qualifications

• Proven ability to deliver executive-level financial reporting.
• Strong skills in budgeting, forecasting, and variance analysis.
• Experience analyzing real estate operating costs and occupancy expenses.
• Ability to create dashboards and insights from data.

Responsibilities

• Analyze monthly financial performance for a portfolio of stores and locations.
• Evaluate lease-related expenses, occupancy costs, CAM charges, taxes, utilities, and other real estate costs.
• Analyze capital construction expenditures and new store development costs.
• Develop monthly, quarterly, and annual reporting packages for executives.
• Create dashboards summarizing lease expenses, construction spending, occupancy costs, and budget vs. actuals.
• Automate recurring reports using Power BI, Excel, and SQL where possible.
• Support budgeting and quarterly forecasting for occupancy and construction expenses.
• Assist long-range financial planning for the real estate portfolio.
• Coordinate with vendors for Purchase Orders and manage accruals.

Skills

Executive Reporting

Budgeting & Forecasting

Occupancy Cost Management

Lease Cost Analysis

Tools

Power BI

Excel

SQL

Job description

Immediate need for a talented Financial Analyst-Real Estate. This is a 12 months contract opportunity with long-term potential and is located in New York, NY(Hybrid).

Job ID: 26-24355

Pay Range: $25/hr - $31.50/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Candidates must be located near New York office. Work will require some travel to sites within New York.
• Analyze monthly financial performance profit and loss statements for a portfolio of 669567 TurboTax Retail Stores and Expert Office locations.
• Evaluate lease-related expenses, occupancy costs, CAM charges, taxes, utilities, and other real estate operating expenses.
• Analyze capital construction expenditures, remodel projects, and new store development costs.
• Identify cost trends, spending variances, and opportunities for cost optimization.
• Partner with Accounting to ensure accurate expense allocation and financial reporting.
• Develop and maintain monthly, quarterly, and annual financial reporting packages for executive leadership.
• Create dashboards that summarize:
• Lease expenses
• Construction spending
• Occupancy costs
• Budget vs. Actual performance
• Forecasts
• Key performance indicators (KPIs)
• Present financial findings and recommendations to Finance leadership and business partners.
• Automate recurring reports whenever possible using Power BI, Excel, SQL, or other reporting tools.
• Budgeting & Forecasting
• Support annual budgeting and quarterly forecasting for occupancy and construction expenses.
• Monitor financial performance against budget and explain significant variances.
• Assist with long-range financial planning for the real estate portfolio.
• Responsible for the creation and management of Purchase Orders with vendors
• Responsible for the monthly accrual process with Accounting
• Business Partnership
• Collaborate with Transaction Management Real Estate, Construction, Facilities Management, and Procurement teams to understand operational drivers of expenses.
• Provide financial support for lease renewals, new store openings, relocations, and construction projects.
• Recommend strategies to improve financial performance and cost efficiency.
• Data Management
• Maintain financial models supporting lease and construction cost analysis.
• Ensure data integrity across multiple financial and operational systems.
• Consolidate information from ERP systems, lease administration platforms, and construction management tools.
• Core Competencies
• Executive Reporting
• Budgeting & Forecasting
• Occupancy Cost Management
• Lease Cost Analysis

Our client is a leading IT Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.