The Amherst Group of companies comprise of leading real estate investment and advisory firms with a mission to transform the way real estate is owned, financed and managed. Amherst leverages its proprietary data, analytics, technology, and decades of experience to seek solutions for a fragmented, slow-to-evolve real estate ecosystem and to materially improve the experience for residents, buyers, sellers, communities, and investors. Today Amherst has over 1000 employees and $14.1 billion in assets under management.
Over the past decade, Amherst has scaled its platform to become one of the largest operators of single-family assets and has acquired, renovated, and leased more than 46,000 homes across 32 markets in the U.S. The firm delivers customized, stabilized cash-flowing portfolios of assets to its investors, wrapped in all the ongoing services required to manage, own, and finance the asset including property management, portfolio management, and a full capital markets team. In addition to its single-family rental platform, Amherst’s debt business pursues two distinct credit strategies in mortgage-backed securities and commercial real estate lending. Over its 25-year history, Amherst has developed a deep bench of research and technology talent, and leverages data and analytics at every stage in the asset lifecycle to improve operations and preserve long-term value for our investors and the more than 188,000 residents the firm has served.
Duties and Responsibilities:
Collaborate directly with peers and business leaders in developing descriptive, diagnostic, predictive and prescriptive analytics solutions
Tackle complex business problems by converting raw data into meaningful and actionable business insights.
Utilize Microsoft SQL Server for extraction and analysis of data from multiple sources with demonstrated ability to effectively decipher, analyze and report data
Develop reports and dashboards using Tableau or other tools for internal and external customers
Leverage analytic problem-solving skills in working with large disparate, datasets to report portfolio operational metrics and performance
Present findings and recommendations to business leadership
Assist with preparation and automation of recurring /ad-hoc reporting assignments
Bachelor’s degree in Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering or related quantitative discipline
2-4 years’ experience analyzing data, drawing conclusions and making recommendations; consulting or financial services industry experience is a plus
Strong SQL query writing and optimization skills required. Experience working in a Microsoft SQL Server environment is preferred.
Experience with creating and presenting management dashboards and reports
Experience with data visualization and business intelligence tools such as Tableau, WebFOCUS, TIBCO Spotfire, Qlikview, Microstrategy. Experience with Tableau is preferred.
Strong Microsoft Excel skills
Knowledge of at least one other data analytics programming language such as Python or R. Experience with Python and analytics libraries such as Pandas, NumPy, Matplotlib etc. is preferred.
Ability to be flexible and work in a fast-paced environment while meeting established timelines
Knowledge of advanced data science concepts such as machine learning and AI
Excellent written and verbal communication
Analytical mindset and passion for gleaning actionable insights from raw data
Familiarity with SCRUM or similar agile discipline is preferred
Strong team player
Strong communication skills, with an ability to express relevant, technical concepts in a clear and concise manner
Ability to see the big picture and effectively analyze complex issues
Strong technical ability, willing to learn and evolve your skills with advances in Technology
Knowledge of data warehousing and ETL concepts is a plus
Experience with Big Data technologies such as Hadoop and Hive is a plus
Our full-time employee benefits include:
A competitive compensation package, annual bonus, 401k match
Flexible PTO including 7 paid holidays, 1 floating holiday, and 1 volunteer day
Employer-paid benefits (medical, dental, vision, health savings account)
Professional career development and reimbursement
Up to 16 weeks paid maternity leave; up to 4 weeks of paid parental leave
Backup childcare offered through Bright Horizons
Relaxed casual environment with virtual office events
Amherst is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.