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.
Key Responsibilities
Design, develop, and maintain dashboards and analytical models used by operational and executive teams.
Translate business requirements into well-defined metrics, standardized KPIs, and scalable data structures.
Develop, optimize, and tune complex SQL queries across large datasets.
Ensure data quality, consistency, and integrity across reports and analytical outputs.
Partner with Data Engineering to improve data models, pipelines, and overall warehouse architecture.
Contribute to the design and enhancement of data marts and semantic layers.
Analyze trends, identify anomalies, and provide actionable insights to stakeholders.
Document metric definitions, business logic, and data models to ensure transparency and governance.
Improve dashboard performance and optimize query execution times.
Job Requirements
Minimum Requirements:
5+ years of experience in Business Intelligence, Analytics, or related roles.
Advanced SQL proficiency (complex joins, window functions, aggregations, query tuning).
Experience working with enterprise Data Warehouses (SQL Server, Databricks, Snowflake or similar).
Experience with BI visualization tools (Tableau, Power BI, or similar).
Experience working with operational performance metrics (SLAs, efficiency, cost analysis, etc.).
Ability to work with large datasets and optimize performance.
Preferred Qualifications:
Familiarity with ETL processes and data pipelines.
Strong understanding of dimensional modeling (star schema, fact/dimension design, SCD concepts).
Functional and Behavioral Skills
Functional Skills:
Advanced SQL and query performance optimization.
Dimensional data modeling (star schema, SCD, fact/dimension design).
Dashboard design and data visualization best practices.
Data warehouse architecture fundamentals.
KPI definition, metric standardization, and business logic documentation.
Behavioral Skills:
Strong analytical and structured thinking.
Deep understanding of operational processes and performance metrics.
Ability to challenge and refine metric definitions constructively.
High attention to detail and commitment to data accuracy.
Self-driven and capable of working independently in a fast-paced environment.
Clear and effective communicator with both technical and non-technical stakeholders.
Our full-time employee benefits include:
A competitive and comprehensive benefits package.
Top Skills
What We Do
The Amherst Group ("Amherst") is a diversified data-driven investment management platform at the crossroads of global capital markets and U.S. real estate, offering strategies up and down the real estate capital stack. As of December 31, 2023, Amherst manages $18.5 billion deployed across real estate debt and equity strategies in mortgage-backed securities, commercial real estate, and single-family residential.
.png){kind=logo}
