Business Intern at Avison Young in Washington, DC

Summary: Avison Young is a global commercial real estate brokerage and advisory firm, committed to providing a comprehensive suite of services while fostering a supportive workplace culture. The Business Intern will support the U.S. executive team by delivering data-driven insights that inform enterprise growth decisions, focusing on modeling, reporting, and visualization. Responsibilities: - Build and maintain analytical models in Excel to support growth strategy, client prioritization, and market analysis - Develop and enhance Power BI dashboards and visualizations used by U.S. leadership - Aggregate, clean, and analyze data from multiple internal and external sources - Support preparation of executive-level presentations and strategy materials - Translate data and analysis into clear insights and concise storylines for leadership review - Assist in ongoing reporting, ad hoc analysis, and strategic research projects - Learn the firm’s service lines, business units, and markets to contextualize analysis and insights Required Qualifications: - Currently pursuing a degree in Business Analytics, Finance, Economics, Data Science, Statistics, or a related field - Strong proficiency in Microsoft Excel (modeling, formulas, pivot tables; VBA a plus) - Experience with or strong interest in Power BI (or similar BI tools) - Comfortable working with large datasets and synthesizing insights - Strong written and verbal communication skills, including comfort presenting to senior audiences - Curious, detail-oriented, and eager to learn how data informs business strategy Required Skills: Microsoft Excel, Excel modeling, Excel formulas, Excel pivot tables, Excel VBA, Power BI, Business analytics, Data analysis, Data visualization, Data cleaning, Data aggregation, Curiosity Benefits: Traditional and Roth 401k with generous employer match and immediate vesting, 12 weeks of Paid Parental Leave after one year of tenure, Medical, Dental, Vision Insurance, Company paid Life and AD&D Insurance, Company paid Short & Long-Term Disability, Voluntary Critical Illness and Accident Coverage, Healthcare, Dependent Care, Commuter & Transit Pre-Tax Benefits, Wellness program, Employee Assistance Program (EAP), Competitive paid vacation days, 2 personal/wellness days, Paid holidays plus 2 floating holidays, Annual volunteer day for Day of Giving