KETTLER
Join to apply for the
Portfolio Analytics Analyst
role at
KETTLER Join to apply for the
Portfolio Analytics Analyst
role at
KETTLER The Portfolio Analytics Analyst will provide analytical support to the Investments, Asset Management and Development teams by developing financial pro forma models, building financial waterfall models, and monthly/quarterly performance reporting.
Responsibilities
Create pro-forma cash flow models for new acquisitions, existing investments and new development projects for a variety of asset types like multifamily, condo, office and retail. Model complex joint venture structures via waterfall distribution analysis. Compile a quarterly summary of key portfolio metrics, maintain fund models, and create portfolio overview presentations. Support the team by analyzing data to prepare real estate valuations and provide portfolio-level forecasts for strategic review. Design and develop interactive dashboards and reports in Power BI Desktop Connect data sources including excel, SQL databases, SharePoint and cloud-based platforms. Assist the valuation process by reviewing discount rates, cash flow projections and cap rates across the portfolio. Assist in drafting investment committee memorandum and miscellaneous offering packages.
Qualifications
Must have a bachelor’s degree in a related Finance, Economics, or other quantitative discipline. Must have a minimum of 1 year of experience building financial and waterfall models. Experience working in an environment that requires recurring deliverables as well as projects and initiatives in support of a rapidly growing business. Detail oriented with the ability to manage a diverse number of tasks simultaneously. Proficiency in Microsoft Office Suite (Excel, Word, Power Point) Experience with reporting tools (PowerBI, Tableau, iLEVEL), and programming language (Python, SQL) Acquisition, Capital Markets, Asset Management and Development experience helpful
The above-referenced position summary is a guideline designed to present an overview of the job duties and is not intended to be a comprehensive list of responsibilities and requirements. Seniority level
Seniority level Entry level Employment type
Employment type Full-time Job function
Job function Business Development and Sales Referrals increase your chances of interviewing at KETTLER by 2x Get notified about new Analytics Analyst jobs in
McLean, VA . Chantilly, VA $115,000.00-$155,000.00 2 days ago Washington DC-Baltimore Area $50.00-$80.00 4 days ago District of Columbia, United States 1 month ago Washington, DC $75,000.00-$95,000.00 1 month ago Washington, DC $95,000.00-$112,000.00 2 months ago Washington, DC $92,656.00-$150,000.00 21 hours ago Arlington, VA $110,000.00-$125,000.00 1 week ago Business Intelligence and Data Analytics Consultant
Washington, DC $80,000.00-$100,000.00 2 days ago Washington DC-Baltimore Area $60,000.00-$70,000.00 1 day ago Management and Program Analyst (Data Analyst)
Bethesda, MD $135,000.00-$165,000.00 2 weeks ago Washington DC-Baltimore Area $95,000.00-$110,000.00 3 days ago Annapolis Junction, MD $49,996.80-$290,004.00 6 days ago Data Analyst - People Analytics (Short-Term Employment)
Washington, DC $124,000.00-$176,000.00 1 day ago City of Washington County, DC $60,963.00-$78,942.00 1 day ago North Bethesda, MD $55,000.00-$125,000.00 2 months ago District of Columbia, United States $83,000.00-$103,500.00 2 weeks ago Adelphi, MD $95,000.00-$120,000.00 1 month ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Portfolio Analytics Analyst
role at
KETTLER Join to apply for the
Portfolio Analytics Analyst
role at
KETTLER The Portfolio Analytics Analyst will provide analytical support to the Investments, Asset Management and Development teams by developing financial pro forma models, building financial waterfall models, and monthly/quarterly performance reporting.
Responsibilities
Create pro-forma cash flow models for new acquisitions, existing investments and new development projects for a variety of asset types like multifamily, condo, office and retail. Model complex joint venture structures via waterfall distribution analysis. Compile a quarterly summary of key portfolio metrics, maintain fund models, and create portfolio overview presentations. Support the team by analyzing data to prepare real estate valuations and provide portfolio-level forecasts for strategic review. Design and develop interactive dashboards and reports in Power BI Desktop Connect data sources including excel, SQL databases, SharePoint and cloud-based platforms. Assist the valuation process by reviewing discount rates, cash flow projections and cap rates across the portfolio. Assist in drafting investment committee memorandum and miscellaneous offering packages.
Qualifications
Must have a bachelor’s degree in a related Finance, Economics, or other quantitative discipline. Must have a minimum of 1 year of experience building financial and waterfall models. Experience working in an environment that requires recurring deliverables as well as projects and initiatives in support of a rapidly growing business. Detail oriented with the ability to manage a diverse number of tasks simultaneously. Proficiency in Microsoft Office Suite (Excel, Word, Power Point) Experience with reporting tools (PowerBI, Tableau, iLEVEL), and programming language (Python, SQL) Acquisition, Capital Markets, Asset Management and Development experience helpful
The above-referenced position summary is a guideline designed to present an overview of the job duties and is not intended to be a comprehensive list of responsibilities and requirements. Seniority level
Seniority level Entry level Employment type
Employment type Full-time Job function
Job function Business Development and Sales Referrals increase your chances of interviewing at KETTLER by 2x Get notified about new Analytics Analyst jobs in
McLean, VA . Chantilly, VA $115,000.00-$155,000.00 2 days ago Washington DC-Baltimore Area $50.00-$80.00 4 days ago District of Columbia, United States 1 month ago Washington, DC $75,000.00-$95,000.00 1 month ago Washington, DC $95,000.00-$112,000.00 2 months ago Washington, DC $92,656.00-$150,000.00 21 hours ago Arlington, VA $110,000.00-$125,000.00 1 week ago Business Intelligence and Data Analytics Consultant
Washington, DC $80,000.00-$100,000.00 2 days ago Washington DC-Baltimore Area $60,000.00-$70,000.00 1 day ago Management and Program Analyst (Data Analyst)
Bethesda, MD $135,000.00-$165,000.00 2 weeks ago Washington DC-Baltimore Area $95,000.00-$110,000.00 3 days ago Annapolis Junction, MD $49,996.80-$290,004.00 6 days ago Data Analyst - People Analytics (Short-Term Employment)
Washington, DC $124,000.00-$176,000.00 1 day ago City of Washington County, DC $60,963.00-$78,942.00 1 day ago North Bethesda, MD $55,000.00-$125,000.00 2 months ago District of Columbia, United States $83,000.00-$103,500.00 2 weeks ago Adelphi, MD $95,000.00-$120,000.00 1 month ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr