Analyst

U3 Advisors (U3) works at the intersection of campus and city. We advance institutional missions through transformative economic, real estate, and programmatic strategies that positively impact communities.

• Collect, organize, and clean large datasets (50,000+ records) within Excel; run analytics using Excel and potentially Tableau.
• Utilize Geographic Information Systems (ArcGIS Desktop or ArcGIS Pro) to create maps and perform spatial analytics; load maps and interactive databases onto ArcGIS Online;
• Analyze market, real estate, demographic, and institutional data; research best practices for urban real estate and economic development and current market trends or environments;
• Coordinate and schedule project team meetings, prepare agendas and meeting minutes, and follow up on assignments;
• Prepare PowerPoint presentations, reports, memos, and other materials for current clients;
• Prepare project work plans, budgets, and schedules;
• Assist in business development including drafting proposals, development of responses to RFPs for consulting services, and preparation of marketing materials for prospective clients;
• Coordinate and provide support to project team members, including design and construction professionals, attorneys, financial advisors, and planning consultants.

• Recent graduate of an undergraduate program with an interest in real estate, economic development, consulting, planning, or a related field, and a strong interest in and penchant for data management and analytics. Previous work experience and/or coursework should demonstrate strong analytical skills.
• Demonstrated understanding of parcel data analysis and real estate trend analysis.
• Experience and high proficiency with Microsoft Excel, especially in managing larger datasets; experience with database structure (rows/columns), advanced functions (vLookUp, IF, etc), and Pivot Tables a plus.
• Experience in working with GIS, especially ArcGIS and/or ArcPro. Experience with ArcGIS Online is a plus.
• Self-motivated; ability to execute tasks independently with minimal instruction. High proficiency in organization and time management.
• Excellent interpersonal skills and professional demeanor, especially when communicating with clients; an ability to actively listen to clients and teammates.
• Fluency in Microsoft PowerPoint, Word, and Excel.
• Working knowledge of Adobe Creative Suite and Tableau and a design aesthetic is preferred but not required.
• A passion for cities, neighborhoods, active streets, and strong communities.
• Ability to contribute to and mesh with a collegial company culture, to work with grace under pressure, and to thrive in a fast-paced entrepreneurial environment.
• The ideal candidate will be located in Philadelphia, Boston, or New York.

• Medical and Insurance: 100% employer-paid medical, dental, and vision care insurance, life insurance, and long-term disability; up to ten paid days of sick/medical leave per calendar year
• Vacation: four weeks of paid time off (PTO) per calendar year; 10 paid federal holidays.
• Retirement: optional self-funded 401(k) plan with employer match up to 4% of salary, eligible after one year of employment.
• Technology: iPhone, phone plan, and mac computer provided.
• Travel: annual in-person company-wide staff retreat, fall and spring staff meetings, and opportunity to travel to clients.
• Work Environment: flexible and hybrid work environment.